APPS.MTL_QP_PRICE dependencies on OE_ORDER_LINES_ALL

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

183:
184: IF l_doc_type = 'OMSO' THEN
185: SELECT pnd.line_id
186: INTO l_line_id
187: FROM ic_tran_pnd pnd, ic_whse_mst whs, oe_order_lines_all oel
188: WHERE pnd.trans_id = p_transaction_id
189: AND oel.line_id = pnd.line_id
190: AND pnd.orgn_code = whs.orgn_code
191: AND pnd.whse_code = whs.whse_code;

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

191: AND pnd.whse_code = whs.whse_code;
192: ELSIF l_doc_type = 'PORC' THEN
193: SELECT oel.line_id
194: INTO l_line_id
195: FROM ic_tran_pnd pnd, ic_whse_mst whs, oe_order_lines_all oel, rcv_transactions rct
196: WHERE pnd.trans_id = p_transaction_id
197: AND rct.transaction_id = pnd.line_id
198: AND rct.oe_order_line_id = oel.line_id
199: AND pnd.orgn_code = whs.orgn_code

Line 253: FROM oe_order_lines_all

249: END IF;
250:
251: SELECT header_id
252: INTO l_header_id
253: FROM oe_order_lines_all
254: WHERE line_id = l_line_id;
255:
256: IF (l_debug = 1) THEN
257: print_debug('MTL_QP_PRICE.get_transfer_price: Selecting Primary UOM...');

Line 1799: FROM oe_order_lines_all

1795: , inv_ic_order_pub.g_line.commitment_id
1796: , inv_ic_order_pub.g_line.order_source_id -- aksingh
1797: , inv_ic_order_pub.g_line.upgraded_flag
1798: , inv_ic_order_pub.g_line.lock_control
1799: FROM oe_order_lines_all
1800: WHERE line_id = p_line_id;
1801:
1802: inv_ic_order_pub.g_line.calculate_price_flag := 'Y';
1803: