View: PSBFV_POSITIONS

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSBFV_POSITIONS

View Text

SELECT DE.DATA_EXTRACT_NAME
, POS.NAME
, POS.EFFECTIVE_START_DATE
, POS.EFFECTIVE_END_DATE
, EMP.EMPLOYEE_NUMBER
, EMP.FULL_NAME
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 1
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR1
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 2
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR2
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 3
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR3
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 4
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR4
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 5
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR5
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 6
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR6
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 7
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR7
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 8
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR8
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 9
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR9
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 10
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR10
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 11
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR11
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 12
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR12
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 13
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR13
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 14
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR14
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 15
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR15
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 16
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR16
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 17
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR17
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 18
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR18
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 19
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR19
, MAX(DECODE(PAT.DISPLAY_SEQUENCE
, 20
, DECODE(PAS.ATTRIBUTE_VALUE_ID
, NULL
, PAS.ATTRIBUTE_VALUE
, PATV.ATTRIBUTE_VALUE)
, NULL)) ATTR20
, POS.NEW_POSITION_FLAG
, POS.POSITION_ID
, POS.DATA_EXTRACT_ID
, EMP.EMPLOYEE_ID
FROM PSB_DATA_EXTRACTS DE
, PSB_POSITIONS POS
, PSB_POSITION_ASSIGNMENTS PAS
, PSB_POSITION_ASSIGNMENTS PAE
, PSB_ATTRIBUTES PAT
, PSB_ATTRIBUTE_VALUES PATV
, PSB_EMPLOYEES EMP
WHERE DE.DATA_EXTRACT_ID = POS.DATA_EXTRACT_ID
AND PAS.POSITION_ID = POS.POSITION_ID
AND PAS.ATTRIBUTE_ID = PAT.ATTRIBUTE_ID
AND PAT.DISPLAY_IN_WORKSHEET = 'Y'
AND PAS.ASSIGNMENT_TYPE = 'ATTRIBUTE'
AND PAS.ATTRIBUTE_VALUE_ID = PATV.ATTRIBUTE_VALUE_ID(+)
AND PAE.POSITION_ID(+) = POS.POSITION_ID
AND PAE.ASSIGNMENT_TYPE(+) = 'EMPLOYEE'
AND PAE.EMPLOYEE_ID = EMP.EMPLOYEE_ID(+) GROUP BY DE.DATA_EXTRACT_NAME
, POS.NAME
, POS.EFFECTIVE_START_DATE
, POS.EFFECTIVE_END_DATE
, EMP.EMPLOYEE_NUMBER
, EMP.FULL_NAME
, POS.NEW_POSITION_FLAG
, POS.POSITION_ID
, POS.DATA_EXTRACT_ID
, EMP.EMPLOYEE_ID WITH READ ONLY

Columns