APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_FORECAST_DESIGNATORS

Line 828: from mrp_forecast_designators

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
828: from mrp_forecast_designators
829: where forecast_set = g_kanban_info_rec.input_designator)
830: )
831: )
832: AND inventory_item_id = p_top_item_id

Line 2349: from mrp_forecast_designators

2345: /*
2346: AND ((forecast_designator = g_kanban_info_rec.input_designator) or
2347: (forecast_designator in ( -- forecast set
2348: select forecast_designator
2349: from mrp_forecast_designators
2350: where forecast_set = g_kanban_info_rec.input_designator)
2351: )
2352: )
2353: */ --bug 5237549

Line 2358: FROM MRP_FORECAST_DESIGNATORS

2354: AND FORECAST_DESIGNATOR in (
2355: select g_kanban_info_rec.input_designator from dual
2356: union all
2357: SELECT FORECAST_DESIGNATOR
2358: FROM MRP_FORECAST_DESIGNATORS
2359: WHERE FORECAST_SET = g_kanban_info_rec.input_designator )
2360: AND inventory_item_id = p_inventory_item_id
2361: AND origination_type = p_demand_type
2362: AND nvl(line_id,0) = nvl(p_line_id,0)

Line 3187: from mrp_forecast_designators

3183: /*
3184: AND ((forecast_designator = g_kanban_info_rec.input_designator) or
3185: (forecast_designator in ( -- forecast set
3186: select forecast_designator
3187: from mrp_forecast_designators
3188: where forecast_set = g_kanban_info_rec.input_designator)
3189: )
3190: )
3191: */ --bug 5237549

Line 3196: FROM MRP_FORECAST_DESIGNATORS

3192: AND FORECAST_DESIGNATOR in (
3193: select g_kanban_info_rec.input_designator from dual
3194: union all
3195: SELECT FORECAST_DESIGNATOR
3196: FROM MRP_FORECAST_DESIGNATORS
3197: WHERE FORECAST_SET = g_kanban_info_rec.input_designator )
3198:
3199: AND ((rate_end_date IS NULL AND
3200: forecast_date BETWEEN Get_Offset_Date(