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.RA_CUST_TRX_LN_MRC_V

Source

View Text - Preformatted


SELECT PRIMARY.tax_precedence, PRIMARY.tax_rate, PRIMARY.item_exception_rate_id, PRIMARY.tax_exemption_id, PRIMARY.memo_line_id, PRIMARY.autorule_duration_processed, PRIMARY.uom_code, PRIMARY.default_ussgl_transaction_code, PRIMARY.default_ussgl_trx_code_context, PRIMARY.interface_line_attribute10, PRIMARY.interface_line_attribute11, PRIMARY.interface_line_attribute12, PRIMARY.interface_line_attribute13, PRIMARY.interface_line_attribute14, PRIMARY.interface_line_attribute15, PRIMARY.interface_line_attribute9, PRIMARY.vat_tax_id, PRIMARY.autotax, PRIMARY.last_period_to_credit, PRIMARY.item_context, PRIMARY.tax_exempt_flag, PRIMARY.tax_exempt_number, PRIMARY.tax_exempt_reason_code, PRIMARY.tax_vendor_return_code, PRIMARY.sales_tax_id, PRIMARY.location_segment_id, PRIMARY.movement_id, PRIMARY.org_id, PRIMARY.attribute5, PRIMARY.attribute6, PRIMARY.attribute7, PRIMARY.attribute8, PRIMARY.attribute9, PRIMARY.attribute10, PRIMARY.request_id, PRIMARY.program_application_id, PRIMARY.program_id, PRIMARY.program_update_date, PRIMARY.rule_start_date, PRIMARY.initial_customer_trx_line_id, PRIMARY.interface_line_context, PRIMARY.interface_line_attribute1, PRIMARY.interface_line_attribute2, PRIMARY.interface_line_attribute3, PRIMARY.interface_line_attribute4, PRIMARY.interface_line_attribute5, PRIMARY.interface_line_attribute6, PRIMARY.interface_line_attribute7, PRIMARY.interface_line_attribute8, PRIMARY.sales_order_source, PRIMARY.taxable_flag, PRIMARY.extended_amount, PRIMARY.revenue_amount, PRIMARY.autorule_complete_flag, PRIMARY.link_to_cust_trx_line_id, PRIMARY.attribute11, PRIMARY.attribute12, PRIMARY.attribute13, PRIMARY.attribute14, PRIMARY.attribute15, PRIMARY.customer_trx_line_id, PRIMARY.last_update_date, PRIMARY.last_updated_by, PRIMARY.creation_date, PRIMARY.created_by, PRIMARY.last_update_login, PRIMARY.customer_trx_id, PRIMARY.line_number, MC.set_of_books_id, PRIMARY.reason_code, PRIMARY.inventory_item_id, PRIMARY.description, PRIMARY.previous_customer_trx_id, PRIMARY.previous_customer_trx_line_id, PRIMARY.quantity_ordered, PRIMARY.quantity_credited, PRIMARY.quantity_invoiced, PRIMARY.unit_standard_price, PRIMARY.unit_selling_price, PRIMARY.sales_order, PRIMARY.sales_order_revision, PRIMARY.sales_order_line, PRIMARY.sales_order_date, PRIMARY.accounting_rule_id, PRIMARY.accounting_rule_duration, PRIMARY.line_type, PRIMARY.attribute_category, PRIMARY.attribute1, PRIMARY.attribute2, PRIMARY.attribute3, PRIMARY.attribute4, PRIMARY.global_attribute1, PRIMARY.global_attribute2, PRIMARY.global_attribute3, PRIMARY.global_attribute4, PRIMARY.global_attribute5, PRIMARY.global_attribute6, PRIMARY.global_attribute7, PRIMARY.global_attribute8, PRIMARY.global_attribute9, PRIMARY.global_attribute10, PRIMARY.global_attribute11, PRIMARY.global_attribute12, PRIMARY.global_attribute13, PRIMARY.global_attribute14, PRIMARY.global_attribute15, PRIMARY.global_attribute16, PRIMARY.global_attribute17, PRIMARY.global_attribute18, PRIMARY.global_attribute19, PRIMARY.global_attribute20, PRIMARY.global_attribute_category, PRIMARY.wh_update_date, PRIMARY.gross_unit_selling_price, PRIMARY.gross_extended_amount, PRIMARY.amount_includes_tax_flag, PRIMARY.taxable_amount, PRIMARY.warehouse_id, PRIMARY.translated_description, MC.extended_acctd_amount, PRIMARY.br_ref_customer_trx_id, PRIMARY.br_ref_payment_schedule_id, PRIMARY.br_adjustment_id, PRIMARY.payment_set_id, PRIMARY.source_data_key1, PRIMARY.source_data_key2, PRIMARY.source_data_key3, PRIMARY.source_data_key4, PRIMARY.source_data_key5, PRIMARY.invoiced_line_acctg_level FROM ra_customer_trx_lines_all PRIMARY, ra_mc_customer_trx_lines MC WHERE PRIMARY.customer_trx_line_id = MC.customer_trx_line_id AND NVL( PRIMARY.org_id, NVL( TO_NUMBER( DECODE( SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), -99)) = NVL( TO_NUMBER( DECODE( SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), -99) AND NVL(PRIMARY.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT PRIMARY.TAX_PRECEDENCE
, PRIMARY.TAX_RATE
, PRIMARY.ITEM_EXCEPTION_RATE_ID
, PRIMARY.TAX_EXEMPTION_ID
, PRIMARY.MEMO_LINE_ID
, PRIMARY.AUTORULE_DURATION_PROCESSED
, PRIMARY.UOM_CODE
, PRIMARY.DEFAULT_USSGL_TRANSACTION_CODE
, PRIMARY.DEFAULT_USSGL_TRX_CODE_CONTEXT
, PRIMARY.INTERFACE_LINE_ATTRIBUTE10
, PRIMARY.INTERFACE_LINE_ATTRIBUTE11
, PRIMARY.INTERFACE_LINE_ATTRIBUTE12
, PRIMARY.INTERFACE_LINE_ATTRIBUTE13
, PRIMARY.INTERFACE_LINE_ATTRIBUTE14
, PRIMARY.INTERFACE_LINE_ATTRIBUTE15
, PRIMARY.INTERFACE_LINE_ATTRIBUTE9
, PRIMARY.VAT_TAX_ID
, PRIMARY.AUTOTAX
, PRIMARY.LAST_PERIOD_TO_CREDIT
, PRIMARY.ITEM_CONTEXT
, PRIMARY.TAX_EXEMPT_FLAG
, PRIMARY.TAX_EXEMPT_NUMBER
, PRIMARY.TAX_EXEMPT_REASON_CODE
, PRIMARY.TAX_VENDOR_RETURN_CODE
, PRIMARY.SALES_TAX_ID
, PRIMARY.LOCATION_SEGMENT_ID
, PRIMARY.MOVEMENT_ID
, PRIMARY.ORG_ID
, PRIMARY.ATTRIBUTE5
, PRIMARY.ATTRIBUTE6
, PRIMARY.ATTRIBUTE7
, PRIMARY.ATTRIBUTE8
, PRIMARY.ATTRIBUTE9
, PRIMARY.ATTRIBUTE10
, PRIMARY.REQUEST_ID
, PRIMARY.PROGRAM_APPLICATION_ID
, PRIMARY.PROGRAM_ID
, PRIMARY.PROGRAM_UPDATE_DATE
, PRIMARY.RULE_START_DATE
, PRIMARY.INITIAL_CUSTOMER_TRX_LINE_ID
, PRIMARY.INTERFACE_LINE_CONTEXT
, PRIMARY.INTERFACE_LINE_ATTRIBUTE1
, PRIMARY.INTERFACE_LINE_ATTRIBUTE2
, PRIMARY.INTERFACE_LINE_ATTRIBUTE3
, PRIMARY.INTERFACE_LINE_ATTRIBUTE4
, PRIMARY.INTERFACE_LINE_ATTRIBUTE5
, PRIMARY.INTERFACE_LINE_ATTRIBUTE6
, PRIMARY.INTERFACE_LINE_ATTRIBUTE7
, PRIMARY.INTERFACE_LINE_ATTRIBUTE8
, PRIMARY.SALES_ORDER_SOURCE
, PRIMARY.TAXABLE_FLAG
, PRIMARY.EXTENDED_AMOUNT
, PRIMARY.REVENUE_AMOUNT
, PRIMARY.AUTORULE_COMPLETE_FLAG
, PRIMARY.LINK_TO_CUST_TRX_LINE_ID
, PRIMARY.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.CUSTOMER_TRX_LINE_ID
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.LAST_UPDATED_BY
, PRIMARY.CREATION_DATE
, PRIMARY.CREATED_BY
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.CUSTOMER_TRX_ID
, PRIMARY.LINE_NUMBER
, MC.SET_OF_BOOKS_ID
, PRIMARY.REASON_CODE
, PRIMARY.INVENTORY_ITEM_ID
, PRIMARY.DESCRIPTION
, PRIMARY.PREVIOUS_CUSTOMER_TRX_ID
, PRIMARY.PREVIOUS_CUSTOMER_TRX_LINE_ID
, PRIMARY.QUANTITY_ORDERED
, PRIMARY.QUANTITY_CREDITED
, PRIMARY.QUANTITY_INVOICED
, PRIMARY.UNIT_STANDARD_PRICE
, PRIMARY.UNIT_SELLING_PRICE
, PRIMARY.SALES_ORDER
, PRIMARY.SALES_ORDER_REVISION
, PRIMARY.SALES_ORDER_LINE
, PRIMARY.SALES_ORDER_DATE
, PRIMARY.ACCOUNTING_RULE_ID
, PRIMARY.ACCOUNTING_RULE_DURATION
, PRIMARY.LINE_TYPE
, PRIMARY.ATTRIBUTE_CATEGORY
, PRIMARY.ATTRIBUTE1
, PRIMARY.ATTRIBUTE2
, PRIMARY.ATTRIBUTE3
, PRIMARY.ATTRIBUTE4
, PRIMARY.GLOBAL_ATTRIBUTE1
, PRIMARY.GLOBAL_ATTRIBUTE2
, PRIMARY.GLOBAL_ATTRIBUTE3
, PRIMARY.GLOBAL_ATTRIBUTE4
, PRIMARY.GLOBAL_ATTRIBUTE5
, PRIMARY.GLOBAL_ATTRIBUTE6
, PRIMARY.GLOBAL_ATTRIBUTE7
, PRIMARY.GLOBAL_ATTRIBUTE8
, PRIMARY.GLOBAL_ATTRIBUTE9
, PRIMARY.GLOBAL_ATTRIBUTE10
, PRIMARY.GLOBAL_ATTRIBUTE11
, PRIMARY.GLOBAL_ATTRIBUTE12
, PRIMARY.GLOBAL_ATTRIBUTE13
, PRIMARY.GLOBAL_ATTRIBUTE14
, PRIMARY.GLOBAL_ATTRIBUTE15
, PRIMARY.GLOBAL_ATTRIBUTE16
, PRIMARY.GLOBAL_ATTRIBUTE17
, PRIMARY.GLOBAL_ATTRIBUTE18
, PRIMARY.GLOBAL_ATTRIBUTE19
, PRIMARY.GLOBAL_ATTRIBUTE20
, PRIMARY.GLOBAL_ATTRIBUTE_CATEGORY
, PRIMARY.WH_UPDATE_DATE
, PRIMARY.GROSS_UNIT_SELLING_PRICE
, PRIMARY.GROSS_EXTENDED_AMOUNT
, PRIMARY.AMOUNT_INCLUDES_TAX_FLAG
, PRIMARY.TAXABLE_AMOUNT
, PRIMARY.WAREHOUSE_ID
, PRIMARY.TRANSLATED_DESCRIPTION
, MC.EXTENDED_ACCTD_AMOUNT
, PRIMARY.BR_REF_CUSTOMER_TRX_ID
, PRIMARY.BR_REF_PAYMENT_SCHEDULE_ID
, PRIMARY.BR_ADJUSTMENT_ID
, PRIMARY.PAYMENT_SET_ID
, PRIMARY.SOURCE_DATA_KEY1
, PRIMARY.SOURCE_DATA_KEY2
, PRIMARY.SOURCE_DATA_KEY3
, PRIMARY.SOURCE_DATA_KEY4
, PRIMARY.SOURCE_DATA_KEY5
, PRIMARY.INVOICED_LINE_ACCTG_LEVEL
FROM RA_CUSTOMER_TRX_LINES_ALL PRIMARY
, RA_MC_CUSTOMER_TRX_LINES MC
WHERE PRIMARY.CUSTOMER_TRX_LINE_ID = MC.CUSTOMER_TRX_LINE_ID
AND NVL( PRIMARY.ORG_ID
, NVL( TO_NUMBER( DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL( TO_NUMBER( DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND NVL(PRIMARY.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)