63: SUM(lc.allocated_amt) ALC,
64: SUM(lc.estimated_allocated_amt) ELC
65: FROM
66: inl_ship_lines sl,
67: inl_det_landed_costs_v lc
68: WHERE lc.ship_header_id = p_ship_header_id
69: AND lc.adjustment_num = (SELECT MAX(alloc.adjustment_num)
70: FROM inl_allocations alloc
71: WHERE alloc.ship_header_id = p_ship_header_id)
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)
372: FROM inl_allocations alloc