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 432: FROM mtl_system_items

428:
429:
430: SELECT primary_uom_code
431: INTO l_prim_item_um
432: FROM mtl_system_items
433: WHERE inventory_item_id =
434: l_recipe_validity_rule_rec.inventory_item_id
435: AND organization_id = l_batch_header_rec.organization_id;
436: