DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 2342: inv_organization_info_v org

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

Line 4415: inv_organization_info_v org

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