VIEW: APPS.RA_CUST_TRX_LN_ALL_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 , NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),45,10)),-99) , 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.CONTRACT_LINE_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 mc.set_of_books_id = NVL(TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO'), 45, 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
, NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)
, 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.CONTRACT_LINE_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 MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER (RTRIM (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10)
, ' '))
, -99)