DBA Data[Home] [Help]

APPS.GME_RESCHEDULE_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS

Line 152: FROM mtl_system_items

148: p_item_id gme_material_details.inventory_item_id%TYPE
149: ,p_organization_id gme_material_details.organization_id%TYPE)
150: IS
151: SELECT segment1
152: FROM mtl_system_items
153: WHERE organization_id = p_organization_id
154: AND inventory_item_id = p_item_id;
155:
156: CURSOR cur_is_charge_associated (v_batch_id NUMBER)

Line 424: FROM mtl_system_items

420:
421:
422: SELECT primary_uom_code
423: INTO l_prim_item_um
424: FROM mtl_system_items
425: WHERE inventory_item_id =
426: l_recipe_validity_rule_rec.inventory_item_id
427: AND organization_id = l_batch_header_rec.organization_id;
428: