VIEW: APPS.PER_POS_STRUCTURE_ELEMENTS_V

Source

View Text - Preformatted

SELECT NVL (PSE.ROWID, POS.ROWID) , NVL (PSE.POS_STRUCTURE_ELEMENT_ID, 0) , NVL (PSE.BUSINESS_GROUP_ID, POS.BUSINESS_GROUP_ID) , NVL (PSE.POS_STRUCTURE_VERSION_ID, 0) , NVL (PSE.SUBORDINATE_POSITION_ID, POS.POSITION_ID) , POS.ORGANIZATION_ID , NVL (PSE.PARENT_POSITION_ID, 0) , NVL (PSE.REQUEST_ID, POS.REQUEST_ID) , NVL (PSE.PROGRAM_APPLICATION_ID, POS.PROGRAM_APPLICATION_ID) , NVL (PSE.PROGRAM_ID, POS.PROGRAM_ID) , NVL (PSE.PROGRAM_UPDATE_DATE, POS.PROGRAM_UPDATE_DATE) , NVL (PSE.LAST_UPDATE_DATE, POS.LAST_UPDATE_DATE) , NVL (PSE.LAST_UPDATED_BY, POS.LAST_UPDATED_BY) , NVL (PSE.LAST_UPDATE_LOGIN, POS.LAST_UPDATE_LOGIN) , NVL (PSE.CREATED_BY, POS.CREATED_BY) , NVL (PSE.CREATION_DATE, POS.CREATION_DATE) , HR_GENERAL.DECODE_POSITION_LATEST_NAME(POS.POSITION_ID) FROM PER_POS_STRUCTURE_ELEMENTS PSE , HR_ALL_POSITIONS_F POS , HR_ALL_POSITIONS_F_TL PFT WHERE PSE.SUBORDINATE_POSITION_ID (+) = POS.POSITION_ID AND POS.EFFECTIVE_END_DATE = TO_DATE('31124712', 'DDMMYYYY') AND POS.POSITION_ID = PFT.POSITION_ID AND PFT.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT NVL (PSE.ROWID
, POS.ROWID)
, NVL (PSE.POS_STRUCTURE_ELEMENT_ID
, 0)
, NVL (PSE.BUSINESS_GROUP_ID
, POS.BUSINESS_GROUP_ID)
, NVL (PSE.POS_STRUCTURE_VERSION_ID
, 0)
, NVL (PSE.SUBORDINATE_POSITION_ID
, POS.POSITION_ID)
, POS.ORGANIZATION_ID
, NVL (PSE.PARENT_POSITION_ID
, 0)
, NVL (PSE.REQUEST_ID
, POS.REQUEST_ID)
, NVL (PSE.PROGRAM_APPLICATION_ID
, POS.PROGRAM_APPLICATION_ID)
, NVL (PSE.PROGRAM_ID
, POS.PROGRAM_ID)
, NVL (PSE.PROGRAM_UPDATE_DATE
, POS.PROGRAM_UPDATE_DATE)
, NVL (PSE.LAST_UPDATE_DATE
, POS.LAST_UPDATE_DATE)
, NVL (PSE.LAST_UPDATED_BY
, POS.LAST_UPDATED_BY)
, NVL (PSE.LAST_UPDATE_LOGIN
, POS.LAST_UPDATE_LOGIN)
, NVL (PSE.CREATED_BY
, POS.CREATED_BY)
, NVL (PSE.CREATION_DATE
, POS.CREATION_DATE)
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(POS.POSITION_ID)
FROM PER_POS_STRUCTURE_ELEMENTS PSE
, HR_ALL_POSITIONS_F POS
, HR_ALL_POSITIONS_F_TL PFT
WHERE PSE.SUBORDINATE_POSITION_ID (+) = POS.POSITION_ID
AND POS.EFFECTIVE_END_DATE = TO_DATE('31124712'
, 'DDMMYYYY')
AND POS.POSITION_ID = PFT.POSITION_ID
AND PFT.LANGUAGE = USERENV('LANG')