DBA Data[Home] [Help]

APPS.INL_LANDEDCOST_PUB dependencies on INL_ALLOCATIONS

Line 70: FROM inl_allocations alloc

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)
72: AND sl.ship_line_id = lc.ship_line_id
73: GROUP BY NVL(sl.parent_ship_line_id,sl.ship_line_id),
74: lc.organization_id,

Line 372: FROM inl_allocations alloc

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
373: WHERE alloc.ship_header_id = sl0.ship_header_id)
374: AND lc.ship_line_id = (SELECT MAX(sl.ship_line_id)
375: FROM inl_ship_lines sl --access to synon
376: WHERE sl.ship_header_id = sl0.ship_header_id