APPS.INL_LANDEDCOST_PUB dependencies on INL_SHIP_LINES_ALL

Line 367: inl_ship_lines_all sl0, --access to table (performance)

363: SUM(lc.allocated_amt) ALC,
364: SUM(lc.estimated_allocated_amt) ELC,
365: lc.adjustment_num
366: FROM
367: inl_ship_lines_all sl0, --access to table (performance)
368: inl_det_landed_costs_v lc
369: WHERE sl0.ship_line_id = p_ship_line_id
370: AND lc.ship_header_id = sl0.ship_header_id
371: AND lc.adjustment_num = (SELECT MAX(alloc.adjustment_num)