eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_KANBAN_DEMAND

Line 93: DELETE FROM mrp_kanban_demand

89: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
90:
91: END IF;
92:
93: DELETE FROM mrp_kanban_demand
94: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id
95: AND organization_id = g_kanban_info_rec.organization_id;
96:
97: /* this part of the code was originally in plan_kanban procedure

Line 617: g_log_message := 'Inserting into MRP_KANBAN_DEMAND';

613: ELSE
614: l_line_id := p_line_id;
615: END IF;
616: IF g_debug THEN
617: g_log_message := 'Inserting into MRP_KANBAN_DEMAND';
618: MRP_UTIL.MRP_LOG (g_log_message);
619: g_log_message := 'LineN : ' || to_char(l_line_id);
620: MRP_UTIL.MRP_LOG (g_log_message);
621: g_log_message := 'in erd ItemN : ' || to_char(p_inventory_item_id);

Line 634: INSERT INTO MRP_KANBAN_DEMAND (

630:
631: IF l_demand_quantity > 0 THEN
632:
633: IF INSERT_OR_CASCADE = TRUE THEN
634: INSERT INTO MRP_KANBAN_DEMAND (
635: DEMAND_ID,
636: KANBAN_PLAN_ID,
637: ORGANIZATION_ID,
638: INVENTORY_ITEM_ID,

Line 658: mrp_kanban_demand_s.nextval,

654: LAST_UPDATED_BY,
655: CREATION_DATE,
656: CREATED_BY )
657: SELECT
658: mrp_kanban_demand_s.nextval,
659: g_kanban_info_rec.kanban_plan_id,
660: g_kanban_info_rec.organization_id,
661: p_inventory_item_id,
662: ps.subinventory_name,

Line 692: INSERT INTO MRP_KANBAN_DEMAND (

688: G_PRODUCTION_KANBAN)
689: AND ps.inventory_item_id = p_inventory_item_id
690: AND ps.organization_id = g_kanban_info_rec.organization_id;
691: ELSE/* its cascade*/
692: INSERT INTO MRP_KANBAN_DEMAND (
693: DEMAND_ID,
694: KANBAN_PLAN_ID,
695: ORGANIZATION_ID,
696: INVENTORY_ITEM_ID,

Line 716: mrp_kanban_demand_s.nextval,

712: LAST_UPDATED_BY,
713: CREATION_DATE,
714: CREATED_BY )
715: SELECT
716: mrp_kanban_demand_s.nextval,
717: g_kanban_info_rec.kanban_plan_id,
718: g_kanban_info_rec.organization_id,
719: p_inventory_item_id,
720: p_item_sub_inventory,

