APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_WORKORDERS

Line 55: FROM ahl_workorders_v

51: --begin performance tuning
52: /* SELECT job_number,
53: organization_id,
54: job_status_code
55: FROM ahl_workorders_v
56: WHERE workorder_id = p_workorder_id;
57: */
58: SELECT 'x'
59: FROM ahl_workorders

Line 59: FROM ahl_workorders

55: FROM ahl_workorders_v
56: WHERE workorder_id = p_workorder_id;
57: */
58: SELECT 'x'
59: FROM ahl_workorders
60: WHERE workorder_id = p_workorder_id;
61: l_job_attrs get_job_attrs%ROWTYPE;
62: --end performance tuning
63:

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 1887: ahl_workorders wo,

1883: disp.uom,
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

Line 1899: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_WORKORDERS_V wo

1895: /*
1896: SELECT disp.inventory_item_id, disp.item_number, disp.workorder_id,
1897: wo.organization_id, disp.path_position_id, disp.quantity, disp.uom,
1898: disp.wo_operation_id
1899: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_WORKORDERS_V wo
1900: --the organization_id in ahl_prd_dispostions_b is not necessary to be the same as the job org,
1901: --especially when the disposition is for a non empty position(instance's last_vld_org_id), but
1902: --here we need the job organization.
1903: WHERE disp.workorder_id = wo.workorder_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: