APPS.AHL_COMPLETIONS_PVT dependencies on AHL_VISITS_B

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

249: NVL(VTS.instance_id, VST.item_instance_id),
250: CSI.lot_number,
251: CSI.serial_number,
252: CSI.quantity
253: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,
254: AHL_UNIT_EFFECTIVITIES_B UE
255: WHERE VTS.unit_effectivity_id = UE.unit_effectivity_id
256: AND NVL(VTS.instance_id, VST.item_instance_id) = CSI.instance_id
257: AND VST.visit_id = VTS.visit_id

Line 265: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,

261: SELECT nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id ),
262: CSI.lot_number,
263: CSI.serial_number,
264: CSI.quantity
265: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,
266: (select instance_id from ahl_visit_tasks_b where visit_id = c_visit_id and instance_id IS NOT NULL AND rownum = 1) VTSINST
267: WHERE nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id )= CSI.INSTANCE_ID
268: AND VST.visit_id = c_visit_id;
269:

Line 4440: AHL_VISITS_B VS

4436: (
4437: SELECT PWO.wip_entity_id
4438: FROM AHL_WORKORDERS PWO,
4439: AHL_VISIT_TASKS_B VT,
4440: AHL_VISITS_B VS
4441: WHERE PWO.master_workorder_flag = 'Y'
4442: AND PWO.visit_task_id = VT.visit_task_id
4443: AND VS.VISIT_ID = VT.VISIT_ID
4444: AND VS.STATUS_CODE NOT IN ('CLOSED','CANCELLED')

Line 4505: AHL_VISITS_B VS

4501: (
4502: SELECT PWO.wip_entity_id
4503: FROM AHL_WORKORDERS PWO,
4504: AHL_VISIT_TASKS_B VT,
4505: AHL_VISITS_B VS
4506: WHERE PWO.master_workorder_flag = 'Y'
4507: AND PWO.visit_task_id = VT.visit_task_id
4508: AND VS.VISIT_ID = VT.VISIT_ID
4509: AND VS.STATUS_CODE NOT IN ('CLOSED','CANCELLED')

Line 7752: AHL_VISITS_B VST

7748: WO.plan_id wo_plan_id,
7749: WO.collection_id wo_collection_id
7750: FROM WIP_DISCRETE_JOBS WIP,
7751: AHL_WORKORDERS WO,
7752: AHL_VISITS_B VST
7753: WHERE WIP.wip_entity_id = WO.wip_entity_id
7754: AND WO.visit_task_id IS NULL
7755: AND WO.master_workorder_flag = 'Y'
7756: AND WO.visit_id = VST.visit_id

Line 10920: FROM AHL_VISIT_TASKS_B VT, AHL_VISITS_B VST

10916: AND cs.incident_id = p_cs_incident_id;
10917:
10918: CURSOR visit_task_csr(p_unit_effectivity_id IN NUMBER)IS
10919: SELECT VST.ORGANIZATION_ID,VT.visit_task_id
10920: FROM AHL_VISIT_TASKS_B VT, AHL_VISITS_B VST
10921: WHERE VT.TASK_TYPE_CODE IN ( 'SUMMARY' , 'UNASSOCIATED' )
10922: AND VST.VISIT_ID = VT.VISIT_ID
10923: AND VT.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;
10924: