DBA Data[Home] [Help]

APPS.MTL_QP_PRICE dependencies on RCV_TRANSACTIONS

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 2435: FROM rcv_transactions rcv, po_lines_all pol, mtl_units_of_measure um

2431: SELECT rcv.po_line_id
2432: , rcv.po_header_id
2433: INTO l_line_id
2434: , l_header_id
2435: FROM rcv_transactions rcv, po_lines_all pol, mtl_units_of_measure um
2436: WHERE rcv.transaction_id = p_transaction_id
2437: AND rcv.po_line_id = pol.po_line_id
2438: AND rcv.unit_of_measure = um.unit_of_measure;
2439: