APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_FORECAST_DESIGNATORS

Line 891: from mrp_forecast_designators

887: WHERE organization_id = g_kanban_info_rec.organization_id
888: AND ((forecast_designator = g_kanban_info_rec.input_designator) or
889: (forecast_designator in ( -- forecast set
890: select forecast_designator
891: from mrp_forecast_designators
892: where forecast_set = g_kanban_info_rec.input_designator)
893: )
894: )
895: AND inventory_item_id = p_top_item_id

Line 2459: from mrp_forecast_designators

2455: /*
2456: AND ((forecast_designator = g_kanban_info_rec.input_designator) or
2457: (forecast_designator in ( -- forecast set
2458: select forecast_designator
2459: from mrp_forecast_designators
2460: where forecast_set = g_kanban_info_rec.input_designator)
2461: )
2462: )
2463: */ --bug 5237549

Line 2468: FROM MRP_FORECAST_DESIGNATORS

2464: AND FORECAST_DESIGNATOR in (
2465: select g_kanban_info_rec.input_designator from dual
2466: union all
2467: SELECT FORECAST_DESIGNATOR
2468: FROM MRP_FORECAST_DESIGNATORS
2469: WHERE FORECAST_SET = g_kanban_info_rec.input_designator )
2470: AND inventory_item_id = p_inventory_item_id
2471: AND origination_type = p_demand_type
2472: AND nvl(line_id,0) = nvl(p_line_id,0)

Line 3515: from mrp_forecast_designators

3511: /*
3512: AND ((forecast_designator = g_kanban_info_rec.input_designator) or
3513: (forecast_designator in ( -- forecast set
3514: select forecast_designator
3515: from mrp_forecast_designators
3516: where forecast_set = g_kanban_info_rec.input_designator)
3517: )
3518: )
3519: */ --bug 5237549

Line 3524: FROM MRP_FORECAST_DESIGNATORS

3520: AND FORECAST_DESIGNATOR in (
3521: select g_kanban_info_rec.input_designator from dual
3522: union all
3523: SELECT FORECAST_DESIGNATOR
3524: FROM MRP_FORECAST_DESIGNATORS
3525: WHERE FORECAST_SET = g_kanban_info_rec.input_designator )
3526:
3527: AND ((rate_end_date IS NULL AND
3528: forecast_date BETWEEN Get_Offset_Date(