APPS.GME_MATERIAL_DETAIL_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 848: FROM mtl_system_items_kfv

844: IS
845: CURSOR item_no_cursor (v_org_id NUMBER, v_inventory_item_id NUMBER)
846: IS
847: SELECT concatenated_segments
848: FROM mtl_system_items_kfv
849: WHERE inventory_item_id = v_inventory_item_id
850: AND organization_id = v_org_id;
851:
852: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

Line 852: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

848: FROM mtl_system_items_kfv
849: WHERE inventory_item_id = v_inventory_item_id
850: AND organization_id = v_org_id;
851:
852: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
853: l_trans_id NUMBER;
854: l_item_rec mtl_system_items_b%ROWTYPE;
855:
856: open_actual_qty_error EXCEPTION;

Line 2057: l_segm mtl_system_items_kfv.concatenated_segments%TYPE;

2053: l_api_name CONSTANT VARCHAR2 (30) := 'validate_item_id';
2054: error_validate EXCEPTION;
2055: error_get_rec EXCEPTION;
2056:
2057: l_segm mtl_system_items_kfv.concatenated_segments%TYPE;
2058: l_field VARCHAR2(100);
2059:
2060: BEGIN
2061: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

Line 2125: FROM mtl_system_items_kfv

2121: END IF;
2122:
2123: SELECT concatenated_segments
2124: INTO l_segm
2125: FROM mtl_system_items_kfv
2126: WHERE inventory_item_id = p_item_id
2127: AND organization_id = p_org_id;
2128: --Bug#5078853
2129: gme_common_pvt.log_message ('GME_INV_ITEM_INSERT', 'ITEM_NO', l_field);