APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_VISIT_TASKS_B

Line 174: ahl_visit_tasks_b vtsk,

170: SELECT
171: wo.workorder_id,
172: wo.status_code
173: FROM
174: ahl_visit_tasks_b vtsk,
175: ahl_workorders wo,
176: ahl_unit_effectivities_b ue
177: WHERE
178: ue.cs_incident_id = p_incident_id

Line 1907: FROM AHL_VISIT_TASKS_B A,

1903: -- Begin Changes by VSUNDARA for SR Integration
1904: CURSOR default_item_org_id(p_workorder_id IN NUMBER) IS
1905: SELECT A.inventory_item_id,
1906: A.item_organization_id
1907: FROM AHL_VISIT_TASKS_B A,
1908: AHL_WORKORDERS B
1909: WHERE A.visit_task_id = B.visit_task_id
1910: AND B.workorder_id = p_workorder_id;
1911:

Line 2121: ahl_visit_tasks_b vtsk

2117: SELECT
2118: awo.workorder_id
2119: FROM
2120: ahl_workorders awo,
2121: ahl_visit_tasks_b vtsk
2122: WHERE
2123: awo.visit_task_id = vtsk.visit_task_id
2124: AND awo.master_workorder_flag = 'Y'
2125: AND vtsk.task_type_code = 'SUMMARY'