AR_DOCUMENT_LINES_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

DOC_UNIQUE_REF PO_NUMBER LINE_NUMBER LINE_TYPE LINE_GROSS_AMOUNT DESCRIPTION UNIT_PRICE QUANTITY UNIT_OF_MEASURE INVENTORY_ITEM_ID EXTENDED_AMOUNT DISCOUNT_AMOUNT SALES_TAX_AMOUNT VAT_TAX_AMOUNT TAX_RATE TAX_CODE DOCUMENT_CURRENCY_CODE 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

Query

SQL_Statement

(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.invoice_currency_code, 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_ALL 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)