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_DISP_UTIL_PVT dependencies on AHL_VISITS_B

Line 1869: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_WORKORDERS wo, AHL_VISITS_B VI

1865: /*
1866: SELECT disp.inventory_item_id, disp.item_number, disp.workorder_id,
1867: vi.organization_id, disp.path_position_id, disp.quantity, disp.uom,
1868: disp.wo_operation_id
1869: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_WORKORDERS wo, AHL_VISITS_B VI
1870: --the organization_id in ahl_prd_dispostions_b is not necessary to be the same as the job org,
1871: --especially when the disposition is for a non empty position(instance''s last_vld_org_id), but
1872: --here we need the job organization.
1873: WHERE disp.workorder_id = wo.workorder_id

Line 1888: ahl_visits_b vi

1884: disp.wo_operation_id
1885: from ahl_prd_dispositions_vl disp,
1886: mtl_system_items_kfv mtl,
1887: ahl_workorders wo,
1888: ahl_visits_b vi
1889: where disp.workorder_id = wo.workorder_id
1890: and wo.visit_id = vi.visit_id
1891: and disp.disposition_id = p_disp_id
1892: AND disp.inventory_item_id = mtl.inventory_item_id(+)

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

2420: IS
2421:
2422: CURSOR get_instance_id_csr IS
2423: SELECT VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID
2424: FROM AHL_WORKORDERS WO, AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS
2425: WHERE WO.WORKORDER_ID = p_workorder_id AND
2426: VST.VISIT_ID = WO.VISIT_ID AND
2427: VTS.VISIT_TASK_ID = WO.VISIT_TASK_ID;
2428: