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.

[Home] [Help]

View: ARBR_DOCS_RECEIVABLES_V

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

View Text

SELECT IBY.PAYMENT_SYSTEM_ORDER_NUMBER
, TRXBR.CUSTOMER_TRX_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 TRX.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

Columns

Name
ORDER_TANGIBLE_ID
ORDER_EXT_ID
DOC_UNIQUE_REF
CALLING_APP_DOC_REF_NUMBER
PO_NUMBER
VAT_REF_NUMBER
DOCUMENT_DATE
DOCUMENT_TYPE
DOCUMENT_DESCRIPTION
DOCUMENT_CURRENCY_CODE
DOCUMENT_AMOUNT
LOCAL_TAX_AMOUNT
NATIONAL_TAX_AMOUNT
VAT_TAX_AMOUNT
DOCUMENT_CURR_CHARGE_AMOUNT
SETTLEMENT_AMOUNT
DISCOUNT_AMOUNT
FREIGHT_AMOUNT
DUTY_AMOUNT
PAYMENT_TRXN_EXTENSION_ID
LEGAL_ENTITY_ID
DOCUMENT_DISPUTED_FLAG
SHIP_FROM_ADDRESS_ID
SHIP_TO_ADDRESS_ID
SPECIAL_INSTRUCTION
COLLECTOR_NAME
COMMENTS
CUSTOMER_REFERENCE
BR_DRAWEE_ISSUED_FLAG
BR_SIGNED_FLAG
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER