eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ARBR_DOCS_RECEIVABLES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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