APPS.AHL_PRD_UTIL_PKG dependencies on AHL_VISIT_TASKS_B

Line 244: ahl_visit_tasks_b vtk,

240: SELECT
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

Line 557: AHL_VISIT_TASKS_B TSK

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
561: QPT.TRANSACTION_NUMBER IN (9999,2001) AND

Line 662: AHL_VISIT_TASKS_B VTS

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
666: WORKORDER_ID = p_workorder_id;