View: PER_POS_STRUCTURE_VERSIONS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_POS_STRUCTURE_VERSIONS_V

View Text

SELECT PSV.ROWID
, PSV.POS_STRUCTURE_VERSION_ID
, PSV.BUSINESS_GROUP_ID
, PSV.POSITION_STRUCTURE_ID
, PSV.DATE_FROM
, PSV.VERSION_NUMBER
, PSV.COPY_STRUCTURE_VERSION_ID
, DECODE(PSV.COPY_STRUCTURE_VERSION_ID
, ''
, ''
, PST.NAME)
, TO_NUMBER(DECODE(PSV.COPY_STRUCTURE_VERSION_ID
, ''
, NULL
, PSV2.VERSION_NUMBER))
, PSV.DATE_TO
, PSV.REQUEST_ID
, PSV.PROGRAM_APPLICATION_ID
, PSV.PROGRAM_ID
, PSV.PROGRAM_UPDATE_DATE
, PSV.LAST_UPDATE_DATE
, PSV.LAST_UPDATED_BY
, PSV.LAST_UPDATE_LOGIN
, PSV.CREATED_BY
, PSV.CREATION_DATE
FROM PER_POSITION_STRUCTURES PST
, PER_POS_STRUCTURE_VERSIONS PSV
, PER_POS_STRUCTURE_VERSIONS PSV2
WHERE ((PSV.COPY_STRUCTURE_VERSION_ID IS NOT NULL
AND PSV.COPY_STRUCTURE_VERSION_ID = PSV2.POS_STRUCTURE_VERSION_ID) OR (PSV.COPY_STRUCTURE_VERSION_ID IS NULL
AND PSV.ROWID = PSV2.ROWID))
AND PSV2.POSITION_STRUCTURE_ID = PST.POSITION_STRUCTURE_ID (+)

Columns