View: OKE_PROJECTS_V

Product:	OKE - Project Contracts
Description:	Valid project listing
Implementation/DBA Data:	APPS.OKE_PROJECTS_V

View Text

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 )

Columns