View: SO_OPEN_ORDER_INVOICE_REFS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_OPEN_ORDER_INVOICE_REFS_V

View Text

SELECT DISTINCT COMMITMENT_ID CUSTOMER_TRX_ID
FROM SO_LINES
WHERE OPEN_FLAG = 'Y'
AND COMMITMENT_ID IS NOT NULL UNION SELECT DISTINCT T.CUSTOMER_TRX_ID
FROM RA_CUSTOMER_TRX_LINES T
, SO_LINES L
WHERE L.OPEN_FLAG = 'Y'
AND L.CREDIT_INVOICE_LINE_ID IS NOT NULL
AND T.CUSTOMER_TRX_LINE_ID = L.CREDIT_INVOICE_LINE_ID UNION SELECT DISTINCT T.CUSTOMER_TRX_ID
FROM RA_CUSTOMER_TRX_LINES T
, SO_LINES L
WHERE L.OPEN_FLAG = 'Y'
AND L.RETURN_REFERENCE_TYPE_CODE = 'INVOICE'
AND L.RETURN_REFERENCE_ID = T.CUSTOMER_TRX_LINE_ID

Columns