View: PA_PURGE_PROJECTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PURGE_PROJECTS_V

View Text

SELECT PP.ROWID ROW_ID
, P.SEGMENT1
, P.NAME
, L4.MEANING
, PP.PURGE_PROJECT_STATUS_CODE
, PP.PROJECT_ID
, O1.NAME
, P.CARRYING_OUT_ORGANIZATION_ID
, P.PROJECT_STATUS_CODE
, PS3.PROJECT_STATUS_NAME
, P.CLOSED_DATE
, P.PROJECT_TYPE
, PP.PURGE_BATCH_ID
, PP.LAST_PROJECT_STATUS_CODE
, PP.TXN_TO_DATE
, PP.PURGE_ACTUALS_FLAG
, PP.ARCHIVE_ACTUALS_FLAG
, PP.PURGE_BUDGETS_FLAG
, PP.ARCHIVE_BUDGETS_FLAG
, PP.PURGE_CAPITAL_FLAG
, PP.ARCHIVE_CAPITAL_FLAG
, PP.PURGE_SUMMARY_FLAG
, PP.ARCHIVE_SUMMARY_FLAG
, PS1.PROJECT_STATUS_NAME
, PP.NEXT_PP_PROJECT_STATUS_CODE
, PS2.PROJECT_STATUS_NAME
, PP.NEXT_P_PROJECT_STATUS_CODE
, PP.PURGED_DATE
, PP.CREATED_BY
, PP.CREATION_DATE
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
, PP.LAST_UPDATE_LOGIN
, P.ORG_ID
FROM PA_LOOKUPS L4
, PA_PROJECT_STATUSES PS1
, PA_PROJECT_STATUSES PS2
, PA_PROJECT_STATUSES PS3
, HR_ORGANIZATION_UNITS O1
, PA_PROJECTS P
, PA_PURGE_PROJECTS PP
WHERE PP.PROJECT_ID = P.PROJECT_ID
AND P.CARRYING_OUT_ORGANIZATION_ID = O1.ORGANIZATION_ID
AND PS1.PROJECT_STATUS_CODE = PP.NEXT_PP_PROJECT_STATUS_CODE
AND PS2.PROJECT_STATUS_CODE = PP.NEXT_P_PROJECT_STATUS_CODE
AND PS3.PROJECT_STATUS_CODE = P.PROJECT_STATUS_CODE
AND L4.LOOKUP_TYPE = 'PURGE_PROJECT_STATUS'
AND L4.LOOKUP_CODE = PP.PURGE_PROJECT_STATUS_CODE

Columns