APPS.EAM_ASSET_NUMBER_PVT dependencies on CSI_ITEM_INSTANCES

Line 560: from csi_item_instances

556: l_instance_rec.instance_id := P_INSTANCE_ID; --replace
557:
558: select object_version_number
559: into l_object_version_number
560: from csi_item_instances
561: where instance_id = p_instance_id;
562:
563: l_instance_rec.object_version_number := l_object_version_number; --replace
564:

Line 744: from csi_item_instances

740: if (p_location_type_code <> 'INVENTORY') then
741:
742: select location_type_code
743: into l_old_location_type_code
744: from csi_item_instances
745: where instance_id = p_instance_id;
746:
747: if (l_old_location_type_code = 'INVENTORY') then
748: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_LOCATION_UPDATE');

Line 899: FROM CSI_ITEM_INSTANCES

895: )
896: IS
897: CURSOR C IS
898: SELECT *
899: FROM CSI_ITEM_INSTANCES
900: WHERE INSTANCE_ID = p_INSTANCE_ID
901: FOR UPDATE of INSTANCE_ID NOWAIT;
902: Recinfo C%ROWTYPE;
903: BEGIN

Line 1843: from csi_item_instances cii,

1839: select cii.serial_number,
1840: cii.instance_number,
1841: cii.inventory_item_id,
1842: msn.gen_object_id
1843: from csi_item_instances cii,
1844: mtl_serial_numbers msn,
1845: fa_additions fa,
1846: csi_i_assets cia,
1847: mtl_system_items msi,