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_OP_COMP_UTILITY_PVT dependencies on EAM_ASSET_STATUS_HISTORY

Line 160: SELECT eam_asset_status_history_s.nextval

156: -- SHUTDOWN History
157: IF (p_eam_op_comp_rec.shutdown_start_date IS NOT NULL) OR
158: (p_eam_op_comp_rec.shutdown_end_date IS NOT NULL) THEN
159:
160: SELECT eam_asset_status_history_s.nextval
161: INTO l_status_id
162: FROM dual;
163:
164: --bug 3572376: pass maintenance object type and id

Line 184: INSERT INTO EAM_ASSET_STATUS_HISTORY(

180: l_maintenance_object_type := NULL;
181: l_maintenance_object_id := NULL;
182: END;
183:
184: INSERT INTO EAM_ASSET_STATUS_HISTORY(
185: asset_status_id,
186: asset_group_id,
187: asset_number,
188: organization_id,

Line 297: UPDATE eam_asset_status_history

293: AND wo.operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
294:
295: -- Enhancemnet Bug 3852846
296: IF NVL(to_number(l_shutdown_type),1) = 2 THEN
297: UPDATE eam_asset_status_history
298: SET enable_flag = 'N'
299: , last_update_date = SYSDATE
300: , last_updated_by = FND_GLOBAL.user_id
301: , last_update_login = FND_GLOBAL.login_id