Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AR_DOCUMENT_LINES_V |
SELECT PS.PAYMENT_SCHEDULE_ID
, TRX.PURCHASE_ORDER
, TRXL.LINE_NUMBER
, TRXL.LINE_TYPE
, PS.AMOUNT_DUE_ORIGINAL
, TRXL.DESCRIPTION
, TRXL.UNIT_SELLING_PRICE
, TRXL.QUANTITY_INVOICED
, TRXL.UOM_CODE
, TRXL.INVENTORY_ITEM_ID
, TRXL.EXTENDED_AMOUNT
, PS.DISCOUNT_ORIGINAL
, ARP_TRX_LINE_UTIL.GET_TAX_AMOUNT(TRX.CUSTOMER_TRX_ID
, TRXL.CUSTOMER_TRX_LINE_ID
, 'SALES_TAX')
, ARP_TRX_LINE_UTIL.GET_TAX_AMOUNT(TRX.CUSTOMER_TRX_ID
, TRXL.CUSTOMER_TRX_LINE_ID
, 'VAT')
, TRXL.TAX_RATE
, 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
, TRXL.CREATED_BY
, TRXL.CREATION_DATE
, TRXL.LAST_UPDATED_BY
, TRXL.LAST_UPDATE_DATE
, TRXL.LAST_UPDATE_LOGIN
, 1
FROM RA_CUSTOMER_TRX TRX
, RA_CUSTOMER_TRX_LINES TRXL
, AR_PAYMENT_SCHEDULES PS
WHERE TRX.CUSTOMER_TRX_ID = TRXL.CUSTOMER_TRX_ID
AND NVL(TRX.PAYMENT_TRXN_EXTENSION_ID
, 0) <> 0
AND TRXL.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID