View: AR_INVOICE_INSTALLMENTS_V

Product:	AR - Receivables
Description:	Collects invoice installment information
Implementation/DBA Data:	APPS.AR_INVOICE_INSTALLMENTS_V

View Text

SELECT TRX.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, O_TYPE.LOOKUP_CODE OPEN_TRX_ONLY_FLAG
, PS.TERMS_SEQUENCE_NUMBER INSTALLMENT_NUMBER
, NVL( NVL(TAX_ORIGINAL
, TO_NUMBER(NULL))
, SUM( DECODE( LINE_TYPE
, 'TAX'
, EXTENDED_AMOUNT
, 0 ) ) ) TAX_AMOUNT
, NVL( NVL(AMOUNT_LINE_ITEMS_ORIGINAL + DECODE(TRX.INITIAL_CUSTOMER_TRX_ID
, ''
, 0
, NVL(COM_ADJ.AMOUNT
, 0))
, TO_NUMBER(NULL))
, SUM( DECODE( LINE_TYPE
, 'FREIGHT'
, 0
, 'TAX'
, 0
, EXTENDED_AMOUNT ) ) ) LINE_AMOUNT
, NVL( NVL(FREIGHT_ORIGINAL
, TO_NUMBER(NULL))
, SUM( DECODE( LINE_TYPE
, 'FREIGHT'
, EXTENDED_AMOUNT
, 0 ) ) ) FREIGHT_AMOUNT
, NVL( PS.AMOUNT_DUE_ORIGINAL + DECODE(TRX.INITIAL_CUSTOMER_TRX_ID
, ''
, 0
, NVL(COM_ADJ.AMOUNT
, 0))
, SUM( EXTENDED_AMOUNT) ) TOTAL_AMOUNT
FROM AR_LOOKUPS O_TYPE
, AR_ADJUSTMENTS COM_ADJ
, RA_CUSTOMER_TRX_LINES LINES
, AR_PAYMENT_SCHEDULES PS
, RA_TERMS_LINES TL
, RA_TERMS T
, RA_CUSTOMER_TRX TRX
WHERE PS.PAYMENT_SCHEDULE_ID + DECODE(PS.CLASS
, 'INV'
, 0
, '') = COM_ADJ.PAYMENT_SCHEDULE_ID(+) AND COM_ADJ.SUBSEQUENT_TRX_ID IS NULL AND 'C' = COM_ADJ.ADJUSTMENT_TYPE(+) AND TRX.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID(+) AND TRX.TERM_ID = TL.TERM_ID(+) AND TRX.TERM_ID = T.TERM_ID(+) AND NVL(PS.TERMS_SEQUENCE_NUMBER
, NVL(TL.SEQUENCE_NUM
, 0)) = NVL(TL.SEQUENCE_NUM
, NVL(PS.TERMS_SEQUENCE_NUMBER
, 0)) AND O_TYPE.LOOKUP_TYPE = 'YES/NO' AND O_TYPE.LOOKUP_CODE = DECODE(NVL(PS.AMOUNT_DUE_REMAINING
, 0)
, 0
, 'N'
, 'Y') AND LINES.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID GROUP BY TRX.CUSTOMER_TRX_ID
, TRX.TRX_NUMBER
, PS.TAX_ORIGINAL
, PS.FREIGHT_ORIGINAL
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, TL.RELATIVE_AMOUNT
, T.BASE_AMOUNT
, PS.TERMS_SEQUENCE_NUMBER
, PS.AMOUNT_DUE_ORIGINAL
, TRX.INITIAL_CUSTOMER_TRX_ID
, COM_ADJ.AMOUNT
, O_TYPE.LOOKUP_CODE

Columns