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

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_DOCS_RECEIVABLES_V

View Text

SELECT NULL
, CR.PAYMENT_TRXN_EXTENSION_ID
, PS.PAYMENT_SCHEDULE_ID
, PS.TRX_NUMBER
, NULL
, NULL
, TRX.TRX_DATE
, 'INVOICE'
, NULL
, TRX.INVOICE_CURRENCY_CODE
, PS.AMOUNT_DUE_ORIGINAL
, PS.DISCOUNT_TAKEN_EARNED
, NULL
, ARP_TRX_LINE_UTIL.GET_TAX_AMOUNT(TRX.CUSTOMER_TRX_ID
, 'SALES_TAX')
, /* 6936153 */ NULL
, ARP_TRX_LINE_UTIL.GET_TAX_AMOUNT(TRX.CUSTOMER_TRX_ID
, 'VAT')
, /* 6936153 */ NULL
, REC.AMOUNT_APPLIED
, CR.FACTOR_DISCOUNT_AMOUNT
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TRX.SHIP_TO_ADDRESS_ID
, NULL
, NULL
, NULL
, NULL
, 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
, TRX.BILL_TO_SITE_USE_ID
FROM AR_CASH_RECEIPTS CR
, RA_CUSTOMER_TRX TRX
, IBY_FNDCPT_TX_EXTENSIONS IBYX
, 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 IBYX.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

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
DOCUMENT_DISCOUNT_EARNED
DOCUMENT_DISCOUNT_UNEARNED
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
SHIP_TO_SITE_USE_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
BILL_TO_SITE_USE_ID