Product: | OZF - Trade Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OZF_X_INVOICE_LINE_V |
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)