APPS.EAM_ASSET_NUMBER_PVT dependencies on CSI_I_ASSETS

Line 642: from csi_i_assets

638: -- Bug 13387261 (Fixing in both R12 and 12.1)
639: -- Selecting only active instance asset ids
640: select instance_asset_id, object_version_number
641: into l_asset_assignment_tbl(1).instance_asset_id,l_asset_assignment_tbl(1).object_version_number
642: from csi_i_assets
643: where instance_id = p_instance_id
644: and fa_asset_id = fa_asset_id
645: and (active_end_date IS NULL OR active_end_date>sysdate);
646: exception

Line 688: from csi_i_assets where instance_id = p_instance_id and (active_end_date IS NULL OR active_end_date>sysdate);

684:
685: -- Bug 13387261 (Fixing in both R12 and 12.1)
686: -- Selecting only active instance asset ids
687: select fa_asset_id into l_asset_assignment_tbl(1).fa_asset_id
688: from csi_i_assets where instance_id = p_instance_id and (active_end_date IS NULL OR active_end_date>sysdate);
689:
690: begin
691: select instance_asset_id, object_version_number
692: into l_asset_assignment_tbl(1).instance_asset_id,l_asset_assignment_tbl(1).object_version_number

Line 693: from csi_i_assets

689:
690: begin
691: select instance_asset_id, object_version_number
692: into l_asset_assignment_tbl(1).instance_asset_id,l_asset_assignment_tbl(1).object_version_number
693: from csi_i_assets
694: where instance_id = p_instance_id
695: and fa_asset_id = l_asset_assignment_tbl(1).fa_asset_id
696: and (active_end_date IS NULL OR active_end_date>sysdate);
697: exception

Line 1846: csi_i_assets cia,

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,
1848: mtl_parameters mp,
1849: eam_org_maint_defaults eomd,
1850: mtl_system_items msi_prod,