APPS.MRP_KANBAN_PLAN_PK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 605: FROM bom_operational_routings

601: IF (p_line_id is NULL) THEN
602: Begin
603: SELECT line_id
604: INTO l_line_id
605: FROM bom_operational_routings
606: WHERE alternate_routing_designator is NULL
607: AND assembly_item_id = p_inventory_item_id
608: AND organization_id = g_kanban_info_rec.organization_id;
609: Exception

Line 849: -- off of bom_operational_routings

845:
846:
847: -- cursor component_cursor1 is the cursor that passes down demand
848: -- to the components feeding into a line. Notice that we are driving
849: -- off of bom_operational_routings
850: -- also if supply sub and locator are null in bom_inventory_components
851: -- we get it from wip supply locations from mtl_system_items - this
852: -- is ok for R-11, though we might have an issue here for R12
853:

Line 878: bom_operational_routings bor,

874: FROM mtl_system_items msi,
875: mrp_low_level_codes mllc,
876: bom_inventory_components bic,
877: bom_bill_of_materials bbom,
878: bom_operational_routings bor,
879: mtl_parameters mp
880: WHERE mp.organization_id = g_kanban_info_rec.organization_id
881: AND bor.line_id (+) = p_line_id
882: AND bor.assembly_item_id (+) = p_assembly_item_id

Line 1406: -- off of bom_operational_routings

1402:
1403:
1404: -- cursor component_cursor1 is the cursor that passes down demand
1405: -- to the components feeding into a line. Notice that we are driving
1406: -- off of bom_operational_routings
1407: -- also if supply sub and locator are null in bom_inventory_components
1408: -- we get it from wip supply locations from mtl_system_items - this
1409: -- is ok for R-11, though we might have an issue here for R12
1410:

Line 1891: -- off of bom_operational_routings

1887:
1888:
1889: -- cursor component_cursor1 is the cursor that passes down demand
1890: -- to the components feeding into a line. Notice that we are driving
1891: -- off of bom_operational_routings
1892: -- also if supply sub and locator are null in bom_inventory_components
1893: -- we get it from wip supply locations from mtl_system_items - this
1894: -- is ok for R-11, though we might have an issue here for R12
1895:

Line 1920: bom_operational_routings bor,

1916: FROM mtl_system_items msi,
1917: mrp_low_level_codes mllc,
1918: bom_inventory_components bic,
1919: bom_bill_of_materials bbom,
1920: bom_operational_routings bor,
1921: mtl_parameters mp
1922: WHERE mp.organization_id = g_kanban_info_rec.organization_id
1923: AND bor.line_id (+) = p_line_id
1924: AND bor.assembly_item_id (+) = p_assembly_item_id

Line 2414: FROM bom_operational_routings

2410: IF (l_line_id is NULL) THEN
2411: Begin
2412: SELECT line_id
2413: INTO l_line_id
2414: FROM bom_operational_routings
2415: WHERE alternate_routing_designator is NULL
2416: AND assembly_item_id = p_inventory_item_id
2417: AND organization_id = g_kanban_info_rec.organization_id;
2418: Exception

Line 2708: FROM bom_operational_routings

2704: IF (l_line_id is NULL) THEN
2705: Begin
2706: SELECT line_id
2707: INTO l_line_id
2708: FROM bom_operational_routings
2709: WHERE alternate_routing_designator is NULL
2710: AND assembly_item_id = p_inventory_item_id
2711: AND organization_id = g_kanban_info_rec.organization_id;
2712: Exception

Line 2947: FROM bom_operational_routings

2943: IF (l_line_id is NULL) THEN
2944: Begin
2945: SELECT line_id
2946: INTO l_line_id
2947: FROM bom_operational_routings
2948: WHERE alternate_routing_designator is NULL
2949: AND assembly_item_id = p_inventory_item_id
2950: AND organization_id = g_kanban_info_rec.organization_id;
2951: Exception