APPS.EAM_ASSET_NUMBER_PVT dependencies on CSI_I_ASSETS

Line 640: from csi_i_assets

636:
637: begin
638: select instance_asset_id, object_version_number
639: into l_asset_assignment_tbl(1).instance_asset_id,l_asset_assignment_tbl(1).object_version_number
640: from csi_i_assets
641: where instance_id = p_instance_id
642: and fa_asset_id = fa_asset_id;
643: exception
644: when no_data_found then

Line 683: from csi_i_assets where instance_id = p_instance_id;

679: --5474749 condition added
680: if nvl(p_disassociate_fa_flag,'N') = 'Y' then
681:
682: select fa_asset_id into l_asset_assignment_tbl(1).fa_asset_id
683: from csi_i_assets where instance_id = p_instance_id;
684:
685: begin
686: select instance_asset_id, object_version_number
687: into l_asset_assignment_tbl(1).instance_asset_id,l_asset_assignment_tbl(1).object_version_number

Line 688: from csi_i_assets

684:
685: begin
686: select instance_asset_id, object_version_number
687: into l_asset_assignment_tbl(1).instance_asset_id,l_asset_assignment_tbl(1).object_version_number
688: from csi_i_assets
689: where instance_id = p_instance_id
690: and fa_asset_id = l_asset_assignment_tbl(1).fa_asset_id;
691: exception
692: when no_data_found then

Line 1819: csi_i_assets cia,

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,
1821: mtl_parameters mp,
1822: eam_org_maint_defaults eomd,
1823: mtl_system_items msi_prod,