DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_FORECAST_DATES

Line 823: FROM mrp_forecast_dates

819: SELECT current_forecast_quantity,
820: forecast_date,
821: rate_end_date,
822: bucket_type
823: FROM mrp_forecast_dates
824: WHERE organization_id = g_kanban_info_rec.organization_id
825: AND ((forecast_designator = g_kanban_info_rec.input_designator) or
826: (forecast_designator in ( -- forecast set
827: select forecast_designator

Line 2343: FROM mrp_forecast_dates

2339: rate_end_date,
2340: bucket_type,
2341: origination_type,
2342: line_id
2343: FROM mrp_forecast_dates
2344: WHERE organization_id = g_kanban_info_rec.organization_id
2345: /*
2346: AND ((forecast_designator = g_kanban_info_rec.input_designator) or
2347: (forecast_designator in ( -- forecast set

Line 3181: FROM mrp_forecast_dates

3177: CURSOR cur_forecast_entries IS
3178: SELECT inventory_item_id,
3179: origination_type,
3180: line_id
3181: FROM mrp_forecast_dates
3182: WHERE organization_id = g_kanban_info_rec.organization_id
3183: /*
3184: AND ((forecast_designator = g_kanban_info_rec.input_designator) or
3185: (forecast_designator in ( -- forecast set