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_PRD_MRSHL_PVT dependencies on AHL_SEARCH_WORKORDERS_V

Line 139: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

135: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
136: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
137: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
138: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
139: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
140: WHERE AWOS.visit_task_id = ASML.visit_task_id
141: and ASML.inventory_item_id = MSIK.inventory_item_id
142: and ASML.organization_id = MSIK.organization_id
143: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 208: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

204: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
205: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
206: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
207: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
208: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
209: WHERE AWOS.visit_task_id = ASML.visit_task_id
210: and ASML.inventory_item_id = MSIK.inventory_item_id
211: and ASML.organization_id = MSIK.organization_id
212: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 574: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML,

570: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
571: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
572: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
573: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
574: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML,
575: WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
576: WHERE AWOS.visit_task_id = ASML.visit_task_id
577: AND ASML.inventory_item_id = MSIK.inventory_item_id
578: AND ASML.organization_id = MSIK.organization_id

Line 640: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

636: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
637: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
638: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
639: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
640: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
641: WHERE AWOS.visit_task_id = ASML.visit_task_id
642: and ASML.inventory_item_id = MSIK.inventory_item_id
643: and ASML.organization_id = MSIK.organization_id
644: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 905: FROM AHL_SEARCH_WORKORDERS_V

901: ) RETURN NUMBER IS
902:
903: CURSOR comp_inst_wo_count_csr(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
904: SELECT COUNT(*)
905: FROM AHL_SEARCH_WORKORDERS_V
906: WHERE visit_id = p_visit_id
907: AND JOB_STATUS_CODE IN('4','5','7','12')
908: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
909: WO.visit_id = p_visit_id

Line 916: FROM AHL_SEARCH_WORKORDERS_V

912: AND VTS.instance_id = p_item_instance_id);
913:
914: CURSOR comp_cumm_inst_wo_count_csr(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
915: SELECT COUNT(*)
916: FROM AHL_SEARCH_WORKORDERS_V
917: WHERE visit_id = p_visit_id
918: AND JOB_STATUS_CODE IN('4','5','7','12')
919: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
920: WO.visit_id = p_visit_id

Line 944: FROM AHL_SEARCH_WORKORDERS_V

940:
941:
942: CURSOR total_inst_wo_count_csr(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
943: SELECT COUNT(*)
944: FROM AHL_SEARCH_WORKORDERS_V
945: WHERE visit_id = p_visit_id
946: AND JOB_STATUS_CODE <> '22'
947: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
948: WO.visit_id = p_visit_id

Line 955: FROM AHL_SEARCH_WORKORDERS_V

951: AND VTS.instance_id = p_item_instance_id);
952:
953: CURSOR total_cumm_inst_wo_count_csr(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
954: SELECT COUNT(*)
955: FROM AHL_SEARCH_WORKORDERS_V
956: WHERE visit_id = p_visit_id
957: AND JOB_STATUS_CODE <> '22'
958: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
959: WO.visit_id = p_visit_id

Line 982: FROM AHL_SEARCH_WORKORDERS_V

978: ));
979:
980: CURSOR comp_visit_wo_count_csr(p_visit_id NUMBER) IS
981: SELECT COUNT(*)
982: FROM AHL_SEARCH_WORKORDERS_V
983: WHERE visit_id = p_visit_id
984: AND JOB_STATUS_CODE IN('4','5','7','12');
985:
986:

Line 989: FROM AHL_SEARCH_WORKORDERS_V

985:
986:
987: CURSOR total_visit_wo_count_csr(p_visit_id NUMBER) IS
988: SELECT COUNT(*)
989: FROM AHL_SEARCH_WORKORDERS_V
990: WHERE visit_id = p_visit_id
991: AND JOB_STATUS_CODE <> '22';
992:
993: l_quantity NUMBER;

Line 1399: FROM AHL_SEARCH_WORKORDERS_V

1395: ) RETURN NUMBER IS
1396:
1397: CURSOR completed_time_csr(p_visit_id NUMBER) IS
1398: SELECT SUM(SCHEDULED_END_DATE - SCHEDULED_START_DATE)
1399: FROM AHL_SEARCH_WORKORDERS_V
1400: WHERE visit_id = p_visit_id
1401: AND JOB_STATUS_CODE IN('4','5','7','12')
1402: GROUP BY visit_id;
1403:

Line 1406: FROM AHL_SEARCH_WORKORDERS_V

1402: GROUP BY visit_id;
1403:
1404: CURSOR total_time_csr(p_visit_id NUMBER) IS
1405: SELECT SUM(SCHEDULED_END_DATE - SCHEDULED_START_DATE)
1406: FROM AHL_SEARCH_WORKORDERS_V
1407: WHERE visit_id = p_visit_id
1408: AND JOB_STATUS_CODE <> '22'
1409: GROUP BY visit_id;
1410: