APPS.AHL_COMPLEX_MX_PVT dependencies on AHL_VISIT_TASKS_B

Line 741: ahl_visit_tasks_b task

737:
738: SELECT 1
739: INTO l_RTS_visit
740: FROM ahl_visits_b vst,
741: ahl_visit_tasks_b task
742: WHERE vst.visit_id = task.visit_id
743: and vst.visit_id=p_visit_id
744: AND (vst.ITEM_INSTANCE_ID = p_instance_id
745: OR task.instance_id =p_instance_id)

Line 808: from ahl_visit_tasks_b vts, ahl_workorders wo, wip_discrete_jobs wdj

804:
805: CURSOR C_Visit_End_Date(p_visit_id NUMBER)
806: IS
807: select max(nvl(wdj.scheduled_completion_date,vts.end_date_time))
808: from ahl_visit_tasks_b vts, ahl_workorders wo, wip_discrete_jobs wdj
809: where
810: vts.visit_id = p_visit_id
811: and vts.return_to_supply_flag = 'Y'
812: and vts.status_code <> 'DELETED'

Line 867: AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS

863: CURSOR GET_VISIT_COUNT_CSR (ITEM_ID IN NUMBER, ORG_ID IN NUMBER, START_DATE IN DATE, END_DATE IN DATE, c_visit_state IN VARCHAR2) IS
864: SELECT COUNT(*) FROM (
865: SELECT distinct vst.visit_id, vts.instance_id
866: FROM
867: AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS
868: WHERE
869: vst.visit_id = vts.visit_id
870: AND ( (c_visit_state = 'PLANNED' and VST.STATUS_CODE IN ('DRAFT','PLANNING')) OR
871: (c_visit_state = 'SCHEDULED' and VST.STATUS_CODE IN ('RELEASED','PARTIALLY RELEASED')))

Line 887: and exists(select 1 from ahl_visit_tasks_b vts where vts.visit_id = vst.visit_id and vts.return_to_supply_flag = 'Y' and vts.inventory_item_id <> vst.inventory_item_id and

883: ( (c_visit_state = 'PLANNED' and VST.STATUS_CODE IN ('DRAFT','PLANNING')) OR
884: (c_visit_state = 'SCHEDULED' and VST.STATUS_CODE IN ('RELEASED','PARTIALLY RELEASED')))
885: AND VST.INVENTORY_ITEM_ID = ITEM_ID
886: AND VST.ORGANIZATION_ID = ORG_ID
887: and exists(select 1 from ahl_visit_tasks_b vts where vts.visit_id = vst.visit_id and vts.return_to_supply_flag = 'Y' and vts.inventory_item_id <> vst.inventory_item_id and
888: vts.status_code <> 'DELETED' and not exists (select '1' from ahl_workorders where visit_task_id = vts.visit_task_id and status_code in (12,22,4,5,7)) and rownum < 2)
889: AND TRUNC(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) BETWEEN TRUNC(START_DATE) AND TRUNC(END_DATE)
890: );
891:

Line 927: AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS

923: CURSOR GET_VISIT_COUNT_CSR (ITEM_ID IN NUMBER, ORG_ID IN NUMBER, REQ_DATE IN DATE) IS
924: SELECT COUNT(*) FROM (
925: SELECT distinct vst.visit_id, vts.instance_id
926: FROM
927: AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS
928: WHERE
929: vst.visit_id = vts.visit_id
930: AND vst.status_code IN ('DRAFT' , 'PLANNING', 'PARTIALLY RELEASED', 'RELEASED')
931: AND VTS.INVENTORY_ITEM_ID = ITEM_ID

Line 945: and exists(select 1 from ahl_visit_tasks_b vts where vts.visit_id = vst.visit_id and vts.return_to_supply_flag = 'Y' and vts.inventory_item_id <> vst.inventory_item_id and

941: WHERE
942: vst.status_code IN ('DRAFT' , 'PLANNING', 'PARTIALLY RELEASED', 'RELEASED')
943: AND VST.INVENTORY_ITEM_ID = ITEM_ID
944: AND VST.ORGANIZATION_ID = ORG_ID
945: and exists(select 1 from ahl_visit_tasks_b vts where vts.visit_id = vst.visit_id and vts.return_to_supply_flag = 'Y' and vts.inventory_item_id <> vst.inventory_item_id and
946: vts.status_code <> 'DELETED' and not exists (select '1' from ahl_workorders where visit_task_id = vts.visit_task_id and status_code in (12,22,4,5,7)) and rownum < 2)
947: and LAST_DAY(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) = REQ_DATE
948: );
949:

Line 1011: FROM ahl_visits_b vst, ahl_visit_tasks_b vts

1007:
1008: --Cursor to get Visit Id from Locator attributes
1009: CURSOR Get_Visit_From_Prj_Task(c_project_id IN NUMBER, c_project_task_id IN NUMBER) IS
1010: SELECT vst.visit_Id
1011: FROM ahl_visits_b vst, ahl_visit_tasks_b vts
1012: WHERE
1013: vst.project_id = c_project_id
1014: and vst.visit_id = vts.visit_id
1015: and vts.project_task_id = c_project_task_id

Line 1021: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VTS, AHL_VISITS_B VST

1017:
1018: --Cursor to get Visit Id from Job
1019: CURSOR Get_Visit_From_Job(c_wip_entity_id NUMBER) IS
1020: SELECT VST.Visit_Id
1021: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VTS, AHL_VISITS_B VST
1022: WHERE
1023: WO.wip_entity_id = c_wip_entity_id
1024: AND VTS.visit_task_id = WO.visit_task_id
1025: AND VST.visit_id = VTS.visit_id;