DBA Data[Home] [Help]

APPS.MTL_QP_PRICE dependencies on RCV_TRANSACTIONS

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

2523: SELECT rcv.po_line_id
2524: , rcv.po_header_id
2525: INTO l_line_id
2526: , l_header_id
2527: FROM rcv_transactions rcv, po_lines_all pol, mtl_units_of_measure um
2528: WHERE rcv.transaction_id = p_transaction_id
2529: AND rcv.po_line_id = pol.po_line_id
2530: AND rcv.unit_of_measure = um.unit_of_measure;
2531: