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.AHL_CMP_PVT dependencies on WIP_DISCRETE_JOBS

Line 2550: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs

2546: END IF;
2547: IF (l_log_statement >= l_log_current_level) THEN
2548: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling EAM_PROCESS_WO_PUB.'
2549: || 'process_wo');
2550: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs
2551: where maintenance_object_id = p_instance_id;
2552: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount Before exec'
2553: || l_wipEntityIds);
2554: END IF;

Line 2585: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs

2581: END IF;
2582: IF (l_log_statement >= l_log_current_level) THEN
2583: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'
2584: || 'process_wo');
2585: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs
2586: where maintenance_object_id = p_instance_id;
2587: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount after exec'
2588: || l_wipEntityIds);
2589: END IF;

Line 3444: WIP_DISCRETE_JOBS WDJ

3440: CURSOR Get_RTS_WO_Details( c_repair_batch VARCHAR2, c_ins_id NUMBER)
3441: IS
3442: SELECT wo.workorder_id,wo.workorder_name,wo.wip_entity_id,wdj.REBUILD_ITEM_ID,wdj.MAINTENANCE_OBJECT_ID
3443: FROM AHL_WORKORDERS WO,
3444: WIP_DISCRETE_JOBS WDJ
3445: WHERE WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
3446: and wo.status_code NOT IN ('7','12','17','22' ) -- Cancelled,Closed,Draft and Deleted
3447: AND VISIT_TASK_ID IN
3448: ( SELECT vt.visit_task_id