DBA Data[Home] [Help]

APPS.MRP_MANAGER_PK dependencies on SO_LINES_ALL

Line 2377: FROM so_lines_all sl,

2373: IF g_om_installed = 'OE' THEN
2374:
2375: SELECT NVL(sl.end_item_unit_number, slp.end_item_unit_number)
2376: INTO v_unit_number
2377: FROM so_lines_all sl,
2378: so_lines_all slp,
2379: mtl_demand_omoe dem
2380: WHERE slp.line_id(+) = nvl(sl.parent_line_id,sl.line_id)
2381: AND to_number(dem.demand_source_line) = sl.line_id(+)

Line 2378: so_lines_all slp,

2374:
2375: SELECT NVL(sl.end_item_unit_number, slp.end_item_unit_number)
2376: INTO v_unit_number
2377: FROM so_lines_all sl,
2378: so_lines_all slp,
2379: mtl_demand_omoe dem
2380: WHERE slp.line_id(+) = nvl(sl.parent_line_id,sl.line_id)
2381: AND to_number(dem.demand_source_line) = sl.line_id(+)
2382: AND dem.demand_source_type in (2,8)