DBA Data[Home] [Help]

APPS.MRP_PARAMETER_MRPFSETA dependencies on MRP_FORECAST_DESIGNATORS

Line 103: from mrp_forecast_designators

99: return FALSE;
100: else
101: select forecast_designator
102: into l_from_forecast
103: from mrp_forecast_designators
104: where organization_id = p_org_id
105: and forecast_set is null
106: and forecast_designator = P_FROM_FORECAST;
107:

Line 110: from mrp_forecast_designators

106: and forecast_designator = P_FROM_FORECAST;
107:
108: select forecast_designator
109: into l_to_forecast
110: from mrp_forecast_designators
111: where organization_id = p_org_id
112: and forecast_set is null
113: and forecast_designator >= P_FROM_FORECAST
114: and forecast_designator = P_TO_FORECAST;

Line 225: FROM mrp_forecast_designators

221: i IN NUMBER) IS
222: --v_org_id IN PLS_INTEGER) IS
223: CURSOR c_forecast IS
224: SELECT forecast_designator name, forecast_designator id
225: FROM mrp_forecast_designators
226: WHERE forecast_set IS NULL
227: AND organization_id = 207
228: ORDER BY forecast_designator;
229: BEGIN

Line 316: SELECT distinct forecast_designator name from mrp_forecast_designators

312: CURSOR c_period_types IS
313: SELECT distinct period_type name from gl_periods;
314:
315: CURSOR c_forecast IS
316: SELECT distinct forecast_designator name from mrp_forecast_designators
317: where forecast_set IS null
318: AND organization_id = 207
319: ORDER BY forecast_designator;
320: