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 738: from csi_item_instances

734: if (p_location_type_code <> 'INVENTORY') then
735:
736: select location_type_code
737: into l_old_location_type_code
738: from csi_item_instances
739: where instance_id = p_instance_id;
740:
741: if (l_old_location_type_code = 'INVENTORY') then
742: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_LOCATION_UPDATE');

Line 893: FROM CSI_ITEM_INSTANCES

889: )
890: IS
891: CURSOR C IS
892: SELECT *
893: FROM CSI_ITEM_INSTANCES
894: WHERE INSTANCE_ID = p_INSTANCE_ID
895: FOR UPDATE of INSTANCE_ID NOWAIT;
896: Recinfo C%ROWTYPE;
897: BEGIN

Line 1816: from csi_item_instances cii,

1812: select cii.serial_number,
1813: cii.instance_number,
1814: cii.inventory_item_id,
1815: msn.gen_object_id
1816: from csi_item_instances cii,
1817: mtl_serial_numbers msn,
1818: fa_additions fa,
1819: csi_i_assets cia,
1820: mtl_system_items msi,