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_PRD_NONROUTINE_PVT dependencies on AHL_WORKORDERS

Line 191: ahl_workorders wo,

187: wo.workorder_id,
188: wo.status_code
189: FROM
190: ahl_visit_tasks_b vtsk,
191: ahl_workorders wo,
192: ahl_unit_effectivities_b ue
193: WHERE
194: ue.cs_incident_id = p_incident_id
195: AND ue.unit_effectivity_id = vtsk.unit_effectivity_id

Line 1469: AND mtl.organization_id = (SELECT organization_id from wip_discrete_jobs wdj, ahl_workorders awo where wdj.wip_entity_id = awo.wip_entity_id and awo.workorder_id = c_workorder_id)

1465: SELECT 'X'
1466: FROM mtl_system_items_b mtl, csi_item_instances csi
1467: WHERE csi.instance_id = c_instance_id
1468: AND csi.inventory_item_id = mtl.inventory_item_id
1469: AND mtl.organization_id = (SELECT organization_id from wip_discrete_jobs wdj, ahl_workorders awo where wdj.wip_entity_id = awo.wip_entity_id and awo.workorder_id = c_workorder_id)
1470: AND mtl.serial_number_control_code = 1;
1471:
1472: CURSOR validate_quantity(c_instance_id IN NUMBER, c_wo_id IN NUMBER) IS
1473: SELECT csi.quantity

Line 1475: ahl_workorders wo

1471:
1472: CURSOR validate_quantity(c_instance_id IN NUMBER, c_wo_id IN NUMBER) IS
1473: SELECT csi.quantity
1474: FROM CSI_ITEM_INSTANCES csi,
1475: ahl_workorders wo
1476: WHERE csi.instance_id = c_instance_id
1477: AND csi.wip_job_id = WO.WIP_ENTITY_ID
1478: AND wo.workorder_id = c_wo_id
1479: AND csi.location_type_code = 'WIP'

Line 2094: AHL_WORKORDERS B

2090: CURSOR default_item_org_id(p_workorder_id IN NUMBER) IS
2091: SELECT A.inventory_item_id,
2092: A.item_organization_id
2093: FROM AHL_VISIT_TASKS_B A,
2094: AHL_WORKORDERS B
2095: WHERE A.visit_task_id = B.visit_task_id
2096: AND B.workorder_id = p_workorder_id;
2097:
2098: CURSOR default_incident_type_id is

Line 2376: FROM AHL_WORKORDERS

2372: IS
2373: SELECT warranty_contract_id
2374: FROM AHL_WARRANTY_ENTITLEMENTS
2375: WHERE visit_task_id = (SELECT visit_task_id
2376: FROM AHL_WORKORDERS
2377: WHERE workorder_id = c_originating_wo_id);
2378: --
2379: CURSOR Get_workorder_id_csr (c_visit_task_id NUMBER)
2380: IS

Line 2382: FROM AHL_WORKORDERS

2378: --
2379: CURSOR Get_workorder_id_csr (c_visit_task_id NUMBER)
2380: IS
2381: SELECT workorder_id
2382: FROM AHL_WORKORDERS
2383: WHERE visit_task_id = c_visit_task_id;
2384: --
2385: l_api_name CONSTANT VARCHAR2(30) := 'Update_warranty_entitlements';
2386: l_full_name CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;

Line 2547: AHL_WORKORDERS WO

2543: cursor c_visit_task_csr(c_Nonroutine_wo_id IN NUMBER) IS
2544: SELECT
2545: WO.visit_task_id
2546: FROM
2547: AHL_WORKORDERS WO
2548: WHERE
2549: WO.workorder_id = c_Nonroutine_wo_id;
2550:
2551: -- Added by jaramana on Oct 15

Line 2557: ahl_workorders awo,

2553: IS
2554: SELECT
2555: awo.workorder_id
2556: FROM
2557: ahl_workorders awo,
2558: ahl_visit_tasks_b vtsk
2559: WHERE
2560: awo.visit_task_id = vtsk.visit_task_id
2561: AND awo.master_workorder_flag = 'Y'

Line 2591: FROM ahl_workorders

2587: --5. cursor for retrieving the non master workorder id which is passed as to_workorder_id when calling move_intance_location
2588: CURSOR get_nonmaster_wo_id(p_nr_wo_id IN NUMBER)
2589: IS
2590: SELECT workorder_id
2591: FROM ahl_workorders
2592: WHERE MASTER_WORKORDER_FLAG = 'N'
2593: AND wip_entity_id in
2594: (SELECT rel.child_object_id
2595: FROM wip_sched_relationships rel START

Line 2596: WITH REL.parent_object_id = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = p_nr_wo_id)

2592: WHERE MASTER_WORKORDER_FLAG = 'N'
2593: AND wip_entity_id in
2594: (SELECT rel.child_object_id
2595: FROM wip_sched_relationships rel START
2596: WITH REL.parent_object_id = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = p_nr_wo_id)
2597: CONNECT BY REL.parent_object_id = PRIOR REL.child_object_id
2598: AND REL.parent_object_type_id = PRIOR REL.child_object_type_id
2599: AND REL.relationship_type = 1
2600: )

Line 2608: AHL_WORKORDERS WO,

2604: --apattark added for ER #9368251
2605: CURSOR get_firm_planned_flag_csr(c_sr_id IN NUMBER) IS
2606: SELECT WIP.FIRM_PLANNED_FLAG
2607: FROM AHL_VISIT_TASKS_B VST,
2608: AHL_WORKORDERS WO,
2609: WIP_DISCRETE_JOBS WIP,
2610: AHL_UNIT_EFFECTIVITIES_B UE
2611: WHERE VST.SERVICE_REQUEST_ID = c_sr_id
2612: AND VST.TASK_TYPE_CODE IN ('SUMMARY')

Line 2636: SELECT wip_entity_id FROM ahl_workorders

2632: WHERE visit_task_id = p_task_id;
2633:
2634: -- Cursor to get the RTS workorder for a repair batch
2635: CURSOR c_get_rts_wo_id(p_rpr_batch_task_id NUMBER, p_instance_id NUMBER) IS
2636: SELECT wip_entity_id FROM ahl_workorders
2637: WHERE status_code IN ('1', '3', '6', '19', '20', '17')
2638: --unreleased, released, on-hold, parts hold and pending QA approval(open workorders)
2639: AND visit_task_id IN
2640: (SELECT vt.visit_task_id FROM AHL_VISIT_TASKS_B vt

Line 3185: from ahl_workorders

3181: WHERE incident_type_id = c_req_type_id;
3182: CURSOR GetOrgTaskDet(c_org_wo_id NUMBER)
3183: Is
3184: Select visit_task_id
3185: from ahl_workorders
3186: where workorder_id = c_org_wo_id;
3187:
3188: CURSOR getUnitEffectivity(p_incident_id NUMBER)
3189: IS

Line 3532: from ahl_workorders

3528: IS
3529: CURSOR GetWoName
3530: Is
3531: Select workorder_name
3532: from ahl_workorders
3533: where workorder_id = p_wo_id;
3534: Cursor GetInstanceNumber
3535: Is
3536: Select instance_number

Line 3570: from ahl_workorders

3566:
3567: CURSOR GetWoName
3568: Is
3569: Select workorder_name
3570: from ahl_workorders
3571: where workorder_id = p_sr_task_rec.originating_wo_id;
3572:
3573: CURSOR GetInstanceDet
3574: Is