Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_ORG_STRUCTURE_VERSIONS_V |
SELECT OSV1.ROWID
, OSV1.ORG_STRUCTURE_VERSION_ID
, OSV1.BUSINESS_GROUP_ID
, OSV1.ORGANIZATION_STRUCTURE_ID
, DECODE(OSV1.COPY_STRUCTURE_VERSION_ID
, ''
, NULL
, OS1.NAME)
, OSV1.DATE_FROM
, OSV1.VERSION_NUMBER
, TO_NUMBER(DECODE(OSV1.COPY_STRUCTURE_VERSION_ID
, ''
, NULL
, OSV2.VERSION_NUMBER))
, OSV1.COPY_STRUCTURE_VERSION_ID
, OSV1.DATE_TO
, OSV1.REQUEST_ID
, OSV1.PROGRAM_APPLICATION_ID
, OSV1.PROGRAM_ID
, OSV1.PROGRAM_UPDATE_DATE
, OSV1.LAST_UPDATE_DATE
, OSV1.LAST_UPDATED_BY
, OSV1.LAST_UPDATE_LOGIN
, OSV1.CREATED_BY
, OSV1.CREATION_DATE
, OSV1.TOPNODE_POS_CTRL_ENABLED_FLAG
FROM PER_ORGANIZATION_STRUCTURES OS1
, PER_ORG_STRUCTURE_VERSIONS OSV1
, PER_ORG_STRUCTURE_VERSIONS OSV2
WHERE ((OSV1.COPY_STRUCTURE_VERSION_ID IS NOT NULL
AND OSV1.COPY_STRUCTURE_VERSION_ID = OSV2.ORG_STRUCTURE_VERSION_ID) OR (OSV1.COPY_STRUCTURE_VERSION_ID IS NULL
AND OSV1.ROWID= OSV2.ROWID))
AND OSV2.ORGANIZATION_STRUCTURE_ID = OS1.ORGANIZATION_STRUCTURE_ID(+)