Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PB.PURGE_BATCH_ID
, PB.BATCH_NAME
, PB.DESCRIPTION
, PB.BATCH_STATUS_CODE
, 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
, PB.NEXT_PP_PROJECT_STATUS_CODE
, 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_PURGE_BATCHES_ALL PB
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)