APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_VISIT_TASKS_B

Line 2341: ahl_visit_tasks_b vts,

2337: FROM ahl_workorders wo,
2338: wip_discrete_jobs wdj,
2339: bom_departments bmd,
2340: ahl_visits_b vst,
2341: ahl_visit_tasks_b vts,
2342: inv_organization_info_v org
2343: WHERE wo.workorder_id = p_workorder_id
2344: AND wo.master_workorder_flag = 'N'
2345: AND wo.visit_task_id = vts.visit_task_id

Line 4413: ahl_visit_tasks_b vts,

4409: SELECT vst.organization_id, vts.inventory_item_id, arb.service_item_id
4410: INTO l_organization_id, l_inventory_item_id, l_service_item_id
4411: FROM ahl_workorders wo,
4412: ahl_visits_b vst,
4413: ahl_visit_tasks_b vts,
4414: ahl_routes_b arb,
4415: inv_organization_info_v org
4416: WHERE wo.workorder_id = p_x_osp_order_lines_tbl (i).workorder_id
4417: AND wo.route_id = arb.route_id(+)

Line 4782: ahl_visit_tasks_b vts,

4778: mtls.description service_item_description,
4779: mtls.primary_uom_code service_item_uom
4780: FROM ahl_workorders wo,
4781: ahl_visits_b vst,
4782: ahl_visit_tasks_b vts,
4783: csi_item_instances csii,
4784: mtl_system_items_kfv mtls,
4785: ahl_routes_b arb
4786: WHERE wo.workorder_id = c_workorder_id

Line 5433: ahl_visit_tasks_b vts,

5429: mtls.description service_item_description,
5430: mtls.primary_uom_code service_item_uom
5431: FROM ahl_workorders wo,
5432: ahl_visits_b vst,
5433: ahl_visit_tasks_b vts,
5434: csi_item_instances csii,
5435: mtl_system_items_kfv mtls,
5436: ahl_routes_b arb
5437: WHERE workorder_id = c_workorder_id

Line 6952: ahl_visit_tasks_b vts,

6948: ospl.attribute15
6949: FROM ahl_osp_order_lines ospl,
6950: ahl_workorders wo,
6951: ahl_visits_b vst,
6952: ahl_visit_tasks_b vts,
6953: csi_item_instances csiwo,
6954: csi_item_instances csiex,
6955: --po_lines_all pl,
6956: mtl_units_of_measure_tl mtluom