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_COMPLETIONS_PVT dependencies on AHL_VISITS_B

Line 279: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,

275: NVL(VTS.instance_id, VST.item_instance_id),
276: CSI.lot_number,
277: CSI.serial_number,
278: CSI.quantity
279: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,
280: AHL_UNIT_EFFECTIVITIES_B UE
281: WHERE VTS.unit_effectivity_id = UE.unit_effectivity_id
282: AND NVL(VTS.instance_id, VST.item_instance_id) = CSI.instance_id
283: AND VST.visit_id = VTS.visit_id

Line 291: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,

287: SELECT nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id ),
288: CSI.lot_number,
289: CSI.serial_number,
290: CSI.quantity
291: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,
292: (select instance_id from ahl_visit_tasks_b where visit_id = c_visit_id and instance_id IS NOT NULL AND rownum = 1) VTSINST
293: WHERE nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id )= CSI.INSTANCE_ID
294: AND VST.visit_id = c_visit_id;
295:

Line 4556: AHL_VISITS_B VS

4552: (
4553: SELECT PWO.wip_entity_id
4554: FROM AHL_WORKORDERS PWO,
4555: AHL_VISIT_TASKS_B VT,
4556: AHL_VISITS_B VS
4557: WHERE PWO.master_workorder_flag = 'Y'
4558: AND PWO.visit_task_id = VT.visit_task_id
4559: AND VS.VISIT_ID = VT.VISIT_ID
4560: AND VS.STATUS_CODE NOT IN ('CLOSED','CANCELLED')

Line 4621: AHL_VISITS_B VS

4617: (
4618: SELECT PWO.wip_entity_id
4619: FROM AHL_WORKORDERS PWO,
4620: AHL_VISIT_TASKS_B VT,
4621: AHL_VISITS_B VS
4622: WHERE PWO.master_workorder_flag = 'Y'
4623: AND PWO.visit_task_id = VT.visit_task_id
4624: AND VS.VISIT_ID = VT.VISIT_ID
4625: AND VS.STATUS_CODE NOT IN ('CLOSED','CANCELLED')

Line 8158: AHL_VISITS_B VST

8154: WO.plan_id wo_plan_id,
8155: WO.collection_id wo_collection_id
8156: FROM WIP_DISCRETE_JOBS WIP,
8157: AHL_WORKORDERS WO,
8158: AHL_VISITS_B VST
8159: WHERE WIP.wip_entity_id = WO.wip_entity_id
8160: AND WO.visit_task_id IS NULL
8161: AND WO.master_workorder_flag = 'Y'
8162: AND WO.visit_id = VST.visit_id

Line 8432: from ahl_visits_b where visit_id = c_visit_id;

8428:
8429: --sukhwsin: SB Effectivity - Added cursor to derive uc_header_id on visit
8430: CURSOR get_unit_on_visit(c_visit_id NUMBER) IS
8431: Select decode(item_instance_id,null,-1,AHL_UTIL_UC_PKG.get_uc_header_id(item_instance_id)) uc_header_id
8432: from ahl_visits_b where visit_id = c_visit_id;
8433:
8434: -- MANESING, 14-May-2012, added following cursor
8435: -- Cursor to find default Stage work order id for the given visit
8436: CURSOR get_default_stage_wo_csr (c_visit_id NUMBER) IS

Line 11775: FROM AHL_VISIT_TASKS_B VT, AHL_VISITS_B VST

11771: AND cs.incident_id = p_cs_incident_id;
11772:
11773: CURSOR visit_task_csr(p_unit_effectivity_id IN NUMBER)IS
11774: SELECT VST.ORGANIZATION_ID,VT.visit_task_id
11775: FROM AHL_VISIT_TASKS_B VT, AHL_VISITS_B VST
11776: WHERE VT.TASK_TYPE_CODE IN ( 'SUMMARY' , 'UNASSOCIATED' )
11777: AND VST.VISIT_ID = VT.VISIT_ID
11778: AND VT.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;
11779: