VIEW: APPS.CEBV_CASH_FORECASTS

Source

View Text - Preformatted

SELECT cf.forecast_id, cf.name, l1.meaning, cf.forecast_currency, l2.meaning, dc.user_conversion_type, cf.exchange_date, cf.exchange_rate, cf.description, cf.start_date, cf.start_period, cf.period_set_name, cf.source_currency, cf.error_status, cf.amount_threshold, fh.name, fh.description, l3.meaning, fh.cutoff_period, tc.name, cf.creation_date, cf.created_by, cf.last_update_date, cf.last_updated_by, cf.project_id, pa.segment1 from ce_forecasts cf, ce_forecast_headers fh, ce_lookups l1, ce_lookups l2, ce_lookups l3, gl_daily_conversion_types dc, gl_transaction_calendar tc, pa_projects_all pa where fh.forecast_header_id = cf.forecast_header_id and l1.lookup_type = 'FORECAST_AGING_TYPE' and l1.lookup_code = fh.aging_type and l2.lookup_type = 'FORECAST_CURRENCY_TYPE' and l2.lookup_code = cf.currency_type and l3.lookup_type = 'FORECAST_OVERDUE_TRX' and l3.lookup_code = fh.overdue_transactions and dc.conversion_type (+) = cf.exchange_rate_type and pa.project_id (+) = cf.project_id and tc.transaction_calendar_id (+) = fh.transaction_calendar_id with read only

View Text - HTML Formatted

SELECT CF.FORECAST_ID
, CF.NAME
, L1.MEANING
, CF.FORECAST_CURRENCY
, L2.MEANING
, DC.USER_CONVERSION_TYPE
, CF.EXCHANGE_DATE
, CF.EXCHANGE_RATE
, CF.DESCRIPTION
, CF.START_DATE
, CF.START_PERIOD
, CF.PERIOD_SET_NAME
, CF.SOURCE_CURRENCY
, CF.ERROR_STATUS
, CF.AMOUNT_THRESHOLD
, FH.NAME
, FH.DESCRIPTION
, L3.MEANING
, FH.CUTOFF_PERIOD
, TC.NAME
, CF.CREATION_DATE
, CF.CREATED_BY
, CF.LAST_UPDATE_DATE
, CF.LAST_UPDATED_BY
, CF.PROJECT_ID
, PA.SEGMENT1
FROM CE_FORECASTS CF
, CE_FORECAST_HEADERS FH
, CE_LOOKUPS L1
, CE_LOOKUPS L2
, CE_LOOKUPS L3
, GL_DAILY_CONVERSION_TYPES DC
, GL_TRANSACTION_CALENDAR TC
, PA_PROJECTS_ALL PA
WHERE FH.FORECAST_HEADER_ID = CF.FORECAST_HEADER_ID
AND L1.LOOKUP_TYPE = 'FORECAST_AGING_TYPE'
AND L1.LOOKUP_CODE = FH.AGING_TYPE
AND L2.LOOKUP_TYPE = 'FORECAST_CURRENCY_TYPE'
AND L2.LOOKUP_CODE = CF.CURRENCY_TYPE
AND L3.LOOKUP_TYPE = 'FORECAST_OVERDUE_TRX'
AND L3.LOOKUP_CODE = FH.OVERDUE_TRANSACTIONS
AND DC.CONVERSION_TYPE (+) = CF.EXCHANGE_RATE_TYPE
AND PA.PROJECT_ID (+) = CF.PROJECT_ID
AND TC.TRANSACTION_CALENDAR_ID (+) = FH.TRANSACTION_CALENDAR_ID WITH READ ONLY