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 233: FROM mrp_forecast_designators

229: i IN NUMBER) IS
230: --v_org_id IN PLS_INTEGER) IS
231: CURSOR c_forecast IS
232: SELECT forecast_designator name, forecast_designator id
233: FROM mrp_forecast_designators
234: WHERE forecast_set IS NULL
235: AND organization_id = 207
236: ORDER BY forecast_designator;
237: BEGIN

Line 327: SELECT distinct forecast_designator name from mrp_forecast_designators

323: CURSOR c_period_types IS
324: SELECT distinct period_type name from gl_periods;
325:
326: CURSOR c_forecast IS
327: SELECT distinct forecast_designator name from mrp_forecast_designators
328: where forecast_set IS null
329: AND organization_id = 207
330: ORDER BY forecast_designator;
331: