VIEW: APPS.PA_TRX_IMPORT_BATCHES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'