[Home] [Help]
View: 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
Name |
CUSTOMER_TRX_LINE_ID |
LINE_NUMBER |
ORDERBY_SEQ |
DESCRIPTION |
QUANTITY |
UNIT_SELLING_PRICE |
EXTENDED_AMOUNT |
LINE_TYPE |
MEANING |
SALES_ORDER |
CUSTOMER_TRX_ID |
INVOICE_CURRENCY_CODE |
ORG_ID |