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.

VIEW: APPS.IEX_INVOICE_LINES_V

Source

View Text - Preformatted


SELECT trxl.CUSTOMER_TRX_LINE_ID, trxl.line_number, trxl.description, trxl.UOM_UNIT_OF_MEASURE_NAME, trxl.QUANTITY_INVOICED, trxl.QUANTITY_ORDERED, trxl.UNIT_SELLING_PRICE, trxl.extended_amount, trxl.customer_trx_id ,trxl.LINK_TO_CUST_TRX_LINE_ID ,trxl.PREVIOUS_CUSTOMER_TRX_ID ,trxl.PREVIOUS_CUSTOMER_TRX_LINE_ID ,trxl.INITIAL_CUSTOMER_TRX_LINE_ID ,trxl.LINE_TYPE ,trxl.QUANTITY_CREDITED ,trxl.QUANTITY ,trxl.UNIT_STANDARD_PRICE ,trxl.NET_UNIT_SELLING_PRICE ,trxl.NET_EXTENDED_AMOUNT ,trxl.REVENUE_AMOUNT ,trxl.AMOUNT_INCLUDES_TAX_FLAG ,trxl.AMOUNT_INCLUDES_TAX_OVERRIDE ,trxl.UOM_CODE ,trxl.REASON_CODE ,trxl.ACCOUNTING_RULE_ID ,trxl.ACCOUNTING_RULE_DURATION ,trxl.RULE_START_DATE ,trxl.AUTORULE_COMPLETE_FLAG ,trxl.AUTORULE_DURATION_PROCESSED ,trxl.LAST_PERIOD_TO_CREDIT ,trxl.ITEM_CONTEXT ,trxl.INVENTORY_ITEM_ID ,trxl.MEMO_LINE_ID ,trxl.TAXABLE_FLAG ,trxl.TAX_PRECEDENCE ,trxl.TAX_RATE ,trxl.ITEM_EXCEPTION_RATE_ID ,trxl.TAX_EXEMPTION_ID ,trxl.TAX_EXEMPT_FLAG ,trxl.TAX_EXEMPT_NUMBER ,trxl.TAX_EXEMPT_REASON_CODE ,trxl.TAX_VENDOR_RETURN_CODE ,trxl.SALES_TAX_ID ,trxl.LOCATION_SEGMENT_ID ,trxl.VAT_TAX_ID ,trxl.AUTOTAX ,trxl.SET_OF_BOOKS_ID ,trxl.SALES_ORDER_SOURCE ,trxl.SALES_ORDER ,trxl.SALES_ORDER_REVISION ,trxl.SALES_ORDER_LINE ,trxl.SALES_ORDER_DATE ,trxl.MOVEMENT_ID ,trxl.LAST_UPDATE_DATE ,trxl.LAST_UPDATED_BY ,trxl.CREATION_DATE ,trxl.CREATED_BY ,trxl.LAST_UPDATE_LOGIN ,trxl.REQUEST_ID ,trxl.PROGRAM_APPLICATION_ID ,trxl.PROGRAM_ID ,trxl.PROGRAM_UPDATE_DATE ,trxl.DEFAULT_USSGL_TRANSACTION_CODE ,trxl.DEFAULT_USSGL_TRX_CODE_CONTEXT ,trxl.CUSTOMER_LANGUAGE ,trxl.INTERFACE_LINE_CONTEXT ,trxl.INTERFACE_LINE_ATTRIBUTE1 ,trxl.INTERFACE_LINE_ATTRIBUTE2 ,trxl.INTERFACE_LINE_ATTRIBUTE3 ,trxl.INTERFACE_LINE_ATTRIBUTE4 ,trxl.INTERFACE_LINE_ATTRIBUTE5 ,trxl.INTERFACE_LINE_ATTRIBUTE6 ,trxl.INTERFACE_LINE_ATTRIBUTE7 ,trxl.INTERFACE_LINE_ATTRIBUTE8 ,trxl.INTERFACE_LINE_ATTRIBUTE9 ,trxl.INTERFACE_LINE_ATTRIBUTE10 ,trxl.INTERFACE_LINE_ATTRIBUTE11 ,trxl.INTERFACE_LINE_ATTRIBUTE12 ,trxl.INTERFACE_LINE_ATTRIBUTE13 ,trxl.INTERFACE_LINE_ATTRIBUTE14 ,trxl.INTERFACE_LINE_ATTRIBUTE15 ,trxl.ATTRIBUTE_CATEGORY ,trxl.ATTRIBUTE1 ,trxl.ATTRIBUTE2 ,trxl.ATTRIBUTE3 ,trxl.ATTRIBUTE4 ,trxl.ATTRIBUTE5 ,trxl.ATTRIBUTE6 ,trxl.ATTRIBUTE7 ,trxl.ATTRIBUTE8 ,trxl.ATTRIBUTE9 ,trxl.ATTRIBUTE10 ,trxl.ATTRIBUTE11 ,trxl.ATTRIBUTE12 ,trxl.ATTRIBUTE13 ,trxl.ATTRIBUTE14 ,trxl.ATTRIBUTE15 ,trxl.AL_TAX_HANDLING_MEANING ,trxl.AL_REASON_MEANING ,trxl.RR_ACCOUNTING_RULE_NAME ,trxl.RR_ACCOUNTING_RULE_TYPE ,trxl.RR_FREQUENCY ,trxl.AL_TAX_EXEMPT_REASON_MEANING ,trxl.CTL_PREV_LINE_NUMBER ,trxl.CTL_PREV_QUANTITY ,trxl.UOM_PREV_UNIT_OF_MEASURE_NAME ,trxl.CTL_PREV_DESCRIPTION ,trxl.CTL_PREV_UNIT_SELLING_PRICE ,trxl.CTL_PREV_NET_UNIT_SELL_PRICE ,trxl.CTL_PREV_EXTENDED_AMOUNT ,trxl.CTL_PREV_NET_EXTENDED_AMOUNT ,trxl.PREV_LINE_BALANCE ,trxl.CTL_PREV_ACCT_RULE_DURATION ,trxl.CTL_REFERENCE ,trxl.WAREHOUSE_ID ,trxl.WAREHOUSE_NAME ,trxl.ML_MEMO_LINE_TYPE ,trxl.ML_MEMO_LINE_TAX_CODE ,trxl.ML_MEMO_LINE_UNIT_STD_PRICE ,trxl.LAST_GL_DATE ,trxl.TAX_CODE ,trxl.GLOBAL_ATTRIBUTE_CATEGORY ,trxl.GLOBAL_ATTRIBUTE1 ,trxl.GLOBAL_ATTRIBUTE2 ,trxl.GLOBAL_ATTRIBUTE3 ,trxl.GLOBAL_ATTRIBUTE4 ,trxl.GLOBAL_ATTRIBUTE5 ,trxl.GLOBAL_ATTRIBUTE6 ,trxl.GLOBAL_ATTRIBUTE7 ,trxl.GLOBAL_ATTRIBUTE8 ,trxl.GLOBAL_ATTRIBUTE9 ,trxl.GLOBAL_ATTRIBUTE10 ,trxl.GLOBAL_ATTRIBUTE11 ,trxl.GLOBAL_ATTRIBUTE12 ,trxl.GLOBAL_ATTRIBUTE13 ,trxl.GLOBAL_ATTRIBUTE14 ,trxl.GLOBAL_ATTRIBUTE15 ,trxl.GLOBAL_ATTRIBUTE16 ,trxl.GLOBAL_ATTRIBUTE17 ,trxl.GLOBAL_ATTRIBUTE18 ,trxl.GLOBAL_ATTRIBUTE19 ,trxl.GLOBAL_ATTRIBUTE20 ,trxl.TRANSLATED_DESCRIPTION FROM ra_customer_trx_lines_V trxl WHERE LINE_TYPE IN ('LINE', 'CB', 'CHARGES')

