View: IBE_INVOICE_DETAIL_V

Product:	IBE - iStore
Description:
Implementation/DBA Data:	APPS.IBE_INVOICE_DETAIL_V

View Text

SELECT CTL.CUSTOMER_TRX_LINE_ID
, DECODE(CTL.LINK_TO_CUST_TRX_LINE_ID
, NULL
, CTL.LINE_NUMBER
, CTL2.LINE_NUMBER) LINE_NUMBER
, DECODE(CTL.LINK_TO_CUST_TRX_LINE_ID
, NULL
, CTL.LINE_NUMBER
, CTL2.LINE_NUMBER) || CTL.LINE_TYPE ORDERBY_SEQ
, CTL.DESCRIPTION
, NVL(CTL.QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED) QUANTITY
, CTL.UNIT_SELLING_PRICE
, CTL.EXTENDED_AMOUNT
, CTL.LINE_TYPE
, AL_LINE_TYPE.MEANING
, CTL.SALES_ORDER
, CTL.CUSTOMER_TRX_ID
, NULL
, CTL.ORG_ID ORG_ID
FROM AR_LOOKUPS AL_LINE_TYPE
, RA_CUSTOMER_TRX_LINES_ALL CTL
, RA_CUSTOMER_TRX_LINES_ALL CTL2
WHERE 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