APPS.MTL_QP_PRICE dependencies on OE_ORDER_LINES_ALL

Line 207: FROM ic_tran_pnd pnd, ic_whse_mst whs, oe_order_lines_all oel

203:
204: IF l_doc_type = 'OMSO' THEN
205: SELECT pnd.line_id
206: INTO l_line_id
207: FROM ic_tran_pnd pnd, ic_whse_mst whs, oe_order_lines_all oel
208: WHERE pnd.trans_id = p_transaction_id
209: AND oel.line_id = pnd.line_id
210: AND pnd.orgn_code = whs.orgn_code
211: AND pnd.whse_code = whs.whse_code;

Line 215: FROM ic_tran_pnd pnd, ic_whse_mst whs, oe_order_lines_all oel, rcv_transactions rct

211: AND pnd.whse_code = whs.whse_code;
212: ELSIF l_doc_type = 'PORC' THEN
213: SELECT oel.line_id
214: INTO l_line_id
215: FROM ic_tran_pnd pnd, ic_whse_mst whs, oe_order_lines_all oel, rcv_transactions rct
216: WHERE pnd.trans_id = p_transaction_id
217: AND rct.transaction_id = pnd.line_id
218: AND rct.oe_order_line_id = oel.line_id
219: AND pnd.orgn_code = whs.orgn_code

Line 273: FROM oe_order_lines_all

269: END IF;
270:
271: SELECT header_id
272: INTO l_header_id
273: FROM oe_order_lines_all
274: WHERE line_id = l_line_id;
275:
276: IF (l_debug = 1) THEN
277: print_debug('MTL_QP_PRICE.get_transfer_price: Selecting Primary UOM...');

Line 1841: FROM oe_order_lines_all

1837: , inv_ic_order_pub.g_line.commitment_id
1838: , inv_ic_order_pub.g_line.order_source_id -- aksingh
1839: , inv_ic_order_pub.g_line.upgraded_flag
1840: , inv_ic_order_pub.g_line.lock_control
1841: FROM oe_order_lines_all
1842: WHERE line_id = p_line_id;
1843:
1844: inv_ic_order_pub.g_line.calculate_price_flag := 'Y';
1845: