View: PA_PROJECTS_V_PAXTRAPE

Product:	PA - Projects
Description:	For bug 2556167 to be used for record group in PAXTRAPE Only
Implementation/DBA Data:	APPS.PA_PROJECTS_V_PAXTRAPE

View Text

SELECT PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ID
, PROJECT_TYPE_CLASS_CODE
, PROJECT_STATUS_CODE
, ORG_ID
, OPERATING_UNIT
FROM PA_PROJECTS_BASIC_V
WHERE TEMPLATE_FLAG <> 'Y'
AND PA_EXPENDITURE_INQUIRY.GET_MODE = 'PROJECT'
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_IN_PURGE_STATUS(PROJECT_STATUS_CODE) <> 'Y' UNION ALL SELECT PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ID
, PROJECT_TYPE_CLASS_CODE
, PROJECT_STATUS_CODE
, ORG_ID
, OPERATING_UNIT
FROM PA_PROJECTS_ALL_BASIC_V
WHERE PA_EXPENDITURE_INQUIRY.GET_MODE = 'CROSS-PROJECT'
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_IN_PURGE_STATUS(PROJECT_STATUS_CODE) <> 'Y'

Columns