View: AR_INVOICE_COMMITMENT_INFO_V

Product:	AR - Receivables
Description:	Collects information about commitments
Implementation/DBA Data:	APPS.AR_INVOICE_COMMITMENT_INFO_V

View Text

SELECT CHILD.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRX.PREVIOUS_CUSTOMER_TRX_ID PREVIOUS_CUSTOMER_TRX_ID
, TRX.CUSTOMER_TRX_ID COMMITMENT_CUSTOMER_TRX_ID
, TRX.TRX_NUMBER COMMITMENT_TRX_NUMBER
, TRX.START_DATE_COMMITMENT START_DATE_COMMITMENT
, TRX.END_DATE_COMMITMENT END_DATE_COMMITMENT
, TYPES.TYPE CLASS
, L.MEANING CLASS_NAME
, LINES.REVENUE_AMOUNT ORIGINAL_AMOUNT
, AR_INVOICE_SQL_FUNC_PUB.GET_COMMIT_THIS_INVOICE( CHILD.CUSTOMER_TRX_ID) THIS_INVOICE_AMOUNT
, AR_INVOICE_SQL_FUNC_PUB.GET_COM_TOTAL_ACTIVITY( CHILD.CUSTOMER_TRX_ID
, TYPES.TYPE
, TRX.CUSTOMER_TRX_ID ) TOTAL_ACTIVITY_AMT
, AR_INVOICE_SQL_FUNC_PUB.GET_COM_AMT_UNINVOICED( TRX.CUSTOMER_TRX_ID ) UNINVOICED_AMOUNT
, NVL(LINES.REVENUE_AMOUNT
, 0) + NVL(AR_INVOICE_SQL_FUNC_PUB.GET_COMMIT_THIS_INVOICE( CHILD.CUSTOMER_TRX_ID)
, 0 ) + NVL(AR_INVOICE_SQL_FUNC_PUB.GET_COM_TOTAL_ACTIVITY( CHILD.CUSTOMER_TRX_ID
, TYPES.TYPE
, TRX.CUSTOMER_TRX_ID )
, 0) + NVL(AR_INVOICE_SQL_FUNC_PUB.GET_COM_AMT_UNINVOICED( TRX.CUSTOMER_TRX_ID )
, 0) COMMITMENT_BALANCE
FROM AR_LOOKUPS L
, RA_CUSTOMER_TRX_LINES LINES
, RA_CUSTOMER_TRX CHILD
, RA_CUST_TRX_TYPES TYPES
, RA_CUSTOMER_TRX TRX
WHERE TRX.COMPLETE_FLAG = 'Y' AND TYPES.TYPE = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'INV/CM'
AND TYPES.CUST_TRX_TYPE_ID = TRX.CUST_TRX_TYPE_ID
AND TRX.CUSTOMER_TRX_ID = LINES.CUSTOMER_TRX_ID AND (L.LOOKUP_CODE != 'CM' OR TRX.CUSTOMER_TRX_ID = NVL(TRX.PREVIOUS_CUSTOMER_TRX_ID
, -1))
AND CHILD.INITIAL_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID

Columns