APPS.CE_FORECAST_SUMMARY2_PKG dependencies on CE_FORECAST_SUMMARY_V

Line 71: FROM CE_FORECAST_SUMMARY_V

67: R_total61, R_total62, R_total63, R_total64, R_total65,
68: R_total66, R_total67, R_total68, R_total69, R_total70,
69: R_total71, R_total72, R_total73, R_total74, R_total75,
70: R_total76, R_total77, R_total78, R_total79, R_total80
71: FROM CE_FORECAST_SUMMARY_V
72: WHERE forecast_id = X_forecast_id
73: AND TRX_TYPE IN ('ARI', 'ARR', 'ASF', 'UDI', 'OEO', 'XTR', 'OII');
74:
75: select sum(column41), sum(column42), sum(column43), sum(column44), sum(column45),

Line 91: FROM CE_FORECAST_SUMMARY_V

87: E_total61, E_total62, E_total63, E_total64, E_total65,
88: E_total66, E_total67, E_total68, E_total69, E_total70,
89: E_total71, E_total72, E_total73, E_total74, E_total75,
90: E_total76, E_total77, E_total78, E_total79, E_total80
91: FROM CE_FORECAST_SUMMARY_V
92: WHERE forecast_id = X_forecast_id
93: AND TRX_TYPE IN ('APP', 'API', 'UDO',
94: 'APX', 'PAY', 'POP', 'POR', 'OIO');
95: ELSE

Line 112: FROM CE_FORECAST_SUMMARY_V

108: R_total61, R_total62, R_total63, R_total64, R_total65,
109: R_total66, R_total67, R_total68, R_total69, R_total70,
110: R_total71, R_total72, R_total73, R_total74, R_total75,
111: R_total76, R_total77, R_total78, R_total79, R_total80
112: FROM CE_FORECAST_SUMMARY_V
113: WHERE forecast_id = X_forecast_id
114: AND TRX_TYPE IN ('ARI', 'PAI', 'PAB', 'UDI', 'OEO', 'OII');
115:
116: select sum(column41), sum(column42), sum(column43), sum(column44), sum(column45),

Line 132: FROM CE_FORECAST_SUMMARY_V

128: E_total61, E_total62, E_total63, E_total64, E_total65,
129: E_total66, E_total67, E_total68, E_total69, E_total70,
130: E_total71, E_total72, E_total73, E_total74, E_total75,
131: E_total76, E_total77, E_total78, E_total79, E_total80
132: FROM CE_FORECAST_SUMMARY_V
133: WHERE forecast_id = X_forecast_id
134: AND TRX_TYPE IN ('API', 'PAO', 'PAT', 'UDO',
135: 'APX', 'POP', 'POR', 'OIO');
136: END IF;