APPS.GME_API_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 418: FROM mtl_system_items_b

414: AND i.material_detail_id = v_material_detail_id;
415:
416: CURSOR cur_item(v_org_id NUMBER, v_inventory_item_id NUMBER) IS
417: SELECT primary_uom_code
418: FROM mtl_system_items_b
419: WHERE organization_id = V_org_id
420: AND inventory_item_id = V_inventory_item_id;
421:
422:

Line 958: l_item_rec mtl_system_items_b%ROWTYPE;

954: RETURN NUMBER
955: IS
956: l_api_name CONSTANT VARCHAR2 (30) := 'Is_reservation_fully_specified';
957: l_reservation_type NUMBER := 0;
958: l_item_rec mtl_system_items_b%ROWTYPE;
959: l_rsv_rec mtl_reservations%ROWTYPE;
960: l_rsv_type NUMBER;
961: l_msg_count NUMBER;
962: l_msg_list VARCHAR2(32767);

Line 976: FROM mtl_system_items_b

972:
973: CURSOR cur_fetch_item (v_org_id NUMBER, v_inventory_item_id NUMBER)
974: IS
975: SELECT *
976: FROM mtl_system_items_b
977: WHERE organization_id = v_org_id
978: AND inventory_item_id = v_inventory_item_id;
979: BEGIN
980: IF g_debug <= gme_debug.g_log_procedure THEN