DBA Data[Home] [Help]

APPS.XTR_FORECAST_REMOTE_SOURCES dependencies on XTR_FORECAST_PERIOD_TEMP

Line 58: FROM xtr_forecast_period_temp

54:
55: CURSOR C_period(p_pid NUMBER) IS
56: SELECT end_date,
57: level_of_summary
58: FROM xtr_forecast_period_temp
59: WHERE forecast_period_temp_id = p_pid;
60:
61: BEGIN
62: BEGIN

Line 86: XTR_FORECAST_PERIOD_TEMP cab ';

82: SUM(src.transaction_amount) ';
83:
84: main_query := main_query || '
85: FROM '|| source_view ||' src,
86: XTR_FORECAST_PERIOD_TEMP cab ';
87:
88: main_query := main_query || '
89: WHERE src.cash_activity_date BETWEEN cab.start_date and cab.end_date ';
90: