VIEW: APPS.SO_OPEN_ORDER_INVOICE_REFS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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