VIEW: APPS.AR_DOCUMENT_LINES_V

Source

View Text - Preformatted

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'), /* 7514417 */ 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, trx.invoice_currency_code 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

View Text - HTML Formatted

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')
, /* 7514417 */ 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
, TRX.INVOICE_CURRENCY_CODE
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