APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_VISIT_TASKS_B

Line 2320: ahl_visit_tasks_b vts,

2316: FROM ahl_workorders wo,
2317: wip_discrete_jobs wdj,
2318: bom_departments bmd,
2319: ahl_visits_b vst,
2320: ahl_visit_tasks_b vts,
2321: inv_organization_info_v org
2322: WHERE wo.workorder_id = p_workorder_id
2323: AND wo.master_workorder_flag = 'N'
2324: AND wo.visit_task_id = vts.visit_task_id

Line 4071: ahl_visit_tasks_b vts,

4067: SELECT vst.organization_id, vts.inventory_item_id, arb.service_item_id
4068: INTO l_organization_id, l_inventory_item_id, l_service_item_id
4069: FROM ahl_workorders wo,
4070: ahl_visits_b vst,
4071: ahl_visit_tasks_b vts,
4072: ahl_routes_b arb,
4073: inv_organization_info_v org
4074: WHERE wo.workorder_id = p_x_osp_order_lines_tbl (i).workorder_id
4075: AND wo.route_id = arb.route_id(+)

Line 4440: ahl_visit_tasks_b vts,

4436: mtls.description service_item_description,
4437: mtls.primary_uom_code service_item_uom
4438: FROM ahl_workorders wo,
4439: ahl_visits_b vst,
4440: ahl_visit_tasks_b vts,
4441: csi_item_instances csii,
4442: mtl_system_items_kfv mtls,
4443: ahl_routes_b arb
4444: WHERE wo.workorder_id = c_workorder_id

Line 5083: ahl_visit_tasks_b vts,

5079: mtls.description service_item_description,
5080: mtls.primary_uom_code service_item_uom
5081: FROM ahl_workorders wo,
5082: ahl_visits_b vst,
5083: ahl_visit_tasks_b vts,
5084: csi_item_instances csii,
5085: mtl_system_items_kfv mtls,
5086: ahl_routes_b arb
5087: WHERE workorder_id = c_workorder_id

Line 6503: ahl_visit_tasks_b vts,

6499: ospl.attribute15
6500: FROM ahl_osp_order_lines ospl,
6501: ahl_workorders wo,
6502: ahl_visits_b vst,
6503: ahl_visit_tasks_b vts,
6504: csi_item_instances csiwo,
6505: csi_item_instances csiex,
6506: --po_lines_all pl,
6507: mtl_units_of_measure_tl mtluom