eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_LANDEDCOST_PUB dependencies on INL_SHIP_LINES

Line 49: FROM inl_ship_lines sl

45:
46: /*
47: CURSOR c_landed_cost IS
48: SELECT sl.ship_line_id
49: FROM inl_ship_lines sl
50: WHERE sl.ship_header_id = p_ship_header_id
51: AND sl.adjustment_num = 0
52: ORDER BY sl.ship_line_id;
53: l_landed_cost c_landed_cost%ROWTYPE;

Line 66: inl_ship_lines sl,

62: lc.component_type,
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

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)

Line 375: FROM inl_ship_lines sl --access to synon

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
377: AND sl.ship_line_group_id = sl0.ship_line_group_id
378: AND sl.ship_line_num = sl0.ship_line_num
379: AND sl.adjustment_num <= lc.adjustment_num