VIEW: APPS.OKE_PROJECTS_V

Source

View Text - Preformatted

SELECT P.ROWID , P.PROJECT_ID , P.SEGMENT1 , P.NAME , P.DESCRIPTION , P.START_DATE , P.COMPLETION_DATE , P.CARRYING_OUT_ORGANIZATION_ID , O.NAME , P.PROJECT_TYPE , T.PROJECT_TYPE_CLASS_CODE , P.PROJECT_STATUS_CODE , S.PROJECT_STATUS_NAME , T.ALLOWABLE_FUNDING_LEVEL_CODE , DECODE(T.PROJECT_TYPE_CLASS_CODE, 'CONTRACT', NVL(L2.MEANING, L.MEANING), NULL) , P.PROJECT_LEVEL_FUNDING_FLAG FROM PA_PROJECTS_ALL P , PA_PROJECT_STATUSES S , PA_PROJECT_TYPES_ALL T , HR_ORGANIZATION_UNITS O , PA_LOOKUPS L , PA_LOOKUPS L2 WHERE P.PROJECT_STATUS_CODE = S.PROJECT_STATUS_CODE AND S.STATUS_TYPE = 'PROJECT' AND O.ORGANIZATION_ID = P.CARRYING_OUT_ORGANIZATION_ID AND T.PROJECT_TYPE = P.PROJECT_TYPE AND NVL(T.ORG_ID , -999) = NVL(P.ORG_ID , -999) AND L2.LOOKUP_TYPE (+) = 'ALLOWABLE FUNDING LEVEL' AND L2.LOOKUP_CODE (+) = DECODE(P.PROJECT_LEVEL_FUNDING_FLAG, 'Y', 'P', 'N', 'T', NULL) AND L.LOOKUP_TYPE (+) = 'ALLOWABLE FUNDING LEVEL' AND L.LOOKUP_CODE (+) = DECODE( T.PROJECT_TYPE_CLASS_CODE , 'CONTRACT' , T.ALLOWABLE_FUNDING_LEVEL_CODE , NULL )

View Text - HTML Formatted

SELECT P.ROWID
, P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, P.DESCRIPTION
, P.START_DATE
, P.COMPLETION_DATE
, P.CARRYING_OUT_ORGANIZATION_ID
, O.NAME
, P.PROJECT_TYPE
, T.PROJECT_TYPE_CLASS_CODE
, P.PROJECT_STATUS_CODE
, S.PROJECT_STATUS_NAME
, T.ALLOWABLE_FUNDING_LEVEL_CODE
, DECODE(T.PROJECT_TYPE_CLASS_CODE
, 'CONTRACT'
, NVL(L2.MEANING
, L.MEANING)
, NULL)
, P.PROJECT_LEVEL_FUNDING_FLAG
FROM PA_PROJECTS_ALL P
, PA_PROJECT_STATUSES S
, PA_PROJECT_TYPES_ALL T
, HR_ORGANIZATION_UNITS O
, PA_LOOKUPS L
, PA_LOOKUPS L2
WHERE P.PROJECT_STATUS_CODE = S.PROJECT_STATUS_CODE
AND S.STATUS_TYPE = 'PROJECT'
AND O.ORGANIZATION_ID = P.CARRYING_OUT_ORGANIZATION_ID
AND T.PROJECT_TYPE = P.PROJECT_TYPE
AND NVL(T.ORG_ID
, -999) = NVL(P.ORG_ID
, -999)
AND L2.LOOKUP_TYPE (+) = 'ALLOWABLE FUNDING LEVEL'
AND L2.LOOKUP_CODE (+) = DECODE(P.PROJECT_LEVEL_FUNDING_FLAG
, 'Y'
, 'P'
, 'N'
, 'T'
, NULL)
AND L.LOOKUP_TYPE (+) = 'ALLOWABLE FUNDING LEVEL'
AND L.LOOKUP_CODE (+) = DECODE( T.PROJECT_TYPE_CLASS_CODE
, 'CONTRACT'
, T.ALLOWABLE_FUNDING_LEVEL_CODE
, NULL )