View: PA_PURGE_BATCHES_V

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

View Text

SELECT PB.ROWID ROW_ID
, PB.PURGE_BATCH_ID
, PB.BATCH_NAME
, PB.DESCRIPTION
, PB.BATCH_STATUS_CODE
, L1.MEANING
, PB.ACTIVE_CLOSED_FLAG
, PB.TXN_TO_DATE
, PB.PURGE_ACTUALS_FLAG
, PB.ARCHIVE_ACTUALS_FLAG
, PB.PURGE_BUDGETS_FLAG
, PB.ARCHIVE_BUDGETS_FLAG
, PB.PURGE_CAPITAL_FLAG
, PB.ARCHIVE_CAPITAL_FLAG
, PB.PURGE_SUMMARY_FLAG
, PB.ARCHIVE_SUMMARY_FLAG
, PB.ADMIN_PROJ_FLAG
, PS1.PROJECT_STATUS_NAME
, PB.NEXT_PP_PROJECT_STATUS_CODE
, PS2.PROJECT_STATUS_NAME
, PB.NEXT_P_PROJECT_STATUS_CODE
, PB.PURGED_DATE
, PB.PURGE_RELEASE
, PB.CREATED_BY
, PB.CREATION_DATE
, PB.LAST_UPDATE_DATE
, PB.LAST_UPDATED_BY
, PB.LAST_UPDATE_LOGIN
, PB.REQUEST_ID
, PB.PROGRAM_APPLICATION_ID
, PB.PROGRAM_ID
, PB.PROGRAM_UPDATE_DATE
, PB.ORG_ID
FROM PA_PROJECT_STATUSES PS1
, PA_PROJECT_STATUSES PS2
, PA_LOOKUPS L1
, PA_PURGE_BATCHES PB
WHERE L1.LOOKUP_TYPE = 'PURGE_BATCH_STATUS'
AND L1.LOOKUP_CODE = PB.BATCH_STATUS_CODE
AND PS1.PROJECT_STATUS_CODE = PB.NEXT_PP_PROJECT_STATUS_CODE
AND PS2.PROJECT_STATUS_CODE = PB.NEXT_P_PROJECT_STATUS_CODE

Columns