APPS.GME_MATERIAL_DETAIL_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 808: FROM mtl_system_items_kfv

804: IS
805: CURSOR item_no_cursor (v_org_id NUMBER, v_inventory_item_id NUMBER)
806: IS
807: SELECT concatenated_segments
808: FROM mtl_system_items_kfv
809: WHERE inventory_item_id = v_inventory_item_id
810: AND organization_id = v_org_id;
811:
812: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

Line 812: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

808: FROM mtl_system_items_kfv
809: WHERE inventory_item_id = v_inventory_item_id
810: AND organization_id = v_org_id;
811:
812: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
813: l_trans_id NUMBER;
814: l_item_rec mtl_system_items_b%ROWTYPE;
815:
816: open_actual_qty_error EXCEPTION;

Line 1914: l_segm mtl_system_items_kfv.concatenated_segments%TYPE;

1910: l_api_name CONSTANT VARCHAR2 (30) := 'validate_item_id';
1911: error_validate EXCEPTION;
1912: error_get_rec EXCEPTION;
1913:
1914: l_segm mtl_system_items_kfv.concatenated_segments%TYPE;
1915: l_field VARCHAR2(100);
1916:
1917: BEGIN
1918: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

Line 1981: FROM mtl_system_items_kfv

1977: END IF;
1978:
1979: SELECT concatenated_segments
1980: INTO l_segm
1981: FROM mtl_system_items_kfv
1982: WHERE inventory_item_id = p_item_id
1983: AND organization_id = p_org_id;
1984: --Bug#5078853
1985: gme_common_pvt.log_message ('GME_INV_ITEM_INSERT', 'ITEM_NO', l_field);