DBA Data[Home] [Help]

APPS.MRP_FORECAST dependencies on MRP_FORECAST_DESIGNATORS

Line 67: mrp_forecast_designators desig

63: SELECT cal1.calendar_date
64: INTO var_fc_begin_date
65: FROM bom_calendar_dates cal1,
66: bom_calendar_dates cal2,
67: mrp_forecast_designators desig
68: WHERE cal1.seq_num =
69: cal2.prior_seq_num -
70: LEAST(NVL(desig.backward_update_time_fence, 0),
71: cal2.seq_num - 1)

Line 752: FROM mrp_forecast_designators

748: ELSE
749: DECLARE
750: CURSOR FORECAST_DESIGS IS
751: SELECT forecast_designator
752: FROM mrp_forecast_designators
753: WHERE organization_id = arg_org_id
754: AND (forecast_set = arg_forecast_set
755: OR forecast_designator = arg_forecast_set);
756: BEGIN