View Text - HTML Formatted

SELECT TRXL.CUSTOMER_TRX_LINE_ID
, TRXL.LINE_NUMBER
, TRXL.DESCRIPTION
, TRXL.UOM_UNIT_OF_MEASURE_NAME
, TRXL.QUANTITY_INVOICED
, TRXL.QUANTITY_ORDERED
, TRXL.UNIT_SELLING_PRICE
, TRXL.EXTENDED_AMOUNT
, TRXL.CUSTOMER_TRX_ID
, TRXL.LINK_TO_CUST_TRX_LINE_ID
, TRXL.PREVIOUS_CUSTOMER_TRX_ID
, TRXL.PREVIOUS_CUSTOMER_TRX_LINE_ID
, TRXL.INITIAL_CUSTOMER_TRX_LINE_ID
, TRXL.LINE_TYPE
, TRXL.QUANTITY_CREDITED
, TRXL.QUANTITY
, TRXL.UNIT_STANDARD_PRICE
, TRXL.NET_UNIT_SELLING_PRICE
, TRXL.NET_EXTENDED_AMOUNT
, TRXL.REVENUE_AMOUNT
, TRXL.AMOUNT_INCLUDES_TAX_FLAG
, TRXL.AMOUNT_INCLUDES_TAX_OVERRIDE
, TRXL.UOM_CODE
, TRXL.REASON_CODE
, TRXL.ACCOUNTING_RULE_ID
, TRXL.ACCOUNTING_RULE_DURATION
, TRXL.RULE_START_DATE
, TRXL.AUTORULE_COMPLETE_FLAG
, TRXL.AUTORULE_DURATION_PROCESSED
, TRXL.LAST_PERIOD_TO_CREDIT
, TRXL.ITEM_CONTEXT
, TRXL.INVENTORY_ITEM_ID
, TRXL.MEMO_LINE_ID
, TRXL.TAXABLE_FLAG
, TRXL.TAX_PRECEDENCE
, TRXL.TAX_RATE
, TRXL.ITEM_EXCEPTION_RATE_ID
, TRXL.TAX_EXEMPTION_ID
, TRXL.TAX_EXEMPT_FLAG
, TRXL.TAX_EXEMPT_NUMBER
, TRXL.TAX_EXEMPT_REASON_CODE
, TRXL.TAX_VENDOR_RETURN_CODE
, TRXL.SALES_TAX_ID
, TRXL.LOCATION_SEGMENT_ID
, TRXL.VAT_TAX_ID
, TRXL.AUTOTAX
, TRXL.SET_OF_BOOKS_ID
, TRXL.SALES_ORDER_SOURCE
, TRXL.SALES_ORDER
, TRXL.SALES_ORDER_REVISION
, TRXL.SALES_ORDER_LINE
, TRXL.SALES_ORDER_DATE
, TRXL.MOVEMENT_ID
, TRXL.LAST_UPDATE_DATE
, TRXL.LAST_UPDATED_BY
, TRXL.CREATION_DATE
, TRXL.CREATED_BY
, TRXL.LAST_UPDATE_LOGIN
, TRXL.REQUEST_ID
, TRXL.PROGRAM_APPLICATION_ID
, TRXL.PROGRAM_ID
, TRXL.PROGRAM_UPDATE_DATE
, TRXL.DEFAULT_USSGL_TRANSACTION_CODE
, TRXL.DEFAULT_USSGL_TRX_CODE_CONTEXT
, TRXL.CUSTOMER_LANGUAGE
, TRXL.INTERFACE_LINE_CONTEXT
, TRXL.INTERFACE_LINE_ATTRIBUTE1
, TRXL.INTERFACE_LINE_ATTRIBUTE2
, TRXL.INTERFACE_LINE_ATTRIBUTE3
, TRXL.INTERFACE_LINE_ATTRIBUTE4
, TRXL.INTERFACE_LINE_ATTRIBUTE5
, TRXL.INTERFACE_LINE_ATTRIBUTE6
, TRXL.INTERFACE_LINE_ATTRIBUTE7
, TRXL.INTERFACE_LINE_ATTRIBUTE8
, TRXL.INTERFACE_LINE_ATTRIBUTE9
, TRXL.INTERFACE_LINE_ATTRIBUTE10
, TRXL.INTERFACE_LINE_ATTRIBUTE11
, TRXL.INTERFACE_LINE_ATTRIBUTE12
, TRXL.INTERFACE_LINE_ATTRIBUTE13
, TRXL.INTERFACE_LINE_ATTRIBUTE14
, TRXL.INTERFACE_LINE_ATTRIBUTE15
, TRXL.ATTRIBUTE_CATEGORY
, TRXL.ATTRIBUTE1
, TRXL.ATTRIBUTE2
, TRXL.ATTRIBUTE3
, TRXL.ATTRIBUTE4
, TRXL.ATTRIBUTE5
, TRXL.ATTRIBUTE6
, TRXL.ATTRIBUTE7
, TRXL.ATTRIBUTE8
, TRXL.ATTRIBUTE9
, TRXL.ATTRIBUTE10
, TRXL.ATTRIBUTE11
, TRXL.ATTRIBUTE12
, TRXL.ATTRIBUTE13
, TRXL.ATTRIBUTE14
, TRXL.ATTRIBUTE15
, TRXL.AL_TAX_HANDLING_MEANING
, TRXL.AL_REASON_MEANING
, TRXL.RR_ACCOUNTING_RULE_NAME
, TRXL.RR_ACCOUNTING_RULE_TYPE
, TRXL.RR_FREQUENCY
, TRXL.AL_TAX_EXEMPT_REASON_MEANING
, TRXL.CTL_PREV_LINE_NUMBER
, TRXL.CTL_PREV_QUANTITY
, TRXL.UOM_PREV_UNIT_OF_MEASURE_NAME
, TRXL.CTL_PREV_DESCRIPTION
, TRXL.CTL_PREV_UNIT_SELLING_PRICE
, TRXL.CTL_PREV_NET_UNIT_SELL_PRICE
, TRXL.CTL_PREV_EXTENDED_AMOUNT
, TRXL.CTL_PREV_NET_EXTENDED_AMOUNT
, TRXL.PREV_LINE_BALANCE
, TRXL.CTL_PREV_ACCT_RULE_DURATION
, TRXL.CTL_REFERENCE
, TRXL.WAREHOUSE_ID
, TRXL.WAREHOUSE_NAME
, TRXL.ML_MEMO_LINE_TYPE
, TRXL.ML_MEMO_LINE_TAX_CODE
, TRXL.ML_MEMO_LINE_UNIT_STD_PRICE
, TRXL.LAST_GL_DATE
, TRXL.TAX_CODE
, TRXL.GLOBAL_ATTRIBUTE_CATEGORY
, TRXL.GLOBAL_ATTRIBUTE1
, TRXL.GLOBAL_ATTRIBUTE2
, TRXL.GLOBAL_ATTRIBUTE3
, TRXL.GLOBAL_ATTRIBUTE4
, TRXL.GLOBAL_ATTRIBUTE5
, TRXL.GLOBAL_ATTRIBUTE6
, TRXL.GLOBAL_ATTRIBUTE7
, TRXL.GLOBAL_ATTRIBUTE8
, TRXL.GLOBAL_ATTRIBUTE9
, TRXL.GLOBAL_ATTRIBUTE10
, TRXL.GLOBAL_ATTRIBUTE11
, TRXL.GLOBAL_ATTRIBUTE12
, TRXL.GLOBAL_ATTRIBUTE13
, TRXL.GLOBAL_ATTRIBUTE14
, TRXL.GLOBAL_ATTRIBUTE15
, TRXL.GLOBAL_ATTRIBUTE16
, TRXL.GLOBAL_ATTRIBUTE17
, TRXL.GLOBAL_ATTRIBUTE18
, TRXL.GLOBAL_ATTRIBUTE19
, TRXL.GLOBAL_ATTRIBUTE20
, TRXL.TRANSLATED_DESCRIPTION
FROM RA_CUSTOMER_TRX_LINES_V TRXL
WHERE LINE_TYPE IN ('LINE'
, 'CB'
, 'CHARGES')