APPS.INL_LANDEDCOST_PUB dependencies on INL_SHIPLN_LANDED_COSTS_V

Line 120: FROM inl_shipln_landed_costs_v olcv

116: x_estimated_item_price,
117: x_estimated_charges,
118: x_estimated_taxes,
119: x_estimated_unit_landed_cost
120: FROM inl_shipln_landed_costs_v olcv
121: WHERE olcv.ship_line_id = l_parent_ship_line_id
122: AND olcv.adjustment_num = 0;
123:
124: -- Standard Statement Level Procedure/Function Logging

Line 140: FROM inl_shipln_landed_costs_v olcv

136: INTO x_actual_item_price,
137: x_actual_charges,
138: x_actual_taxes,
139: x_actual_unit_landed_cost
140: FROM inl_shipln_landed_costs_v olcv
141: WHERE olcv.ship_line_id = (SELECT asl.ship_line_id
142: FROM inl_adj_ship_lines_v asl,
143: inl_ship_lines sl
144: WHERE asl.ship_header_id = sl.ship_header_id

Line 149: FROM INL_shipln_landed_costs_v olcv2

145: AND asl.ship_line_group_id = sl.ship_line_group_id -- BUG 7702229
146: AND asl.ship_line_num = sl.ship_line_num
147: AND sl.ship_line_id = l_parent_ship_line_id)
148: AND olcv.adjustment_num = (SELECT MAX(adjustment_num)
149: FROM INL_shipln_landed_costs_v olcv2
150: WHERE olcv2.ship_line_id = olcv.ship_line_id);
151:
152: END;
153: -- End of Api Body