eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_COMPLEX_MX_PVT dependencies on AHL_WORKORDERS

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 813: 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))

809: where
810: vts.visit_id = p_visit_id
811: and vts.return_to_supply_flag = 'Y'
812: and vts.status_code <> 'DELETED'
813: 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))
814: /*If workorder exists then its status should not be Closed, Deleted, Complete, Complete No-charge, Cancelled */
815: and vts.visit_task_id = wo.visit_task_id (+)
816: and wo.wip_entity_id = wdj.wip_entity_id (+);
817:

Line 876: 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))

872: AND VTS.INVENTORY_ITEM_ID = ITEM_ID
873: AND VST.ORGANIZATION_ID = ORG_ID
874: and vts.return_to_supply_flag = 'Y'
875: and vts.status_code <> 'DELETED'
876: 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))
877: AND TRUNC(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) BETWEEN TRUNC(START_DATE) AND TRUNC(END_DATE)
878: union
879: SELECT distinct vst.visit_id, vst.item_instance_id
880: FROM

Line 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)

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:
892: l_visit_cnt NUMBER := 0;

Line 935: 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))

931: AND VTS.INVENTORY_ITEM_ID = ITEM_ID
932: AND VST.ORGANIZATION_ID = ORG_ID
933: and vts.return_to_supply_flag = 'Y'
934: and vts.status_code <> 'DELETED'
935: 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))
936: and LAST_DAY(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) = REQ_DATE
937: union
938: SELECT distinct vst.visit_id, vst.item_instance_id
939: FROM

Line 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)

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:
950: l_visit_cnt NUMBER := 0;

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;