120: -- Cursor for the Asset Number in this processing group and Header
121:
122: CURSOR asset_numbers_cur IS
123: SELECT instance_number
124: FROM MTL_EAM_ASSET_NUM_INTERFACE meani
125: WHERE meani.interface_header_id = p_interface_header_id
126: ;
127:
128: -- Cursor for all attribute Group in this processing group
293: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
294: SET (meavi.association_id) =
295: (SELECT meaag.association_id
296: FROM MTL_EAM_ASSET_ATTR_GROUPS meaag,
297: MTL_EAM_ASSET_NUM_INTERFACE meani
298: WHERE meani.inventory_item_id = meaag.inventory_item_id
299: AND meani.interface_header_id = meavi.interface_header_id
300: AND meavi.application_id = meaag.application_id
301: AND meavi.descriptive_flexfield_name = meaag.descriptive_flexfield_name