VIEW: APPS.PA_PURGE_PROJECTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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