APPS.AHL_PRD_UTIL_PKG dependencies on AHL_VISITS_B

Line 245: ahl_visits_b vst,

241: vst.item_instance_id,
242: vtk.instance_id
243: FROM
244: ahl_visit_tasks_b vtk,
245: ahl_visits_b vst,
246: ahl_workorders wo
247: WHERE
248: wo.workorder_id = p_workorder_id AND
249: vtk.visit_task_id = wo.visit_task_id AND

Line 556: AHL_VISITS_B VST,

552: QPT.PLAN_TRANSACTION_ID = QPCT.PLAN_TRANSACTION_ID AND
553: QP.ORGANIZATION_ID = (SELECT
554: ORGANIZATION_ID
555: FROM
556: AHL_VISITS_B VST,
557: AHL_VISIT_TASKS_B TSK
558: WHERE VST.VISIT_ID = TSK.VISIT_ID AND
559: TSK.UNIT_EFFECTIVITY_ID = p_ue_id AND
560: ROWNUM < 2) AND

Line 661: AHL_VISITS_B VST,

657: SELECT AWOS.STATUS_CODE,
658: NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID)
659: FROM
660: AHL_WORKORDERS AWOS,
661: AHL_VISITS_B VST,
662: AHL_VISIT_TASKS_B VTS
663: WHERE
664: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
665: VST.VISIT_ID = VTS.VISIT_ID AND