APPS.MRP_KANBAN_PLAN_PK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 608: FROM bom_operational_routings

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

Line 912: -- off of bom_operational_routings

908:
909:
910: -- cursor component_cursor1 is the cursor that passes down demand
911: -- to the components feeding into a line. Notice that we are driving
912: -- off of bom_operational_routings
913: -- also if supply sub and locator are null in bom_inventory_components
914: -- we get it from wip supply locations from mtl_system_items - this
915: -- is ok for R-11, though we might have an issue here for R12
916:

Line 941: bom_operational_routings bor,

937: FROM mtl_system_items msi,
938: mrp_low_level_codes mllc,
939: bom_inventory_components bic,
940: bom_bill_of_materials bbom,
941: bom_operational_routings bor,
942: mtl_parameters mp
943: WHERE mp.organization_id = g_kanban_info_rec.organization_id
944: AND bor.line_id (+) = p_line_id
945: AND bor.assembly_item_id (+) = p_assembly_item_id

Line 1485: -- off of bom_operational_routings

1481:
1482:
1483: -- cursor component_cursor1 is the cursor that passes down demand
1484: -- to the components feeding into a line. Notice that we are driving
1485: -- off of bom_operational_routings
1486: -- also if supply sub and locator are null in bom_inventory_components
1487: -- we get it from wip supply locations from mtl_system_items - this
1488: -- is ok for R-11, though we might have an issue here for R12
1489:

Line 1986: -- off of bom_operational_routings

1982:
1983:
1984: -- cursor component_cursor1 is the cursor that passes down demand
1985: -- to the components feeding into a line. Notice that we are driving
1986: -- off of bom_operational_routings
1987: -- also if supply sub and locator are null in bom_inventory_components
1988: -- we get it from wip supply locations from mtl_system_items - this
1989: -- is ok for R-11, though we might have an issue here for R12
1990:

Line 2015: bom_operational_routings bor,

2011: FROM mtl_system_items msi,
2012: mrp_low_level_codes mllc,
2013: bom_inventory_components bic,
2014: bom_bill_of_materials bbom,
2015: bom_operational_routings bor,
2016: mtl_parameters mp
2017: WHERE mp.organization_id = g_kanban_info_rec.organization_id
2018: AND bor.line_id (+) = p_line_id
2019: AND bor.assembly_item_id (+) = p_assembly_item_id

Line 2524: FROM bom_operational_routings

2520: IF (l_line_id is NULL) THEN
2521: Begin
2522: SELECT line_id
2523: INTO l_line_id
2524: FROM bom_operational_routings
2525: WHERE alternate_routing_designator is NULL
2526: AND assembly_item_id = p_inventory_item_id
2527: AND organization_id = g_kanban_info_rec.organization_id;
2528: Exception

Line 2890: FROM bom_operational_routings

2886: IF (l_line_id is NULL) THEN
2887: Begin
2888: SELECT line_id
2889: INTO l_line_id
2890: FROM bom_operational_routings
2891: WHERE alternate_routing_designator is NULL
2892: AND assembly_item_id = p_inventory_item_id
2893: AND organization_id = g_kanban_info_rec.organization_id;
2894: Exception

Line 3201: FROM bom_operational_routings

3197: IF (l_line_id is NULL) THEN
3198: Begin
3199: SELECT line_id
3200: INTO l_line_id
3201: FROM bom_operational_routings
3202: WHERE alternate_routing_designator is NULL
3203: AND assembly_item_id = p_inventory_item_id
3204: AND organization_id = g_kanban_info_rec.organization_id;
3205: Exception