eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_CSH_FCST_POP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21


  CURSOR cCol IS SELECT forecast_column_id, column_number, days_from, days_to
                 FROM   ce_forecast_columns
                 WHERE  forecast_header_id = XTR_CASH_FCST.G_rp_forecast_header_id;

Line: 59


      SELECT	gps.period_name
      INTO	history_period
      FROM	gl_periods gps,
		gl_periods gp,
		gl_period_types gpt
      WHERE	gps.period_num =DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),
			1,gp.period_num - XTR_CASH_FCST.G_roll_forward_period,
			gpt.number_per_fiscal_year +
			  mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year))
      AND	gps.period_year = gp.period_year +
			DECODE(LEAST(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,1),1,0,
		  DECODE(mod(gp.period_num-XTR_CASH_FCST.G_roll_forward_period,gpt.number_per_fiscal_year),0,
			FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)-1,
			FLOOR((gp.period_num -XTR_CASH_FCST.G_roll_forward_period)/gpt.number_per_fiscal_year)))
      AND	gp.period_set_name 	= gps.period_set_name
      AND	gps.period_type 	= gp.period_type
      AND	gpt.period_type 	= gp.period_type
      AND	gp.period_name 		= XTR_CASH_FCST.G_rp_forecast_start_period
      AND	gp.period_set_name 	= CEFC_VIEW_CONST.get_period_set_name;

Line: 122


    SELECT 	period_number,
	   	level_of_summary,
	   	length_of_period,
           	length_type
    FROM   	xtr_forecast_periods_v
    ORDER BY	period_number;

Line: 146


  DELETE FROM xtr_forecast_period_temp;

Line: 152


	XTR_DEBUG_PKG.DEBUG('EXCEPTION:populate_temp_buckets-->delete');

Line: 181


        INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)
        VALUES (l_period_id, l_start_date, l_start, 'D');

Line: 218


        INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)
        VALUES (l_period_id, l_od_start, l_start, 'D');

Line: 232


        INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)
        VALUES (l_period_id, l_start_date, l_end, 'W');

Line: 246


        INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)
        VALUES (l_period_id, l_start_date, l_end, 'M');

Line: 277


  CURSOR C1 IS 	select 	forecast_period_temp_id, start_date, end_date
		from 	xtr_forecast_period_temp;

Line: 306


            select 	max(transaction_date)+1
            into	new_start_date
            from	gl_transaction_dates
            where	transaction_calendar_id = XTR_CASH_FCST.G_transaction_calendar_id
            and		transaction_date < start_date
            and 	business_day_flag = 'Y';

Line: 328


            select	max(transaction_date)
            into	new_end_date
            from	gl_transaction_dates
            where	transaction_calendar_id = XTR_CASH_FCST.G_transaction_calendar_id
            and		transaction_date <= end_date
            and		business_day_flag = 'Y';

Line: 345


        UPDATE 	xtr_forecast_period_temp
        SET     start_date = new_start_date,
		end_date = new_end_date
        WHERE  	forecast_period_temp_id = fid;

Line: 367


  delete from xtr_forecast_period_temp;

Line: 373


	XTR_DEBUG_PKG.DEBUG('EXCEPTION:clear_aging_buckets-->delete');

Line: 379


|	Get Select Clause						|
|									|
|  DESCRIPTION								|
|	Builds Select clause and returns it to calling procedure        |
|  CALLED BY								|
|	Build_XXX_Query							|
|  REQUIRES								|
|									|
|  HISTORY								|
|	19-AUG-1996	Created		Bidemi Carrol			|
 --------------------------------------------------------------------- */
FUNCTION Get_Select_Clause RETURN VARCHAR2 IS
  select_clause VARCHAR2(300);

Line: 394


      select_clause := '
        SELECT  cab.forecast_period_temp_id,
                src.currency_code,
	        SUM(src.amount),
	        src.bank_account_id  ';

Line: 400


      select_clause := '
        SELECT  cab.forecast_period_temp_id,
                src.currency_code,
                SUM(src.amount)  ';

Line: 406


     xtr_debug_pkg.debug(select_clause);

Line: 408


  return select_clause;

Line: 409


END Get_Select_Clause;

Line: 641


    SELECT nvl(derive_type, 'NONE')
    FROM   gl_currencies
    WHERE  currency_code(+) = p_cur;

Line: 646


    SELECT end_date,
           level_of_summary
    FROM   xtr_forecast_period_temp
    WHERE  forecast_period_temp_id = p_pid;

Line: 744


          CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id,
					XTR_CASH_FCST.G_rp_forecast_header_id, XTR_CASH_FCST.G_forecast_row_id,
					'GL_JE_INVALID_CONVERSION_INFO', error_msg);

