[Home] [Help]
91: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
92:
93: END IF;
94:
95: DELETE FROM mrp_kanban_demand
96: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id
97: AND organization_id = g_kanban_info_rec.organization_id;
98:
99: /* this part of the code was originally in plan_kanban procedure
616: ELSE
617: l_line_id := p_line_id;
618: END IF;
619: IF g_debug THEN
620: g_log_message := 'Inserting into MRP_KANBAN_DEMAND';
621: MRP_UTIL.MRP_LOG (g_log_message);
622: g_log_message := 'LineN : ' || to_char(l_line_id);
623: MRP_UTIL.MRP_LOG (g_log_message);
624: g_log_message := 'in erd ItemN : ' || to_char(p_inventory_item_id);
635:
636: IF INSERT_OR_CASCADE = TRUE THEN
637: -- added for eKanban project.
638: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
639: INSERT INTO MRP_KANBAN_DEMAND (
640: DEMAND_ID,
641: KANBAN_PLAN_ID,
642: ORGANIZATION_ID,
643: INVENTORY_ITEM_ID,
659: LAST_UPDATED_BY,
660: CREATION_DATE,
661: CREATED_BY )
662: SELECT
663: mrp_kanban_demand_s.nextval,
664: g_kanban_info_rec.kanban_plan_id,
665: g_kanban_info_rec.organization_id,
666: p_inventory_item_id,
667: ps.subinventory_name,
692: G_PRODUCTION_KANBAN)
693: AND ps.inventory_item_id = p_inventory_item_id
694: AND ps.organization_id = g_kanban_info_rec.organization_id;
695: else
696: INSERT INTO MRP_KANBAN_DEMAND (
697: DEMAND_ID,
698: KANBAN_PLAN_ID,
699: ORGANIZATION_ID,
700: INVENTORY_ITEM_ID,
716: LAST_UPDATED_BY,
717: CREATION_DATE,
718: CREATED_BY )
719: SELECT
720: mrp_kanban_demand_s.nextval,
721: g_kanban_info_rec.kanban_plan_id,
722: g_kanban_info_rec.organization_id,
723: p_inventory_item_id,
724: ps.subinventory_name,
751: AND ps.inventory_item_id = p_inventory_item_id
752: AND ps.organization_id = g_kanban_info_rec.organization_id;
753: end if;
754: ELSE/* its cascade*/
755: INSERT INTO MRP_KANBAN_DEMAND (
756: DEMAND_ID,
757: KANBAN_PLAN_ID,
758: ORGANIZATION_ID,
759: INVENTORY_ITEM_ID,
775: LAST_UPDATED_BY,
776: CREATION_DATE,
777: CREATED_BY )
778: SELECT
779: mrp_kanban_demand_s.nextval,
780: g_kanban_info_rec.kanban_plan_id,
781: g_kanban_info_rec.organization_id,
782: p_inventory_item_id,
783: p_item_sub_inventory,
1223: -- now insert the demand into the kanban demand table if its > 0
1224:
1225: IF l_demand_quantity > 0 THEN
1226:
1227: INSERT INTO MRP_KANBAN_DEMAND (
1228: DEMAND_ID,
1229: KANBAN_PLAN_ID,
1230: ORGANIZATION_ID,
1231: INVENTORY_ITEM_ID,
1247: LAST_UPDATED_BY,
1248: CREATION_DATE,
1249: CREATED_BY )
1250: SELECT
1251: mrp_kanban_demand_s.nextval,
1252: g_kanban_info_rec.kanban_plan_id,
1253: g_kanban_info_rec.organization_id,
1254: l_component_id,
1255: l_subinventory,
1777: -- now insert the demand into the kanban demand table if its > 0
1778:
1779: IF l_demand_quantity > 0 THEN
1780:
1781: INSERT INTO MRP_KANBAN_DEMAND (
1782: DEMAND_ID,
1783: KANBAN_PLAN_ID,
1784: ORGANIZATION_ID,
1785: INVENTORY_ITEM_ID,
1801: LAST_UPDATED_BY,
1802: CREATION_DATE,
1803: CREATED_BY )
1804: SELECT
1805: mrp_kanban_demand_s.nextval,
1806: g_kanban_info_rec.kanban_plan_id,
1807: g_kanban_info_rec.organization_id,
1808: l_component_id,
1809: l_subinventory,
2280: -- now insert the demand into the kanban demand table if its > 0
2281:
2282: IF l_demand_quantity > 0 THEN
2283:
2284: INSERT INTO MRP_KANBAN_DEMAND (
2285: DEMAND_ID,
2286: KANBAN_PLAN_ID,
2287: ORGANIZATION_ID,
2288: INVENTORY_ITEM_ID,
2304: LAST_UPDATED_BY,
2305: CREATION_DATE,
2306: CREATED_BY )
2307: SELECT
2308: mrp_kanban_demand_s.nextval,
2309: g_kanban_info_rec.kanban_plan_id,
2310: g_kanban_info_rec.organization_id,
2311: l_component_id,
2312: l_subinventory,
2554: END IF;
2555: -- added for eKanban project.
2556: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
2557:
2558: INSERT INTO MRP_KANBAN_DEMAND (
2559: DEMAND_ID,
2560: KANBAN_PLAN_ID,
2561: ORGANIZATION_ID,
2562: INVENTORY_ITEM_ID,
2578: LAST_UPDATED_BY,
2579: CREATION_DATE,
2580: CREATED_BY )
2581: SELECT
2582: mrp_kanban_demand_s.nextval,
2583: g_kanban_info_rec.kanban_plan_id,
2584: g_kanban_info_rec.organization_id,
2585: p_inventory_item_id,
2586: ps.subinventory_name,
2616: AND ps.organization_id = g_kanban_info_rec.organization_id;
2617:
2618: else
2619:
2620: INSERT INTO MRP_KANBAN_DEMAND (
2621: DEMAND_ID,
2622: KANBAN_PLAN_ID,
2623: ORGANIZATION_ID,
2624: INVENTORY_ITEM_ID,
2640: LAST_UPDATED_BY,
2641: CREATION_DATE,
2642: CREATED_BY )
2643: SELECT
2644: mrp_kanban_demand_s.nextval,
2645: g_kanban_info_rec.kanban_plan_id,
2646: g_kanban_info_rec.organization_id,
2647: p_inventory_item_id,
2648: ps.subinventory_name,
2899: */
2900: -- added for eKanban project.
2901: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
2902:
2903: INSERT INTO MRP_KANBAN_DEMAND (
2904: DEMAND_ID,
2905: KANBAN_PLAN_ID,
2906: ORGANIZATION_ID,
2907: INVENTORY_ITEM_ID,
2923: LAST_UPDATED_BY,
2924: CREATION_DATE,
2925: CREATED_BY )
2926: SELECT
2927: mrp_kanban_demand_s.nextval,
2928: g_kanban_info_rec.kanban_plan_id,
2929: g_kanban_info_rec.organization_id,
2930: p_inventory_item_id,
2931: ps.subinventory_name,
2961: AND ps.organization_id = g_kanban_info_rec.organization_id;
2962:
2963: else
2964:
2965: INSERT INTO MRP_KANBAN_DEMAND (
2966: DEMAND_ID,
2967: KANBAN_PLAN_ID,
2968: ORGANIZATION_ID,
2969: INVENTORY_ITEM_ID,
2985: LAST_UPDATED_BY,
2986: CREATION_DATE,
2987: CREATED_BY )
2988: SELECT
2989: mrp_kanban_demand_s.nextval,
2990: g_kanban_info_rec.kanban_plan_id,
2991: g_kanban_info_rec.organization_id,
2992: p_inventory_item_id,
2993: ps.subinventory_name,
3209: END IF;
3210: -- added for eKanban project.
3211: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
3212:
3213: INSERT INTO MRP_KANBAN_DEMAND (
3214: DEMAND_ID,
3215: KANBAN_PLAN_ID,
3216: ORGANIZATION_ID,
3217: INVENTORY_ITEM_ID,
3233: LAST_UPDATED_BY,
3234: CREATION_DATE,
3235: CREATED_BY )
3236: SELECT
3237: mrp_kanban_demand_s.nextval,
3238: g_kanban_info_rec.kanban_plan_id,
3239: g_kanban_info_rec.organization_id,
3240: p_inventory_item_id,
3241: ps.subinventory_name,
3272:
3273: else
3274:
3275:
3276: INSERT INTO MRP_KANBAN_DEMAND (
3277: DEMAND_ID,
3278: KANBAN_PLAN_ID,
3279: ORGANIZATION_ID,
3280: INVENTORY_ITEM_ID,
3296: LAST_UPDATED_BY,
3297: CREATION_DATE,
3298: CREATED_BY )
3299: SELECT
3300: mrp_kanban_demand_s.nextval,
3301: g_kanban_info_rec.kanban_plan_id,
3302: g_kanban_info_rec.organization_id,
3303: p_inventory_item_id,
3304: ps.subinventory_name,
3927: SELECT (sum(demand_quantity)/p_total_workdays),
3928: inventory_item_id,
3929: subinventory,
3930: locator_id
3931: FROM mrp_kanban_demand
3932: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id
3933: AND organization_id = g_kanban_info_rec.organization_id
3934: AND (demand_date >= g_kanban_info_rec.start_date
3935: AND demand_date <= g_kanban_info_rec.cutoff_date )
4424: raise exc_error_condition;
4425: END IF;
4426:
4427: -- We now have all the demand for this plan run stored in the
4428: -- mrp_kanban_demand table. So go ahead and call the procedure
4429: -- to calculate Kanban quantities for the kanban items included
4430: -- in this plan
4431:
4432: --first calculate the total number of workdays between start date