Product: | AR - Receivables |
---|---|
Description: | Creation of ARBR_DOCS_RECEIVABLES_V view this is view is required for payment settlemnt |
Implementation/DBA Data: | APPS.ARBR_DOCS_RECEIVABLES_V |
SELECT IBY.PAYMENT_SYSTEM_ORDER_NUMBER
, TRXBR.PAYMENT_TRXN_EXTENSION_ID
, BRTRXL.BR_REF_CUSTOMER_TRX_ID
, NULL
, TRXBR.PURCHASE_ORDER
, NULL
, TRXBR.TRX_DATE
, 'INVOICE'
, CTT.NAME
, TRXBR.INVOICE_CURRENCY_CODE
, TRXBR.BR_AMOUNT
, NULL
, NULL
, NULL
, NULL
, BRTRXL.EXTENDED_AMOUNT
, NULL
, NULL
, NULL
, TRX.PAYMENT_TRXN_EXTENSION_ID
, TRXBR.LEGAL_ENTITY_ID
, DECODE (TRH.STATUS
, 'PROTESTED'
, 'Y'
, 'N')
, NULL
, NULL
, NULL
, NULL
, NULL
, TRXBR.CUSTOMER_REFERENCE
, CTT.DRAWEE_ISSUED_FLAG
, CTT.SIGNED_FLAG
, TRXBR.ATTRIBUTE_CATEGORY
, TRXBR.ATTRIBUTE1
, TRXBR.ATTRIBUTE2
, TRXBR.ATTRIBUTE3
, TRXBR.ATTRIBUTE4
, TRXBR.ATTRIBUTE5
, TRXBR.ATTRIBUTE6
, TRXBR.ATTRIBUTE7
, TRXBR.ATTRIBUTE8
, TRXBR.ATTRIBUTE9
, TRXBR.ATTRIBUTE10
, TRXBR.ATTRIBUTE11
, TRXBR.ATTRIBUTE12
, TRXBR.ATTRIBUTE13
, TRXBR.ATTRIBUTE14
, TRXBR.ATTRIBUTE15
, TRXBR.CREATED_BY
, TRXBR.CREATION_DATE
, TRXBR.LAST_UPDATED_BY
, TRXBR.LAST_UPDATE_DATE
, TRXBR.LAST_UPDATE_LOGIN
, 1
FROM RA_CUSTOMER_TRX TRXBR
, RA_CUSTOMER_TRX_LINES BRTRXL
, RA_CUSTOMER_TRX TRX
, IBY_TRXN_EXTENSIONS_V IBY
, RA_CUST_TRX_TYPES_ALL CTT
, AR_TRANSACTION_HISTORY TRH
WHERE TRXBR.CUSTOMER_TRX_ID = BRTRXL.CUSTOMER_TRX_ID
AND TRXBR.BR_AMOUNT IS NOT NULL
AND TRXBR.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND TRXBR.PAYMENT_TRXN_EXTENSION_ID = IBY.TRXN_EXTENSION_ID
AND NVL(TRH.CURRENT_RECORD_FLAG
, 'Y') = 'Y'
AND TRXBR.CUSTOMER_TRX_ID = TRH.CUSTOMER_TRX_ID
AND TRX.CUSTOMER_TRX_ID = BRTRXL.BR_REF_CUSTOMER_TRX_ID