CE Cash Forecast Execution - draft
Description
Categories: BI Publisher
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
Source: Cash Forecast Execution Report (XML) - Not Supported: Reserved For Future Use
Short Name: CEFCERR_XML
DB package: CE_CEFCERR_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |