\n\tSELECT FFV.DESCRIPTION \u673a\u6784\u63cf\u8ff0,
\n\t PP.NAME \u804c\u4f4d,
\n\t FU.DESCRIPTION \u63cf\u8ff0,
\n\t PA.AGENT_ID \u91c7\u8d2d\u5458ID,
\n\t FU.USER_ID \u7528\u6237ID,
\n\t FU.USER_NAME \u7cfb\u7edf\u540d\u79f0,
\n\t PPF.FULL_NAME \u5168\u540d,
\n\t PPF.EMPLOYEE_NUMBER \u5458\u5de5\u7f16\u53f7\n<\/p>\n
\n\t FROM PER_PEOPLE_F PPF,
\n\t PER_ASSIGNMENTS_F PAF,
\n\t PER_POSITIONS PP,
\n\t FND_USER FU,
\n\t PO_AGENTS PA,
\n\t FND_FLEX_VALUES_VL FFV,
\n\t FND_FLEX_VALUE_SETS FF
\n\t WHERE PPF.PERSON_ID = PAF.PERSON_ID
\n\t AND FFV.FLEX_VALUE_SET_ID = FF.FLEX_VALUE_SET_ID
\n\t AND FFV.ENABLED_FLAG = 'Y'
\n\t AND (FFV.END_DATE_ACTIVE IS NULL OR FFV.END_DATE_ACTIVE > SYSDATE)
\n\t AND FFV.FLEX_VALUE = SUBSTR(PP.NAME, 1, INSTR(PP.NAME, '.', 1, 1) – 1)
\n\t AND FF.FLEX_VALUE_SET_NAME = '&ORG_COA'
\n\t AND FFV.SUMMARY_FLAG = 'N'
\n\t AND PA.AGENT_ID = PPF.PERSON_ID
\n\t AND FU.EMPLOYEE_ID = PPF.PERSON_ID
\n\t AND PP.POSITION_ID = PAF.POSITION_ID
\n\t AND PPF.PERSON_ID IN
\n\t (SELECT DISTINCT PA.AGENT_ID
\n\t FROM PO_AGENTS PA, PER_ALL_PEOPLE_F PAPF, FND_USER FU
\n\t WHERE PA.AGENT_ID = PAPF.PERSON_ID
\n\t AND FU.EMPLOYEE_ID = PAPF.PERSON_ID
\n\t AND (PAPF.EMPLOYEE_NUMBER IS NOT NULL OR
\n\t PAPF.NPW_NUMBER IS NOT NULL)
\n\t AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND
\n\t PAPF.EFFECTIVE_END_DATE)
\n\t AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE
\n\t AND SYSDATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE
\n\t AND (FU.END_DATE IS NULL OR FU.END_DATE > SYSDATE)
\n\t AND (PP.DATE_END IS NULL OR PP.DATE_END > SYSDATE)
\n\t ORDER BY PP.NAME, FU.CREATION_DATE DESC;<\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT FFV.DESCRIPTION \u673a\u6784\u63cf\u8ff0,   … \u7ee7\u7eed\u9605\u8bfb\u83b7\u53d6\u91c7\u8d2d\u5458\u76f8\u5173\u4fe1\u606fSQL<\/span>