VIEW: APPS.PER_ORG_STRUCTURE_VERSIONS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)