DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on INL_SHIPLN_LANDED_COSTS_V

Line 2350: FROM inl_shipln_landed_costs_v islv

2346: pc_adjustment_num NUMBER,
2347: pc_ship_line_group_id NUMBER,
2348: pc_ship_line_num NUMBER) is
2349: SELECT islv.adjustment_num, islv.unit_landed_cost
2350: FROM inl_shipln_landed_costs_v islv
2351: WHERE islv.adjustment_num <= pc_adjustment_num
2352: AND islv.ship_header_id = p_ship_header_id
2353: AND islv.ship_line_group_id = pc_ship_line_group_id --Bug 7678900
2354: AND islv.ship_line_num = pc_ship_line_num

Line 2372: FROM inl_shipln_landed_costs_v islv,

2368: pc_ship_line_group_id NUMBER,
2369: pc_ship_line_num NUMBER
2370: ) IS
2371: SELECT ABS(islv.adjustment_num) adjustment_num, islv.unit_landed_cost -- SCM-051
2372: FROM inl_shipln_landed_costs_v islv,
2373: ( SELECT DISTINCT(adjustment_num) adjustment_num
2374: FROM inl_allocations
2375: WHERE allocation_id > p_max_allocation_id
2376: AND ship_header_id = p_ship_header_id