View: PA_TRX_IMPORT_BATCHES_V

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

View Text

SELECT DISTINCT XFACE.BATCH_NAME
, XFACE.TRANSACTION_SOURCE
, XFACE.ORG_ID
FROM PA_TRANSACTION_XFACE_CONTROL XFACE
WHERE STATUS = 'PENDING' UNION SELECT DISTINCT USER_BATCH_NAME
, 'ORACLE SELF SERVICE TIME'
, EXP.ORG_ID
FROM PA_EXPENDITURES EXP
WHERE EXP.TRANSFER_STATUS_CODE IN ( 'R'
, 'P')
AND EXP.USER_BATCH_NAME IS NOT NULL
AND EXP.EXPENDITURE_STATUS_CODE = 'APPROVED'

Columns