eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WO_COMP_UTILITY_PVT dependencies on EAM_ASSET_STATUS_HISTORY

Line 198: -- get the asset_status_id from eam_asset_status_history_s sequence

194: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
195: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Shutdown info ');
196: END IF;
197:
198: -- get the asset_status_id from eam_asset_status_history_s sequence
199: SELECT eam_asset_status_history_s.nextval
200: INTO i_asset_status_id
201: FROM dual;
202:

Line 199: SELECT eam_asset_status_history_s.nextval

195: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Shutdown info ');
196: END IF;
197:
198: -- get the asset_status_id from eam_asset_status_history_s sequence
199: SELECT eam_asset_status_history_s.nextval
200: INTO i_asset_status_id
201: FROM dual;
202:
203: -- Enhancement Bug 3852846

Line 204: UPDATE eam_asset_status_history

200: INTO i_asset_status_id
201: FROM dual;
202:
203: -- Enhancement Bug 3852846
204: UPDATE eam_asset_status_history
205: SET enable_flag = 'N'
206: , last_update_date = SYSDATE
207: , last_updated_by = FND_GLOBAL.user_id
208: , last_update_login = FND_GLOBAL.login_id

Line 216: INSERT INTO eam_asset_status_history

212: AND (enable_flag is NULL OR enable_flag = 'Y')
213: AND maintenance_object_type = s_maintenance_object_type
214: AND maintenance_object_id = s_maintenance_object_id;
215:
216: INSERT INTO eam_asset_status_history
217: (asset_status_id,
218: organization_id,
219: asset_group_id,
220: asset_number,