eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PER_POS_STRUCTURE_ELEMENTS_V2

Source

View Text - Preformatted


SELECT PPSE.POS_STRUCTURE_ELEMENT_ID , PPSE.ROWID , PPSE.BUSINESS_GROUP_ID , PPSE.POS_STRUCTURE_VERSION_ID , PPSE.SUBORDINATE_POSITION_ID , PPS.NAME , PPSE.PARENT_POSITION_ID , HR_GENERAL.DECODE_POSITION_LATEST_NAME(PPSE.PARENT_POSITION_ID) , PPSE.REQUEST_ID , PPSE.PROGRAM_APPLICATION_ID , PPSE.PROGRAM_ID , PPSE.PROGRAM_UPDATE_DATE , PPSE.LAST_UPDATE_DATE , PPSE.LAST_UPDATED_BY , PPSE.LAST_UPDATE_LOGIN , PPSE.CREATED_BY , PPSE.CREATION_DATE FROM PER_POS_STRUCTURE_ELEMENTS PPSE, PER_POS_STRUCTURE_VERSIONS PPSV, PER_POSITION_STRUCTURES PPS WHERE PPSE.POS_STRUCTURE_VERSION_ID = PPSV.POS_STRUCTURE_VERSION_ID AND PPSV.POSITION_STRUCTURE_ID = PPS.POSITION_STRUCTURE_ID

View Text - HTML Formatted

SELECT PPSE.POS_STRUCTURE_ELEMENT_ID
, PPSE.ROWID
, PPSE.BUSINESS_GROUP_ID
, PPSE.POS_STRUCTURE_VERSION_ID
, PPSE.SUBORDINATE_POSITION_ID
, PPS.NAME
, PPSE.PARENT_POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PPSE.PARENT_POSITION_ID)
, PPSE.REQUEST_ID
, PPSE.PROGRAM_APPLICATION_ID
, PPSE.PROGRAM_ID
, PPSE.PROGRAM_UPDATE_DATE
, PPSE.LAST_UPDATE_DATE
, PPSE.LAST_UPDATED_BY
, PPSE.LAST_UPDATE_LOGIN
, PPSE.CREATED_BY
, PPSE.CREATION_DATE
FROM PER_POS_STRUCTURE_ELEMENTS PPSE
, PER_POS_STRUCTURE_VERSIONS PPSV
, PER_POSITION_STRUCTURES PPS
WHERE PPSE.POS_STRUCTURE_VERSION_ID = PPSV.POS_STRUCTURE_VERSION_ID
AND PPSV.POSITION_STRUCTURE_ID = PPS.POSITION_STRUCTURE_ID