VIEW: APPS.OKE_K_ACCESS_V

Source

View Text - Preformatted

SELECT PP.ROWID , PP.RECORD_VERSION_NUMBER , PP.PROJECT_PARTY_ID , PP.OBJECT_ID , PP.OBJECT_TYPE , KH.K_NUMBER_DISP , PP.RESOURCE_ID , PP.RESOURCE_TYPE_ID , PP.RESOURCE_SOURCE_ID , PP.PROJECT_ROLE_ID , PR.MEANING , PP.START_DATE_ACTIVE , PP.END_DATE_ACTIVE , PP.CREATION_DATE , PP.CREATED_BY , PP.LAST_UPDATE_DATE , PP.LAST_UPDATED_BY , PP.LAST_UPDATE_LOGIN FROM PA_PROJECT_PARTIES PP , PA_PROJECT_ROLE_TYPES PR , OKE_K_HEADERS KH WHERE PR.PROJECT_ROLE_ID = PP.PROJECT_ROLE_ID AND PP.OBJECT_TYPE = 'OKE_K_HEADERS' AND PP.OBJECT_ID = KH.K_HEADER_ID AND PP.RESOURCE_TYPE_ID = 101 UNION ALL SELECT PP.ROWID , PP.RECORD_VERSION_NUMBER , PP.PROJECT_PARTY_ID , DECODE( PP.OBJECT_ID , 0 , TO_NUMBER(NULL) , PP.OBJECT_ID) , DECODE( PP.OBJECT_ID , 0 , 'SITE' , PP.OBJECT_TYPE) , PG.PROGRAM_NUMBER , PP.RESOURCE_ID , PP.RESOURCE_TYPE_ID , PP.RESOURCE_SOURCE_ID , PP.PROJECT_ROLE_ID , PR.MEANING , PP.START_DATE_ACTIVE , PP.END_DATE_ACTIVE , PP.CREATION_DATE , PP.CREATED_BY , PP.LAST_UPDATE_DATE , PP.LAST_UPDATED_BY , PP.LAST_UPDATE_LOGIN FROM PA_PROJECT_PARTIES PP , PA_PROJECT_ROLE_TYPES PR , OKE_PROGRAMS PG WHERE PR.PROJECT_ROLE_ID = PP.PROJECT_ROLE_ID AND PP.OBJECT_TYPE = 'OKE_PROGRAMS' AND PP.OBJECT_ID = PG.PROGRAM_ID (+) AND PP.RESOURCE_TYPE_ID = 101

View Text - HTML Formatted

SELECT PP.ROWID
, PP.RECORD_VERSION_NUMBER
, PP.PROJECT_PARTY_ID
, PP.OBJECT_ID
, PP.OBJECT_TYPE
, KH.K_NUMBER_DISP
, PP.RESOURCE_ID
, PP.RESOURCE_TYPE_ID
, PP.RESOURCE_SOURCE_ID
, PP.PROJECT_ROLE_ID
, PR.MEANING
, PP.START_DATE_ACTIVE
, PP.END_DATE_ACTIVE
, PP.CREATION_DATE
, PP.CREATED_BY
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
, PP.LAST_UPDATE_LOGIN
FROM PA_PROJECT_PARTIES PP
, PA_PROJECT_ROLE_TYPES PR
, OKE_K_HEADERS KH
WHERE PR.PROJECT_ROLE_ID = PP.PROJECT_ROLE_ID
AND PP.OBJECT_TYPE = 'OKE_K_HEADERS'
AND PP.OBJECT_ID = KH.K_HEADER_ID
AND PP.RESOURCE_TYPE_ID = 101 UNION ALL SELECT PP.ROWID
, PP.RECORD_VERSION_NUMBER
, PP.PROJECT_PARTY_ID
, DECODE( PP.OBJECT_ID
, 0
, TO_NUMBER(NULL)
, PP.OBJECT_ID)
, DECODE( PP.OBJECT_ID
, 0
, 'SITE'
, PP.OBJECT_TYPE)
, PG.PROGRAM_NUMBER
, PP.RESOURCE_ID
, PP.RESOURCE_TYPE_ID
, PP.RESOURCE_SOURCE_ID
, PP.PROJECT_ROLE_ID
, PR.MEANING
, PP.START_DATE_ACTIVE
, PP.END_DATE_ACTIVE
, PP.CREATION_DATE
, PP.CREATED_BY
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
, PP.LAST_UPDATE_LOGIN
FROM PA_PROJECT_PARTIES PP
, PA_PROJECT_ROLE_TYPES PR
, OKE_PROGRAMS PG
WHERE PR.PROJECT_ROLE_ID = PP.PROJECT_ROLE_ID
AND PP.OBJECT_TYPE = 'OKE_PROGRAMS'
AND PP.OBJECT_ID = PG.PROGRAM_ID (+)
AND PP.RESOURCE_TYPE_ID = 101