VIEW: APPS.IBE_INVOICE_DETAIL_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)