View: ICX_RA_CUSTOMER_TRX_LINES_V

Product:	ICX - Oracle iProcurement
Description:	Customer Transactions Details View
Implementation/DBA Data:	APPS.ICX_RA_CUSTOMER_TRX_LINES_V

View Text

SELECT CTL.ROWID ROW_ID
, CTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, CTL.LINE_NUMBER LINE_NUMBER
, CTL.DESCRIPTION DESCRIPTION
, CTL.UOM_CODE UOM_CODE
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, NVL(CTL.QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED) QUANTITY
, TO_CHAR(CTL.UNIT_SELLING_PRICE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( CT.INVOICE_CURRENCY_CODE
, 30)) UNIT_SELLING_PRICE
, TO_CHAR(CTL.EXTENDED_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( CT.INVOICE_CURRENCY_CODE
, 30)) EXTENDED_AMOUNT
, CTL.LINE_TYPE LINE_TYPE
, AL_LINE_TYPE.MEANING MEANING
, CTL.SALES_ORDER SALES_ORDER
, DECODE (CTL.INTERFACE_LINE_CONTEXT
, 'ORDER ENTRY'
, CTL.INTERFACE_LINE_ATTRIBUTE7
, NULL ) INTERFACE_LINE_ATTRIBUTE7
, CTL.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CTL.LINK_TO_CUST_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID
, CTL.PREVIOUS_CUSTOMER_TRX_ID PREVIOUS_CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID PREVIOUS_CUSTOMER_TRX_LINE_ID
, CTL.INITIAL_CUSTOMER_TRX_LINE_ID INITIAL_CUSTOMER_TRX_LINE_ID
, CTL.QUANTITY_ORDERED QUANTITY_ORDERED
, CTL.QUANTITY_CREDITED QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED QUANTITY_INVOICED
, CTL.REVENUE_AMOUNT REVENUE_AMOUNT
, CTL.REASON_CODE REASON_CODE
, CTL.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, CTL.ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION
, CTL.RULE_START_DATE RULE_START_DATE
, CTL.AUTORULE_COMPLETE_FLAG AUTORULE_COMPLETE_FLAG
, CTL.AUTORULE_DURATION_PROCESSED AUTORULE_DURATION_PROCESSED
, CTL.LAST_PERIOD_TO_CREDIT LAST_PERIOD_TO_CREDIT
, CTL.ITEM_CONTEXT ITEM_CONTEXT
, CTL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CTL.MEMO_LINE_ID MEMO_LINE_ID
, CTL.TAXABLE_FLAG TAXABLE_FLAG
, CTL.TAX_PRECEDENCE TAX_PRECEDENCE
, CTL.TAX_RATE TAX_RATE
, CTL.ITEM_EXCEPTION_RATE_ID ITEM_EXCEPTION_RATE_ID
, CTL.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, CTL.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, CTL.TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, CTL.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, CTL.TAX_VENDOR_RETURN_CODE TAX_VENDOR_RETURN_CODE
, CTL.SALES_TAX_ID SALES_TAX_ID
, CTL.LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID
, CTL.VAT_TAX_ID VAT_TAX_ID
, CTL.AUTOTAX AUTOTAX
, CTL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CTL.SALES_ORDER_SOURCE SALES_ORDER_SOURCE
, CTL.SALES_ORDER_REVISION SALES_ORDER_REVISION
, CTL.SALES_ORDER_LINE SALES_ORDER_LINE
, CTL.SALES_ORDER_DATE SALES_ORDER_DATE
, CTL.MOVEMENT_ID MOVEMENT_ID
, CTL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CTL.LAST_UPDATED_BY LAST_UPDATED_BY
, CTL.CREATION_DATE CREATION_DATE
, CTL.CREATED_BY CREATED_BY
, CTL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CTL.REQUEST_ID REQUEST_ID
, CTL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CTL.PROGRAM_ID PROGRAM_ID
, CTL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CTL.DEFAULT_USSGL_TRANSACTION_CODE DEFAULT_USSGL_TRANSACTION_CODE
, CTL.DEFAULT_USSGL_TRX_CODE_CONTEXT DEFAULT_USSGL_TRX_CODE_CONTEXT
, CTL.INTERFACE_LINE_CONTEXT INTERFACE_LINE_CONTEXT
, CTL.INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1
, CTL.INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, CTL.INTERFACE_LINE_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3
, CTL.INTERFACE_LINE_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4
, CTL.INTERFACE_LINE_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5
, CTL.INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6
, CTL.INTERFACE_LINE_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8
, CTL.INTERFACE_LINE_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9
, CTL.INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10
, CTL.INTERFACE_LINE_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11
, CTL.INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12
, CTL.INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13
, CTL.INTERFACE_LINE_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14
, CTL.INTERFACE_LINE_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15
, CTL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CTL.ATTRIBUTE1 ATTRIBUTE1
, CTL.ATTRIBUTE2 ATTRIBUTE2
, CTL.ATTRIBUTE3 ATTRIBUTE3
, CTL.ATTRIBUTE4 ATTRIBUTE4
, CTL.ATTRIBUTE5 ATTRIBUTE5
, CTL.ATTRIBUTE6 ATTRIBUTE6
, CTL.ATTRIBUTE7 ATTRIBUTE7
, CTL.ATTRIBUTE8 ATTRIBUTE8
, CTL.ATTRIBUTE9 ATTRIBUTE9
, CTL.ATTRIBUTE10 ATTRIBUTE10
, CTL.ATTRIBUTE11 ATTRIBUTE11
, CTL.ATTRIBUTE12 ATTRIBUTE12
, CTL.ATTRIBUTE13 ATTRIBUTE13
, CTL.ATTRIBUTE14 ATTRIBUTE14
, CTL.ATTRIBUTE15 ATTRIBUTE15
, CT.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, CT.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CT.SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, CT.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, CT.SOLD_TO_CUSTOMER_ID SOLD_TO_CUSTOMER_ID
, CT.SOLD_TO_SITE_USE_ID SOLD_TO_SITE_USE_ID
, CT.PAYING_CUSTOMER_ID PAYING_CUSTOMER_ID
, CT.PAYING_SITE_USE_ID PAYING_SITE_USE_ID
FROM MTL_UNITS_OF_MEASURE UOM
, AR_LOOKUPS AL_LINE_TYPE
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES CTL
WHERE CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND CTL.UOM_CODE = UOM.UOM_CODE(+)
AND CTL.LINE_TYPE = AL_LINE_TYPE.LOOKUP_CODE(+)
AND 'STD_LINE_TYPE' = AL_LINE_TYPE.LOOKUP_TYPE(+)

Columns