APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_VISIT_TASKS_B

Line 1328: AHL_VISIT_TASKS_B VTS

1324: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
1325: FROM
1326: AHL_WORKORDERS AWOS,
1327: AHL_VISITS_B VST,
1328: AHL_VISIT_TASKS_B VTS
1329: WHERE
1330: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
1331: VST.VISIT_ID = VTS.VISIT_ID AND
1332: WORKORDER_ID = p_workorder_id;

Line 4129: SELECT 'x' from ahl_visit_tasks_b VST, ahl_workorders WO where

4125: l_inactive_item_found BOOLEAN;
4126: l_junk VARCHAR2(1);
4127:
4128: CURSOR is_open_job_instance_csr(p_instance_id IN NUMBER) IS
4129: SELECT 'x' from ahl_visit_tasks_b VST, ahl_workorders WO where
4130: VST.instance_id = p_instance_id
4131: AND VST.visit_task_id = WO.visit_task_id
4132: AND VST.visit_id = WO.visit_id
4133: AND WO.status_code NOT IN ('4','5','7','12','17','22');

Line 4721: AHL_VISIT_TASKS_B VTS

4717: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
4718: FROM
4719: AHL_WORKORDERS AWOS,
4720: AHL_VISITS_B VST,
4721: AHL_VISIT_TASKS_B VTS
4722: WHERE
4723: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
4724: VST.VISIT_ID = VTS.VISIT_ID AND
4725: WORKORDER_ID = p_workorder_id;