VIEW: APPS.PA_PURGE_BATCHES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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