VIEW: APPS.JE_PT_RA_TRX_REQUEST_IDS_V

Source

View Text - Preformatted

SELECT DISTINCT trx.request_id, trx.created_from, trx.batch_source_id FROM ra_customer_trx trx, ra_cust_trx_types_all trxt WHERE trx.complete_flag = 'Y' AND EXISTS ( SELECT 1 FROM je_pt_ra_cust_trx_exts ext WHERE ext.customer_trx_id = trx.customer_trx_id AND ext.signature IS NULL) AND trx.cust_trx_type_id = trxt.cust_trx_type_id AND trxt.TYPE NOT IN ('PMT', 'BR') AND trx.org_id = trxt.org_id AND trx.created_from IN ('ARXREC', 'RAXTRX') AND EXISTS ( SELECT 1 FROM fnd_document_sequences WHERE doc_sequence_id = trx.doc_sequence_id AND TYPE <> 'M')

View Text - HTML Formatted

SELECT DISTINCT TRX.REQUEST_ID
, TRX.CREATED_FROM
, TRX.BATCH_SOURCE_ID
FROM RA_CUSTOMER_TRX TRX
, RA_CUST_TRX_TYPES_ALL TRXT
WHERE TRX.COMPLETE_FLAG = 'Y'
AND EXISTS ( SELECT 1
FROM JE_PT_RA_CUST_TRX_EXTS EXT
WHERE EXT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND EXT.SIGNATURE IS NULL)
AND TRX.CUST_TRX_TYPE_ID = TRXT.CUST_TRX_TYPE_ID
AND TRXT.TYPE NOT IN ('PMT'
, 'BR')
AND TRX.ORG_ID = TRXT.ORG_ID
AND TRX.CREATED_FROM IN ('ARXREC'
, 'RAXTRX')
AND EXISTS ( SELECT 1
FROM FND_DOCUMENT_SEQUENCES
WHERE DOC_SEQUENCE_ID = TRX.DOC_SEQUENCE_ID
AND TYPE <> 'M')