APPS.CE_FORECAST_SUMMARY_PKG dependencies on CE_FORECAST_SUMMARY_V

Line 74: FROM CE_FORECAST_SUMMARY_V

70: R_total21, R_total22, R_total23, R_total24, R_total25,
71: R_total26, R_total27, R_total28, R_total29, R_total30,
72: R_total31, R_total32, R_total33, R_total34, R_total35,
73: R_total36, R_total37, R_total38, R_total39, R_total40
74: FROM CE_FORECAST_SUMMARY_V
75: WHERE forecast_id = X_forecast_id
76: AND TRX_TYPE IN ('ARI', 'ARR', 'ASF', 'UDI', 'OEO', 'OII', 'XTR');
77:
78: select sum(column0),

Line 95: FROM CE_FORECAST_SUMMARY_V

91: E_total21, E_total22, E_total23, E_total24, E_total25,
92: E_total26, E_total27, E_total28, E_total29, E_total30,
93: E_total31, E_total32, E_total33, E_total34, E_total35,
94: E_total36, E_total37, E_total38, E_total39, E_total40
95: FROM CE_FORECAST_SUMMARY_V
96: WHERE forecast_id = X_forecast_id
97: AND TRX_TYPE IN ('APP', 'API', 'UDO',
98: 'APX', 'PAY', 'POP', 'POR', 'OIO');
99: ELSE

Line 117: FROM CE_FORECAST_SUMMARY_V

113: R_total21, R_total22, R_total23, R_total24, R_total25,
114: R_total26, R_total27, R_total28, R_total29, R_total30,
115: R_total31, R_total32, R_total33, R_total34, R_total35,
116: R_total36, R_total37, R_total38, R_total39, R_total40
117: FROM CE_FORECAST_SUMMARY_V
118: WHERE forecast_id = X_forecast_id
119: AND TRX_TYPE IN ('ARI', 'PAI', 'PAB', 'UDI', 'OEO', 'OII');
120:
121: select sum(column0),

Line 138: FROM CE_FORECAST_SUMMARY_V

134: E_total21, E_total22, E_total23, E_total24, E_total25,
135: E_total26, E_total27, E_total28, E_total29, E_total30,
136: E_total31, E_total32, E_total33, E_total34, E_total35,
137: E_total36, E_total37, E_total38, E_total39, E_total40
138: FROM CE_FORECAST_SUMMARY_V
139: WHERE forecast_id = X_forecast_id
140: AND TRX_TYPE IN ('API', 'PAO', 'PAT', 'UDO',
141: 'APX', 'POP', 'POR', 'OIO');
142: END IF;