Line: 755


      INSERT INTO xtr_external_cashflows(amount_date,
					 amount,
					 currency,
					 company_code,
					 trx_type,
					 ap_bank_account_id,
					 level_of_summary)
      VALUES (amount_date,
	      nvl(forecast_amount,0),
	      currency,
	      XTR_CASH_FCST.G_party_code,
	      XTR_CASH_FCST.G_trx_type,
	      bank_account_id,
              level_of_summary);

Line: 812


  select_clause	varchar2(300);

Line: 822


  select_clause := Get_Select_Clause;

Line: 824


     xtr_debug_pkg.debug('Built Select Clause');

Line: 843


			UPDATE	ce_forecasts
		SET	error_status = 'E'
		WHERE	forecast_id = CE_CASH_FCST.G_forecast_id;

Line: 849


		CE_FORECAST_ERRORS_PKG.insert_row(
					CE_CASH_FCST.G_forecast_id,
					CE_CASH_FCST.G_rp_forecast_header_id,
					CE_CASH_FCST.G_forecast_row_id,
					'CE_NO_HIST_START_PERIOD',
					error_msg);

Line: 886


  main_query := select_clause || from_clause || where_clause || group_clause;

Line: 919


  select_clause	varchar2(300);

Line: 928


  select_clause := Get_Select_Clause;

Line: 930


     xtr_debug_pkg.debug('Built Select Clause');

Line: 963


  main_query := select_clause || from_clause || where_clause || group_clause;

Line: 998


  select_clause	varchar2(500);

Line: 1005


      select_clause := ' SELECT cab.forecast_period_temp_id,
		src.currency_code,
		SUM(src.amount-src.dispute_amount) ';

Line: 1009


    select_clause := Get_Select_Clause;

Line: 1012


     xtr_debug_pkg.debug('Built Select Clause');

Line: 1013


     xtr_debug_pkg.debug(select_clause);

Line: 1035


  main_query := select_clause || from_clause || where_clause ||group_clause;

Line: 1069


  select_clause	varchar2(300);

Line: 1080


  select_clause := Get_Select_Clause;

Line: 1082


     xtr_debug_pkg.debug('Built Select Clause');

Line: 1102


		UPDATE	ce_forecasts
		SET	error_status = 'E'
		WHERE	forecast_id = CE_CASH_FCST.G_forecast_id;

Line: 1108


		CE_FORECAST_ERRORS_PKG.insert_row(
					CE_CASH_FCST.G_forecast_id,
					CE_CASH_FCST.G_rp_forecast_header_id,
					CE_CASH_FCST.G_forecast_row_id,
					'CE_NO_HIST_START_PERIOD',
					error_msg);

Line: 1146


  main_query := select_clause || from_clause || where_clause ||group_clause;

Line: 1179


  select_clause varchar2(300);

Line: 1188


  select_clause := Get_Select_Clause;

Line: 1190


     xtr_debug_pkg.debug('Built Select Clause');

Line: 1214


		UPDATE	ce_forecasts
		SET	error_status = 'E'
		WHERE	forecast_id = CE_CASH_FCST.G_forecast_id;

Line: 1220


		CE_FORECAST_ERRORS_PKG.insert_row(
					CE_CASH_FCST.G_forecast_id,
					CE_CASH_FCST.G_rp_forecast_header_id,
					CE_CASH_FCST.G_forecast_row_id,
					'CE_NO_HIST_START_PERIOD',
					error_msg);

Line: 1237


  main_query := select_clause || from_clause || where_clause || group_clause;

Line: 1264


  select_clause	varchar2(300);

Line: 1271


  select_clause := Get_Select_Clause;

Line: 1273


     xtr_debug_pkg.debug('Built Select Clause');

Line: 1296


  main_query := select_clause || from_clause || where_clause || group_clause;

Line: 1326


  select_clause	varchar2(300);

Line: 1333


  select_clause := Get_Select_Clause;

Line: 1335


     xtr_debug_pkg.debug('Built Select Clause');

Line: 1357


  main_query := select_clause || from_clause || where_clause || group_clause;

Line: 1386


  select_clause	varchar2(300);

Line: 1393


  select_clause := Get_Select_Clause;

Line: 1395


     xtr_debug_pkg.debug('Built Select Clause');

Line: 1432


  main_query := select_clause || from_clause || where_clause || group_clause;

Line: 1477


    SELECT      external_source_view, db_link_name
    INTO        source_view, db_link
    FROM        ce_forecast_ext_views
    WHERE       external_source_type = XTR_CASH_FCST.G_external_source_type;

Line: 1490


        CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
			XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);

Line: 1557


	  CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
			XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);

Line: 1566


	  CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
			XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);

Line: 1575


	  CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
			XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);

Line: 1592


        CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
                        XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);

Line: 1606


	CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
			XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);