APPS.AHL_PRD_UTIL_PKG dependencies on AHL_VISIT_TASKS_B

Line 257: ahl_visit_tasks_b vtk,

253: SELECT
254: vst.item_instance_id,
255: vtk.instance_id
256: FROM
257: ahl_visit_tasks_b vtk,
258: ahl_visits_b vst,
259: ahl_workorders wo
260: WHERE
261: wo.workorder_id = p_workorder_id AND

Line 571: AHL_VISIT_TASKS_B TSK

567: QP.ORGANIZATION_ID = (SELECT
568: ORGANIZATION_ID
569: FROM
570: AHL_VISITS_B VST,
571: AHL_VISIT_TASKS_B TSK
572: WHERE VST.VISIT_ID = TSK.VISIT_ID AND
573: TSK.UNIT_EFFECTIVITY_ID = p_ue_id AND
574: ROWNUM < 2) AND
575: QPT.TRANSACTION_NUMBER = 2001 AND

Line 682: AHL_VISIT_TASKS_B VTS

678: NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID)
679: FROM
680: AHL_WORKORDERS AWOS,
681: AHL_VISITS_B VST,
682: AHL_VISIT_TASKS_B VTS
683: WHERE
684: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
685: VST.VISIT_ID = VTS.VISIT_ID AND
686: WORKORDER_ID = p_workorder_id;