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.AR_DOCS_RECEIVABLES_V

Source

View Text - Preformatted


SELECT iby.PAYMENT_SYSTEM_ORDER_NUMBER, cr.payment_trxn_extension_id, ps.payment_schedule_id, ps.trx_number, trx.purchase_order, null, trx.trx_date, 'INVOICE', null, trx.invoice_currency_code, ps.amount_due_original, ARP_TRX_LINE_UTIL.get_tax_amount(trx.customer_trx_id, 'SALES_TAX'), null, ARP_TRX_LINE_UTIL.get_tax_amount(trx.customer_trx_id, 'VAT'), null, rec.amount_applied, cr.factor_discount_amount, null, null, trx.payment_trxn_extension_id, trx.legal_entity_id, decode (ps.dispute_date ,NULL,'N','Y'), null, trx.ship_to_address_id, trx.ship_to_site_use_id, trx.special_instructions, null, trx.comments, null, null, null, trx.ATTRIBUTE_CATEGORY, trx.ATTRIBUTE1 , trx.ATTRIBUTE2 , trx.ATTRIBUTE3 , trx.ATTRIBUTE4 , trx.ATTRIBUTE5 , trx.ATTRIBUTE6 , trx.ATTRIBUTE7 , trx.ATTRIBUTE8 , trx.ATTRIBUTE9 , trx.ATTRIBUTE10, trx.ATTRIBUTE11, trx.ATTRIBUTE12 , trx.ATTRIBUTE13 , trx.ATTRIBUTE14 , trx.ATTRIBUTE15, trx.created_by, trx.creation_date, trx.last_updated_by, trx.last_update_date, trx.last_update_login, 1 from ar_cash_receipts cr, ra_customer_trx trx, iby_trxn_extensions_v iby, ar_payment_schedules ps, ar_receipt_classes rc, ar_receipt_methods rm, ar_receivable_applications rec WHERE rec.cash_receipt_id = cr.cash_receipt_id and rec.applied_payment_schedule_id = ps.payment_schedule_id and rec.display = 'Y' and rec.status = 'APP' and cr.receipt_method_id = rm.receipt_method_id and iby.trxn_extension_id = cr.payment_trxn_extension_id and rm.receipt_class_id = rc.receipt_class_id and rc.creation_method_code = 'AUTOMATIC' and cr.type <> 'MISC' and ps.customer_trx_id = trx.customer_trx_id

View Text - HTML Formatted

SELECT IBY.PAYMENT_SYSTEM_ORDER_NUMBER
, CR.PAYMENT_TRXN_EXTENSION_ID
, PS.PAYMENT_SCHEDULE_ID
, PS.TRX_NUMBER
, TRX.PURCHASE_ORDER
, NULL
, TRX.TRX_DATE
, 'INVOICE'
, NULL
, TRX.INVOICE_CURRENCY_CODE
, PS.AMOUNT_DUE_ORIGINAL
, ARP_TRX_LINE_UTIL.GET_TAX_AMOUNT(TRX.CUSTOMER_TRX_ID
, 'SALES_TAX')
, NULL
, ARP_TRX_LINE_UTIL.GET_TAX_AMOUNT(TRX.CUSTOMER_TRX_ID
, 'VAT')
, NULL
, REC.AMOUNT_APPLIED
, CR.FACTOR_DISCOUNT_AMOUNT
, NULL
, NULL
, TRX.PAYMENT_TRXN_EXTENSION_ID
, TRX.LEGAL_ENTITY_ID
, DECODE (PS.DISPUTE_DATE
, NULL
, 'N'
, 'Y')
, NULL
, TRX.SHIP_TO_ADDRESS_ID
, TRX.SHIP_TO_SITE_USE_ID
, TRX.SPECIAL_INSTRUCTIONS
, NULL
, TRX.COMMENTS
, NULL
, NULL
, NULL
, TRX.ATTRIBUTE_CATEGORY
, TRX.ATTRIBUTE1
, TRX.ATTRIBUTE2
, TRX.ATTRIBUTE3
, TRX.ATTRIBUTE4
, TRX.ATTRIBUTE5
, TRX.ATTRIBUTE6
, TRX.ATTRIBUTE7
, TRX.ATTRIBUTE8
, TRX.ATTRIBUTE9
, TRX.ATTRIBUTE10
, TRX.ATTRIBUTE11
, TRX.ATTRIBUTE12
, TRX.ATTRIBUTE13
, TRX.ATTRIBUTE14
, TRX.ATTRIBUTE15
, TRX.CREATED_BY
, TRX.CREATION_DATE
, TRX.LAST_UPDATED_BY
, TRX.LAST_UPDATE_DATE
, TRX.LAST_UPDATE_LOGIN
, 1
FROM AR_CASH_RECEIPTS CR
, RA_CUSTOMER_TRX TRX
, IBY_TRXN_EXTENSIONS_V IBY
, AR_PAYMENT_SCHEDULES PS
, AR_RECEIPT_CLASSES RC
, AR_RECEIPT_METHODS RM
, AR_RECEIVABLE_APPLICATIONS REC
WHERE REC.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND REC.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
AND REC.DISPLAY = 'Y'
AND REC.STATUS = 'APP'
AND CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND IBY.TRXN_EXTENSION_ID = CR.PAYMENT_TRXN_EXTENSION_ID
AND RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
AND RC.CREATION_METHOD_CODE = 'AUTOMATIC'
AND CR.TYPE <> 'MISC'
AND PS.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID