DBA Data[Home] [Help]

APPS.MTL_QP_PRICE dependencies on MTL_MATERIAL_TRANSACTIONS

Line 176: from mtl_material_transactions

172: IF (l_transaction_uom IS NULL) THEN
173: BEGIN
174: select transaction_uom
175: into l_transaction_uom
176: from mtl_material_transactions
177: where transaction_id = p_transaction_id;
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: IF (l_debug = 1) THEN

Line 233: FROM mtl_material_transactions

229: , transaction_action_id
230: INTO l_line_id
231: , l_transaction_source_type_id
232: , l_transaction_action_id
233: FROM mtl_material_transactions
234: WHERE transaction_id = p_transaction_id;
235:
236: l_inventory_item_id := p_inventory_item_id;
237: ELSIF(p_transaction_id IS NOT NULL

Line 247: FROM mtl_material_transactions

243: INTO l_line_id
244: , l_inventory_item_id
245: , l_transaction_source_type_id
246: , l_transaction_action_id
247: FROM mtl_material_transactions
248: WHERE transaction_id = p_transaction_id;
249: ELSIF(p_transaction_id IS NULL
250: AND p_order_line_id IS NOT NULL) THEN
251: l_inventory_item_id := p_inventory_item_id;