View: JE_PT_RA_TRX_REQUEST_IDS_V

Product:	JE - European Localizations
Description:	View to list the transactions for which signature was not generated.
Implementation/DBA Data:	APPS.JE_PT_RA_TRX_REQUEST_IDS_V

View Text

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')

Columns