View: FII_AR_OLTP_OPEN_INV_V

Product:	FII - Financial Intelligence
Description:	FII_AR_OLTP_OPEN_INV_V is an internal view used by Risk Indicator Portlet
Implementation/DBA Data:	APPS.FII_AR_OLTP_OPEN_INV_V

View Text

SELECT INST.INSTANCE_CODE
, PS.ORG_ID
, TRX.SET_OF_BOOKS_ID
, TRX.BILL_TO_SITE_USE_ID
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( PS.AMOUNT_DUE_REMAINING
, PS.ACCTD_AMOUNT_DUE_REMAINING
, PS.INVOICE_CURRENCY_CODE
, SOB.CURRENCY_CODE
, NVL(PS.TRX_DATE
, PS.GL_DATE)
, PS.EXCHANGE_RATE_TYPE)
, PS.ACCTD_AMOUNT_DUE_REMAINING
, PS.AMOUNT_DUE_REMAINING
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SOB.CURRENCY_CODE
, PS.INVOICE_CURRENCY_CODE
, PS.TRX_NUMBER
, 1
, PS.TRX_DATE
, PS.DUE_DATE
, 'I'
FROM EDW_LOCAL_INSTANCE INST
, AR_PAYMENT_SCHEDULES_ALL PS
, RA_CUSTOMER_TRX_ALL TRX
, GL_SETS_OF_BOOKS SOB
WHERE PS.STATUS = 'OP' AND PS.CLASS <> 'PMT' AND TRX.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID AND SOB.SET_OF_BOOKS_ID = TRX.SET_OF_BOOKS_ID UNION ALL SELECT INST.INSTANCE_CODE
, PS.ORG_ID
, CR.SET_OF_BOOKS_ID
, PS.CUSTOMER_SITE_USE_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( PS.AMOUNT_DUE_REMAINING * -1
, PS.ACCTD_AMOUNT_DUE_REMAINING * -1
, PS.INVOICE_CURRENCY_CODE
, SOB.CURRENCY_CODE
, NVL(PS.TRX_DATE
, PS.GL_DATE)
, PS.EXCHANGE_RATE_TYPE)
, PS.ACCTD_AMOUNT_DUE_REMAINING * -1
, PS.AMOUNT_DUE_REMAINING * -1
, SOB.CURRENCY_CODE
, PS.INVOICE_CURRENCY_CODE
, PS.TRX_NUMBER
, 1
, PS.TRX_DATE
, TO_DATE(NULL)
, 'P'
FROM EDW_LOCAL_INSTANCE INST
, AR_PAYMENT_SCHEDULES_ALL PS
, GL_SETS_OF_BOOKS SOB
, AR_CASH_RECEIPTS_ALL CR
WHERE PS.STATUS = 'OP'
AND PS.CLASS = 'PMT'
AND CR.CASH_RECEIPT_ID = PS.CASH_RECEIPT_ID AND SOB.SET_OF_BOOKS_ID = CR.SET_OF_BOOKS_ID
AND CR.STATUS IN ('UNAPP'
, 'APP')
AND NVL(CR.CONFIRMED_FLAG
, 'Y') = 'Y'

Columns