CE Cash Forecast Execution - draft

Description
Categories: BI Publisher, Financials
Application: Cash Management
Source: Cash Forecast Execution Report (XML) - Not Supported: Reserved For Future Use
Short Name: CEFCERR_XML
DB package: CE_CEFCERR_XMLP_PKG
SELECT       
	cfh.name					template_name,
	cf.name					forecast_name,
	cf.start_period				start_period,
	cf.start_date				start_date,
	cf.source_currency				src_currency,
	gdct.user_conversion_type			rate_type,
	cf.exchange_date				xchange_date,
	l3.meaning				curr_type_dsp,
	cfr.row_number				row_number,
	l2.meaning				aging_type_dsp,
	l2.lookup_code				aging_type,
	cfr.trx_type				trx_type,
	l1.meaning				trx_type_dsp ,
	cfe.message_name    			message_name,
	cfe.message_text				message_text,
	cf.forecast_currency	 			forecast_currency,
	NVL(cfe.application_short_name,'CE')		application_short_name, 
	CE_CEFCERR_XMLP_PKG.c_prt_message_nameformula(NVL(cfe.application_short_name,'CE'), cfe.message_name) C_PRT_MESSAGE_NAME
FROM       ce_lookups				l1,
	ce_lookups				l2,
	ce_lookups				l3,
	ce_forecast_errors				cfe,
                  ce_forecast_headers			cfh,
                  ce_forecast_rows				cfr,
	ce_forecasts				cf,
	gl_daily_conversion_types			gdct
WHERE     gdct.conversion_type (+) = cf.exchange_rate_type
AND	l3.lookup_type = 'FORECAST_CURRENCY_TYPE'
AND	l3.lookup_code = cf.currency_type
AND	l2.lookup_type = 'FORECAST_AGING_TYPE'
AND 	l2.lookup_code = cfh.aging_type
AND	l1.lookup_type (+) = 'FORECAST_TRX_TYPE'
AND	l1.lookup_code (+) = cfr.trx_type
AND          cfh.forecast_header_id = cf.forecast_header_id
AND          cfr.forecast_row_id (+) = cfe.forecast_row_id
AND          cf.forecast_id = cfe.forecast_id
AND	cfe.forecast_id = NVL(:P_FORECAST_ID,cfe.forecast_id)
Parameter Name SQL text Validation
Forecast Name
 
LOV Oracle
Ask a question