DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 2321: inv_organization_info_v org

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
2325: AND vst.visit_id = vts.visit_id

Line 4073: inv_organization_info_v org

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(+)
4076: AND wo.master_workorder_flag = 'N'
4077: AND wo.visit_id = vst.visit_id