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 AHL_WORKORDERS

Line 1369: AHL_WORKORDERS wo

1365: WHERE repair_batch_name = c_rpr_batch_name
1366: UNION ALL
1367: SELECT vts.visit_task_id
1368: FROM AHL_VISIT_TASKS_B vts,
1369: AHL_WORKORDERS wo
1370: WHERE vts.status_code NOT IN ('CANCELLED', 'CLOSED', 'DELETED')
1371: AND wo.visit_task_id = vts.visit_task_id
1372: AND wo.status_code NOT IN ('7','12','22' ) -- Cancelled,Closed,Deleted
1373: START WITH vts.cost_parent_id = ( SELECT visit_task_id

Line 1998: FROM ahl_workorders wo

1994: -- Cursor to get all the workorders associated to the given repair batch.
1995: CURSOR Get_Workorders(c_repair_batch_id NUMBER)
1996: IS
1997: SELECT wo.visit_task_id,wo.workorder_id,wo.workorder_name,wo.status_code
1998: FROM ahl_workorders wo
1999: WHERE wo.visit_task_id in
2000: ( SELECT vt.visit_task_id
2001: FROM AHL_VISIT_TASKS_B vt
2002: START WITH vt.visit_task_id = c_repair_batch_id

Line 2008: FROM ahl_workorders wo

2004:
2005: CURSOR get_wip_entity(c_repair_batch_id NUMBER)
2006: IS
2007: SELECT wo.visit_task_id,wo.workorder_id,wo.wip_entity_id
2008: FROM ahl_workorders wo
2009: WHERE wo.STATUS_CODE <> '7'
2010: AND wo.visit_task_id IN
2011: ( SELECT vt.visit_task_id
2012: FROM AHL_VISIT_TASKS_B vt

Line 2398: FROM ahl_workorders

2394:
2395: -- Get all the WIP Entity IDs pertaining to the instance and repair batch name
2396: CURSOR get_wip_entity_ids_csr(p_instance_id_csr NUMBER, p_repair_batch_csr VARCHAR2) IS
2397: SELECT wip_entity_id
2398: FROM ahl_workorders
2399: WHERE status_code IN ('1', '3', '6', '19', '20', '17')
2400: --unreleased, released, on-hold, parts hold and pending QA approval(open workorders)
2401: AND visit_task_id IN
2402: (SELECT vt.visit_task_id

Line 2521: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task

2517: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Updating tasks in repair batch to new instance');
2518: END IF;
2519: IF (l_log_statement >= l_log_current_level) THEN
2520: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before updating WOs');
2521: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task
2522: WHERE
2523: task.visit_task_id = wo.visit_task_id
2524: and task.instance_id = p_instance_id;
2525: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);

Line 2541: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task

2537: AND instance_id = p_instance_id;
2538:
2539: IF (l_log_statement >= l_log_current_level) THEN
2540: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After updating WOs');
2541: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task
2542: WHERE
2543: task.visit_task_id = wo.visit_task_id
2544: and task.instance_id = p_instance_id;
2545: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);

Line 3105: ahl_workorders wo, ahl_visit_tasks_b task,

3101: SELECT wo.workorder_id,
3102: task.inventory_item_id, visit.organization_id,
3103: wo.status_code
3104: FROM
3105: ahl_workorders wo, ahl_visit_tasks_b task,
3106: ahl_visits_b visit
3107: WHERE
3108: wo.wip_entity_id = p_wip_entity_id_csr
3109: AND task.visit_task_id = wo.visit_task_id

Line 3422: l_workorder_name AHL_WORKORDERS.WORKORDER_NAME%TYPE;

3418: l_error BOOLEAN;
3419: l_ahl_mtlxfr_tbl Ahl_Mtlxfr_Tbl_Type;
3420: l_remaining_qty NUMBER;
3421:
3422: l_workorder_name AHL_WORKORDERS.WORKORDER_NAME%TYPE;
3423: l_visit_task_id NUMBER;
3424:
3425: -- Cursor to retrieve all the open workorders associated to a given instance under a Repair Batch.
3426: CURSOR Get_Open_Workorders(c_repair_batch_id NUMBER, c_ins_id NUMBER)

Line 3429: FROM AHL_WORKORDERS

3425: -- Cursor to retrieve all the open workorders associated to a given instance under a Repair Batch.
3426: CURSOR Get_Open_Workorders(c_repair_batch_id NUMBER, c_ins_id NUMBER)
3427: IS
3428: SELECT workorder_name, visit_task_id
3429: FROM AHL_WORKORDERS
3430: WHERE status_code IN ('1', '3', '6', '17', '19', '20' ) -- unreleased, released, on-hold, draft, parts hold, pending QA (Open WO Statuses)
3431: AND visit_task_id IN
3432: (SELECT visit_task_id
3433: FROM AHL_VISIT_TASKS_B vt

Line 3443: FROM AHL_WORKORDERS WO,

3439: -- pdoki added for CMP-Marshaling Integration, Start.
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