APPS.GME_API_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 439: FROM mtl_system_items_b

435: AND i.material_detail_id = v_material_detail_id;
436:
437: CURSOR cur_item(v_org_id NUMBER, v_inventory_item_id NUMBER) IS
438: SELECT primary_uom_code
439: FROM mtl_system_items_b
440: WHERE organization_id = V_org_id
441: AND inventory_item_id = V_inventory_item_id;
442:
443:

Line 982: l_item_rec mtl_system_items_b%ROWTYPE;

978: RETURN NUMBER
979: IS
980: l_api_name CONSTANT VARCHAR2 (30) := 'Is_reservation_fully_specified';
981: l_reservation_type NUMBER := 0;
982: l_item_rec mtl_system_items_b%ROWTYPE;
983: l_rsv_rec mtl_reservations%ROWTYPE;
984: l_rsv_type NUMBER;
985: l_msg_count NUMBER;
986: l_msg_list VARCHAR2(32767);

Line 1000: FROM mtl_system_items_b

996:
997: CURSOR cur_fetch_item (v_org_id NUMBER, v_inventory_item_id NUMBER)
998: IS
999: SELECT *
1000: FROM mtl_system_items_b
1001: WHERE organization_id = v_org_id
1002: AND inventory_item_id = v_inventory_item_id;
1003: BEGIN
1004: IF g_debug <= gme_debug.g_log_procedure THEN