APPS.WSH_FC_INTERFACE_PKG dependencies on OE_ORDER_LINES_ALL

Line 78: oe_order_lines_all ol

74: dd.volume_uom_code
75: FROM wsh_delivery_details dd,
76: wsh_delivery_assignments_v da,
77: wsh_new_deliveries nd,
78: oe_order_lines_all ol
79: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
80: da.delivery_id = nd.delivery_id AND
81: da.delivery_id IS NOT NULL AND
82: ol.line_id = dd.source_line_id AND

Line 2397: FROM oe_order_headers_all h, oe_order_lines_all l, wsh_delivery_details wdd

2393: h.conversion_rate_date,
2394: h.conversion_rate,
2395: l.line_id,
2396: l.header_id
2397: FROM oe_order_headers_all h, oe_order_lines_all l, wsh_delivery_details wdd
2398: WHERE wdd.delivery_detail_id = c_delivery_detail_id AND
2399: wdd.source_line_id = l.line_id AND
2400: wdd.source_code = 'OE' and
2401: l.header_id = h.header_id;

Line 3086: oe_order_lines_all ol,

3082: wft.freight_cost_type_code
3083: , wfc.conversion_type_code, wfc.conversion_rate
3084: FROM wsh_delivery_assignments_v wda,
3085: wsh_delivery_details wdd,
3086: oe_order_lines_all ol,
3087: wsh_freight_costs wfc,
3088: wsh_freight_cost_types wft,
3089: wsh_delivery_legs wdl,
3090: wsh_new_deliveries wnd,

Line 3735: FROM wsh_delivery_details wsh, oe_order_lines_all l

3731: END IF;
3732: --
3733: SELECT wsh.source_line_id
3734: INTO l_line_id
3735: FROM wsh_delivery_details wsh, oe_order_lines_all l
3736: WHERE wsh.delivery_detail_id = p_delivery_detail_id AND
3737: wsh.source_line_id = l.line_id and
3738: wsh.source_code = 'OE';
3739: