DBA Data[Home] [Help]

APPS.GME_REROUTE_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 361: FROM mtl_system_items_b

357: --{ /* IF x_batch_header_rec.routing_id IS NOT NULL */
358: IF (l_no_steps) THEN
359: SELECT primary_uom_code
360: INTO l_prim_item_um
361: FROM mtl_system_items_b
362: WHERE inventory_item_id = l_inventory_item_id
363: AND organization_id = x_batch_header_rec.organization_id;
364:
365: OPEN get_prim_prod (x_batch_header_rec.batch_id

Line 902: ,mtl_system_items_b msib

898: IS
899: SELECT d.inventory_item_id, d.organization_id, d.plan_qty
900: ,d.dtl_um line_um, msib.primary_uom_code item_um
901: FROM gme_material_details d
902: ,mtl_system_items_b msib
903: ,gmd_recipe_validity_rules v
904: WHERE d.batch_id = v_batch_id
905: AND d.line_type = 1
906: AND msib.inventory_item_id = d.inventory_item_id