Line 1154: INSERT INTO MRP_KANBAN_DEMAND (

1150: -- now insert the demand into the kanban demand table if its > 0
1151:
1152: IF l_demand_quantity > 0 THEN
1153:
1154: INSERT INTO MRP_KANBAN_DEMAND (
1155: DEMAND_ID,
1156: KANBAN_PLAN_ID,
1157: ORGANIZATION_ID,
1158: INVENTORY_ITEM_ID,

Line 1178: mrp_kanban_demand_s.nextval,

1174: LAST_UPDATED_BY,
1175: CREATION_DATE,
1176: CREATED_BY )
1177: SELECT
1178: mrp_kanban_demand_s.nextval,
1179: g_kanban_info_rec.kanban_plan_id,
1180: g_kanban_info_rec.organization_id,
1181: l_component_id,
1182: l_subinventory,

Line 1691: INSERT INTO MRP_KANBAN_DEMAND (

1687: -- now insert the demand into the kanban demand table if its > 0
1688:
1689: IF l_demand_quantity > 0 THEN
1690:
1691: INSERT INTO MRP_KANBAN_DEMAND (
1692: DEMAND_ID,
1693: KANBAN_PLAN_ID,
1694: ORGANIZATION_ID,
1695: INVENTORY_ITEM_ID,

Line 1715: mrp_kanban_demand_s.nextval,

1711: LAST_UPDATED_BY,
1712: CREATION_DATE,
1713: CREATED_BY )
1714: SELECT
1715: mrp_kanban_demand_s.nextval,
1716: g_kanban_info_rec.kanban_plan_id,
1717: g_kanban_info_rec.organization_id,
1718: l_component_id,
1719: l_subinventory,

Line 2179: INSERT INTO MRP_KANBAN_DEMAND (

2175: -- now insert the demand into the kanban demand table if its > 0
2176:
2177: IF l_demand_quantity > 0 THEN
2178:
2179: INSERT INTO MRP_KANBAN_DEMAND (
2180: DEMAND_ID,
2181: KANBAN_PLAN_ID,
2182: ORGANIZATION_ID,
2183: INVENTORY_ITEM_ID,

Line 2203: mrp_kanban_demand_s.nextval,

2199: LAST_UPDATED_BY,
2200: CREATION_DATE,
2201: CREATED_BY )
2202: SELECT
2203: mrp_kanban_demand_s.nextval,
2204: g_kanban_info_rec.kanban_plan_id,
2205: g_kanban_info_rec.organization_id,
2206: l_component_id,
2207: l_subinventory,

Line 2446: INSERT INTO MRP_KANBAN_DEMAND (

2442: RETURN FALSE;
2443: END IF;
2444: END IF;
2445:
2446: INSERT INTO MRP_KANBAN_DEMAND (
2447: DEMAND_ID,
2448: KANBAN_PLAN_ID,
2449: ORGANIZATION_ID,
2450: INVENTORY_ITEM_ID,

Line 2470: mrp_kanban_demand_s.nextval,

2466: LAST_UPDATED_BY,
2467: CREATION_DATE,
2468: CREATED_BY )
2469: SELECT
2470: mrp_kanban_demand_s.nextval,
2471: g_kanban_info_rec.kanban_plan_id,
2472: g_kanban_info_rec.organization_id,
2473: p_inventory_item_id,
2474: ps.subinventory_name,

Line 2719: INSERT INTO MRP_KANBAN_DEMAND (

2715: End;
2716: END IF;
2717: */
2718:
2719: INSERT INTO MRP_KANBAN_DEMAND (
2720: DEMAND_ID,
2721: KANBAN_PLAN_ID,
2722: ORGANIZATION_ID,
2723: INVENTORY_ITEM_ID,

Line 2743: mrp_kanban_demand_s.nextval,

2739: LAST_UPDATED_BY,
2740: CREATION_DATE,
2741: CREATED_BY )
2742: SELECT
2743: mrp_kanban_demand_s.nextval,
2744: g_kanban_info_rec.kanban_plan_id,
2745: g_kanban_info_rec.organization_id,
2746: p_inventory_item_id,
2747: ps.subinventory_name,

Line 2957: INSERT INTO MRP_KANBAN_DEMAND (

2953: Null;
2954: End;
2955: END IF;
2956:
2957: INSERT INTO MRP_KANBAN_DEMAND (
2958: DEMAND_ID,
2959: KANBAN_PLAN_ID,
2960: ORGANIZATION_ID,
2961: INVENTORY_ITEM_ID,

Line 2981: mrp_kanban_demand_s.nextval,

2977: LAST_UPDATED_BY,
2978: CREATION_DATE,
2979: CREATED_BY )
2980: SELECT
2981: mrp_kanban_demand_s.nextval,
2982: g_kanban_info_rec.kanban_plan_id,
2983: g_kanban_info_rec.organization_id,
2984: p_inventory_item_id,
2985: ps.subinventory_name,

Line 3498: FROM mrp_kanban_demand

3494: SELECT (sum(demand_quantity)/p_total_workdays),
3495: inventory_item_id,
3496: subinventory,
3497: locator_id
3498: FROM mrp_kanban_demand
3499: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id
3500: AND organization_id = g_kanban_info_rec.organization_id
3501: AND (demand_date >= g_kanban_info_rec.start_date
3502: AND demand_date <= g_kanban_info_rec.cutoff_date )

Line 3934: -- mrp_kanban_demand table. So go ahead and call the procedure

3930: raise exc_error_condition;
3931: END IF;
3932:
3933: -- We now have all the demand for this plan run stored in the
3934: -- mrp_kanban_demand table. So go ahead and call the procedure
3935: -- to calculate Kanban quantities for the kanban items included
3936: -- in this plan
3937:
3938: --first calculate the total number of workdays between start date