APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on CSI_ITEM_INSTANCES

Line 181: instance_number = (select instance_number from csi_item_instances

177: where interface_header_id = p_asset_rec.interface_header_id;
178:
179: --Start 8579859
180: update mtl_eam_asset_num_interface set
181: instance_number = (select instance_number from csi_item_instances
182: where serial_number = p_asset_rec.serial_number and
183: last_vld_organization_id =p_asset_rec.CURRENT_ORGANIZATION_ID and
184: inventory_item_id =p_asset_rec.inventory_item_id)
185: where interface_header_id = p_asset_rec.interface_header_id;

Line 539: FROM CSI_ITEM_INSTANCES

535: ORDER BY import_mode, import_scope, interface_header_id;
536:
537: CURSOR PROPERTY_CUR(child1 in number, parent1 in number) IS
538: SELECT pn_location_id, serial_number, inventory_item_id
539: FROM CSI_ITEM_INSTANCES
540: WHERE pn_location_id in (child1, parent1);
541:
542: asset_rec MTL_EAM_ASSET_NUM_INTERFACE%ROWTYPE;
543: