VIEW: APPS.OZF_X_INVOICE_LINE_V

Source

View Text - Preformatted

SELECT ct.trx_number, ct.customer_trx_id, lines.customer_trx_line_id, lines.line_number, lines.line_type, lines.inventory_item_id, lines.QUANTITY_ORDERED , lines.QUANTITY_CREDITED , lines.QUANTITY_INVOICED , lines.UNIT_STANDARD_PRICE , lines.UNIT_SELLING_PRICE , lines.EXTENDED_AMOUNT , lines.org_id from ra_customer_trx_all ct , ra_customer_trx_lines_all lines WHERE lines.customer_trx_id = ct.customer_trx_id AND ct.complete_flag = 'Y' AND NVL(lines.ORG_ID, -99) = NVL(ct.ORG_ID, -99) AND NVL(lines.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV( 'CLIENT_INFO'),1 ,1),' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT CT.TRX_NUMBER
, CT.CUSTOMER_TRX_ID
, LINES.CUSTOMER_TRX_LINE_ID
, LINES.LINE_NUMBER
, LINES.LINE_TYPE
, LINES.INVENTORY_ITEM_ID
, LINES.QUANTITY_ORDERED
, LINES.QUANTITY_CREDITED
, LINES.QUANTITY_INVOICED
, LINES.UNIT_STANDARD_PRICE
, LINES.UNIT_SELLING_PRICE
, LINES.EXTENDED_AMOUNT
, LINES.ORG_ID
FROM RA_CUSTOMER_TRX_ALL CT
, RA_CUSTOMER_TRX_LINES_ALL LINES
WHERE LINES.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND CT.COMPLETE_FLAG = 'Y'
AND NVL(LINES.ORG_ID
, -99) = NVL(CT.ORG_ID
, -99)
AND NVL(LINES.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV( 'CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)