APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on CSI_ITEM_INSTANCES

Line 180: instance_number = (select instance_number from csi_item_instances where serial_number = p_asset_rec.serial_number)

176: prod_organization_code = p_asset_rec.prod_organization_code
177: where interface_header_id = p_asset_rec.interface_header_id;
178:
179: update mtl_eam_asset_num_interface set
180: instance_number = (select instance_number from csi_item_instances where serial_number = p_asset_rec.serial_number)
181: where interface_header_id = p_asset_rec.interface_header_id;
182:
183: end update_row_calculated_values;
184: -- procedure to insert or update genealogy for PN locations

Line 533: FROM CSI_ITEM_INSTANCES

529: ORDER BY import_mode, import_scope, interface_header_id;
530:
531: CURSOR PROPERTY_CUR(child1 in number, parent1 in number) IS
532: SELECT pn_location_id, serial_number, inventory_item_id
533: FROM CSI_ITEM_INSTANCES
534: WHERE pn_location_id in (child1, parent1);
535:
536: asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE;
537: