APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_VISITS_B

Line 704: FROM AHL_VISITS_B VST

700: SELECT CASE COUNT(visit_id)
701: WHEN 0 THEN 'N'
702: ELSE 'Y'
703: END visits_count
704: FROM AHL_VISITS_B VST
705: WHERE VST.item_instance_id = c_instance_id
706: AND VST.visit_id <> c_visit_id;
707:
708: -- 16 Nov 2011, for now, removing check for scheduled_quantity,

Line 1053: FROM AHL_VISITS_B VST

1049: SELECT CASE COUNT(visit_id)
1050: WHEN 0 THEN 'F'
1051: ELSE 'T'
1052: END visits_count
1053: FROM AHL_VISITS_B VST
1054: WHERE VST.item_instance_id = c_instance_id
1055: AND VST.visit_id <> c_visit_id;
1056:
1057: l_curr_row NUMBER;

Line 1176: FROM AHL_VISITS_B

1172:
1173: -- cursor to validate the given visit id
1174: CURSOR validate_visit_csr (c_visit_id NUMBER) IS
1175: SELECT 'X'
1176: FROM AHL_VISITS_B
1177: WHERE visit_id = c_visit_id;
1178:
1179: BEGIN
1180:

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 1566: FROM AHL_VISITS_B

1562:
1563: --Cursor to Get Visit Attributes
1564: CURSOR Get_Visit_Attributes(c_visit_id IN NUMBER) IS
1565: SELECT item_instance_id, visit_number
1566: FROM AHL_VISITS_B
1567: WHERE visit_id = c_visit_id;
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

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