[Home] [Help]
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
Name |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_ID |
PROJECT_TYPE_CLASS_CODE |
PROJECT_STATUS_CODE |
ORG_ID |
OPERATING_UNIT |