View: AR_DOCS_RECEIVABLES_V

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

View Text

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

Columns