APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_VISIT_TASKS_B

Line 672: --FROM AHL_VISIT_TASKS_B TSK, AHL_MR_HEADERS_B MRH

668:
669: CURSOR get_mr_count_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
670: -- Keeping old query for reference
671: --SELECT COUNT(MRH.MR_HEADER_ID) MR_HEADER_ID_COUNT
672: --FROM AHL_VISIT_TASKS_B TSK, AHL_MR_HEADERS_B MRH
673: --WHERE TSK.instance_id = c_instance_id
674: --AND TSK.visit_id = c_visit_id
675: --AND TSK.mr_id = MRH.mr_header_id
676: --AND NVL(TSK.status_code,'X') <> 'DELETED'

Line 681: FROM AHL_VISIT_TASKS_B TSK

677: --AND TSK.TASK_TYPE_CODE = 'SUMMARY';
678:
679: SELECT COUNT(1) MR_COUNT
680: FROM (SELECT DISTINCT unit_effectivity_id
681: FROM AHL_VISIT_TASKS_B TSK
682: WHERE TSK.instance_id = c_instance_id
683: AND TSK.visit_id = c_visit_id
684: AND NVL(TSK.status_code,'X') <> 'DELETED'
685: AND TSK.TASK_TYPE_CODE = 'SUMMARY'

Line 693: FROM AHL_VISIT_TASKS_B TSK

689: );
690:
691: CURSOR get_task_count_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
692: SELECT COUNT(TSK.VISIT_TASK_ID) TASK_ID_COUNT
693: FROM AHL_VISIT_TASKS_B TSK
694: WHERE TSK.instance_id = c_instance_id
695: AND TSK.visit_id = c_visit_id
696: AND NVL(TSK.status_code,'X') <> 'DELETED'
697: AND NVL(TSK.TASK_TYPE_CODE , 'X') <> 'STAGE';

Line 1033: FROM AHL_VISIT_TASKS_B TSK, AHL_MR_HEADERS_B MRH

1029: AND IRC.lookup_type (+) = 'AHL_INSTANCE_ROUTING';
1030:
1031: CURSOR get_mr_count_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
1032: SELECT COUNT(MRH.MR_HEADER_ID) MR_HEADER_ID_COUNT
1033: FROM AHL_VISIT_TASKS_B TSK, AHL_MR_HEADERS_B MRH
1034: WHERE TSK.instance_id = c_instance_id
1035: AND TSK.visit_id = c_visit_id
1036: AND TSK.mr_id = MRH.mr_header_id
1037: AND NVL(TSK.status_code,'X') <> 'DELETED'

Line 1042: FROM AHL_VISIT_TASKS_B TSK

1038: AND TSK.TASK_TYPE_CODE = 'SUMMARY';
1039:
1040: CURSOR get_task_count_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
1041: SELECT COUNT(TSK.VISIT_TASK_ID) TASK_ID_COUNT
1042: FROM AHL_VISIT_TASKS_B TSK
1043: WHERE TSK.instance_id = c_instance_id
1044: AND TSK.visit_id = c_visit_id
1045: AND NVL(TSK.status_code,'X') <> 'DELETED'
1046: AND NVL(TSK.TASK_TYPE_CODE , 'X') <> 'STAGE';

Line 1438: AHL_VISITS_B VST, AHL_VISIT_TASKS_B TSK, AHL_WORKORDERS WO

1434: l_notes VARCHAR2(2000);
1435: CURSOR Get_Visit_Instance_Workorders(p_visit_id IN NUMBER, p_instance_id IN NUMBER) IS
1436: SELECT WO.WORKORDER_ID WORKORDER_ID
1437: FROM
1438: AHL_VISITS_B VST, AHL_VISIT_TASKS_B TSK, AHL_WORKORDERS WO
1439: WHERE
1440: VST.VISIT_ID = p_visit_id
1441: AND VST.VISIT_ID = TSK.VISIT_ID
1442: AND TSK.INSTANCE_ID = p_instance_id

Line 1572: FROM ahl_visits_b vst, ahl_visit_tasks_b vts

1568:
1569: --Cursor to Get Visit Number From Project Task ID
1570: Cursor Get_Visit_From_Prj_Task(c_project_id IN NUMBER, c_project_task_id IN NUMBER) IS
1571: SELECT vst.visit_number
1572: FROM ahl_visits_b vst, ahl_visit_tasks_b vts
1573: WHERE
1574: vst.project_id = c_project_id
1575: and vst.visit_id = vts.visit_id
1576: and vts.project_task_id = c_project_task_id

Line 1582: FROM ahl_visits_b vst, ahl_visit_tasks_b vts, ahl_workorders wo,ahl_osp_orders_b osph, ahl_osp_order_lines ospl

1578:
1579: --Cursor to Get Visit Number and OSP number From Workorder.
1580: Cursor Get_Visit_And_OSP_From_Wip_Job(c_wip_entity_id IN NUMBER) IS
1581: SELECT vst.visit_number,osph.osp_order_number
1582: FROM ahl_visits_b vst, ahl_visit_tasks_b vts, ahl_workorders wo,ahl_osp_orders_b osph, ahl_osp_order_lines ospl
1583: WHERE
1584: wo.wip_entity_id = c_wip_entity_id
1585: and wo.visit_task_id IS NOT NULL
1586: and wo.visit_task_id = vts.visit_task_id