APPS.AHL_UC_POS_NECES_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 105: mtl_system_items_kfv M

101: --
102: CURSOR get_node_details_csr (p_csi_instance_id IN NUMBER) IS
103: SELECT M.concatenated_segments, C.serial_number
104: FROM csi_item_instances C,
105: mtl_system_items_kfv M
106: WHERE instance_id = p_csi_instance_id
107: AND M.inventory_item_id = C.inventory_item_id
108: AND M.organization_id = c.inv_master_organization_id;
109: --

Line 141: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;

137: l_top_instance_id NUMBER;
138: l_csi_id NUMBER;
139: l_unit_csi_id NUMBER;
140: l_unit_name ahl_unit_config_headers.name%TYPE;
141: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
142: l_serial_number csi_item_instances.serial_number%TYPE;
143: --
144: BEGIN
145: