APPS.WSH_CONC_UTIL_PKG dependencies on OE_ORDER_LINES_ALL

Line 82: l_table_name := 'OE_ORDER_LINES_ALL';

78: END IF;
79:
80: l_script_name := 'wshupoe_01';
81: l_table_owner := 'ONT';
82: l_table_name := 'OE_ORDER_LINES_ALL';
83: l_worker_id := p_logical_worker_id;
84: l_num_workers := p_numworkers;
85: l_batch_size := p_batch_commit_size;
86: l_rows_processed := 0;

Line 140: update /*+ ROWID (oel) */ oe_order_lines_all oel

136: WSH_DEBUG_SV.log(l_module_name,'l_new_carrier_id',l_new_carrier_id);
137: END IF;
138:
139: -- Update Closed Order Lines, Interfaced to Shpg. and Not cancelled
140: update /*+ ROWID (oel) */ oe_order_lines_all oel
141: set oel.freight_carrier_code = l_new_freight_code
142: , oel.last_updated_by = -2950631
143: , oel.last_update_date = sysdate
144: where oel.open_flag = 'N'

Line 164: and exists (select /*+ ROWID (oel) */ 'x' from oe_order_lines_all oel -- Getting Only Shpg. Interfaced Lines

160: where oeh.open_flag = 'N'
161: and nvl(oeh.cancelled_flag, 'N') = 'N'
162: and oeh.freight_carrier_code = v_notupg.freight_code
163: and oeh.shipping_method_code = v_notupg.ship_method_code
164: and exists (select /*+ ROWID (oel) */ 'x' from oe_order_lines_all oel -- Getting Only Shpg. Interfaced Lines
165: where oel.header_id = oeh.header_id
166: and oel.rowid BETWEEN l_start_rowid AND l_end_rowid
167: and oel.open_flag = 'N'
168: and nvl(oel.cancelled_flag, 'N') = 'N'