View: FII_BIS_FIIARTR1_V

View Text

SELECT 'BIS_FIIARTR1' REPORT_NAME
, PS.ORG_ID
, TRX.SET_OF_BOOKS_ID
, PS.GL_DATE
, GP.START_DATE
, PD.ACCOUNTING_DATE
, PS.CUSTOMER_ID
, CUST.CUSTOMER_NAME CUSTOMER_NAME
, SITE.LOCATION LOCATION
, PS.TRX_NUMBER TRX_NUM
, PS.INVOICE_CURRENCY_CODE CURR_CODE
, PS.AMOUNT_DUE_ORIGINAL ORIG_AMT
, (PS.AMOUNT_DUE_ORIGINAL * NVL(PS.EXCHANGE_RATE
, 1)) FUNC_AMT
FROM RA_SITE_USES_ALL SITE
, RA_CUSTOMERS CUST
, AR_PAYMENT_SCHEDULES_ALL PS
, RA_CUSTOMER_TRX_ALL TRX
, GL_SETS_OF_BOOKS GSOB
, GL_PERIODS GP
, GL_DATE_PERIOD_MAP PD
WHERE PS.GL_DATE BETWEEN GP.YEAR_START_DATE
AND PD.ACCOUNTING_DATE
AND PS.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND TRX.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND PS.GL_DATE_CLOSED > GP.YEAR_START_DATE
AND CUST.CUSTOMER_ID = PS.CUSTOMER_ID
AND SITE.SITE_USE_ID = PS.CUSTOMER_SITE_USE_ID
AND PS.PAYMENT_SCHEDULE_ID <> -1
AND PS.CLASS IN ('INV'
, 'DEP'
, 'DM'
, 'CB')
AND GP.PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME
AND GP.PERIOD_TYPE = GSOB.ACCOUNTED_PERIOD_TYPE
AND PD.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
AND PD.PERIOD_NAME = GP.PERIOD_NAME

Columns