View: IBE_RA_CUSTOMER_TRX_LINES_V

View Text

SELECT CTL.ROWID ROW_ID
, CTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, DECODE(CTL.LINK_TO_CUST_TRX_LINE_ID
, NULL
, CTL.LINE_NUMBER
, CTL2.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
, TO_CHAR(CTL.REVENUE_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) 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
, 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
, CT.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
FROM MTL_UNITS_OF_MEASURE UOM
, AR_LOOKUPS AL_LINE_TYPE
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX_LINES CTL2
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(+)
AND CTL.LINK_TO_CUST_TRX_LINE_ID = CTL2.CUSTOMER_TRX_LINE_ID(+)

Columns