APPS.FLM_KANBAN dependencies on MRP_KANBAN_PLANS

Line 1082: FROM mrp_kanban_plans

1078: -- Get the total number of days
1079: --
1080: SELECT plan_start_date, plan_cutoff_date
1081: INTO l_sdate, l_edate
1082: FROM mrp_kanban_plans
1083: WHERE kanban_plan_id = l_kp_id;
1084:
1085: l_numdays := number_of_days(l_sdate, l_edate, l_org_id);
1086:

Line 1475: FROM mrp_kanban_plans

1471: --SELECT plan_start_date, plan_cutoff_date
1472: --Added nvl for start/end dates by ks for bug 3883026
1473: SELECT nvl(plan_start_date,sysdate), nvl(plan_cutoff_date,sysdate)
1474: INTO l_sdate, l_edate
1475: FROM mrp_kanban_plans
1476: WHERE kanban_plan_id = l_kp_id;
1477:
1478: SELECT DISTINCT segment1
1479: INTO l_des_comp