APPS.CE_FORECAST_REMOTE_SOURCES SQL Statements

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

Line: 67

    main_query1 := 'SELECT count(*) from ' || source_view;

Line: 86

      INSERT INTO CE_FORECAST_EXT_TEMP (context_value, forecast_request_id, start_date, end_date, forecast_column_id, conversion_rate)
	  VALUES ('A', forecast_id, aging_table(i).start_date, aging_table(i).end_date, aging_table(i).column_id, forecast_row_id);

Line: 93

      INSERT INTO CE_FORECAST_EXT_TEMP (context_value, forecast_request_id, from_currency_code, conversion_rate)
	VALUES ('C', forecast_id, conversion_table(i).from_currency_code, conversion_table(i).conversion_rate);

Line: 102

    main_query1 := 'SELECT 	cab.forecast_column_id,
        src.transaction_amount*curr.conversion_rate,
	src.transaction_amount,
	src.currency_code,
	src.cash_activity_date + '||to_char(lead_time)||',
	src.bank_account_id ';

Line: 108

    main_query2 := 'SELECT 	cab.forecast_column_id,
        src.transaction_amount*curr.conversion_rate,
	src.transaction_amount,
	src.currency_code,
	src.cash_activity_date + '||to_char(lead_time)||' ';

Line: 114

    main_query1 := 'SELECT 	cab.forecast_column_id,
        src.transaction_amount*'||to_char(rp_exchange_rate)||',
	src.transaction_amount,
	src.currency_code,
	src.cash_activity_date + '||to_char(lead_time)||',
	src.bank_account_id ';

Line: 120

    main_query2 := 'SELECT 	cab.forecast_column_id,
        src.transaction_amount*'||to_char(rp_exchange_rate)||',
	src.transaction_amount,
	src.currency_code,
	src.cash_activity_date + '||to_char(lead_time)||' ';

Line: 127

    main_query1 := 'SELECT 	cab.forecast_column_id,
        src.transaction_amount,
	src.transaction_amount,
	src.currency_code,
	src.cash_activity_date + '||to_char(lead_time)||',
	src.bank_account_id ';

Line: 133

    main_query2 := 'SELECT 	cab.forecast_column_id,
        src.transaction_amount,
	src.transaction_amount,
	src.currency_code,
	src.cash_activity_date + '||to_char(lead_time)||' ';

Line: 281

  DELETE FROM CE_FORECAST_EXT_TEMP
	WHERE 	forecast_request_id = forecast_id
	AND	context_value = 'C';

Line: 284

  DELETE FROM CE_FORECAST_EXT_TEMP
	WHERE	forecast_request_id = forecast_id
	AND	conversion_rate = forecast_row_id
	AND	context_value = 'A';