APPS.INV_CONSUMPTION_TXN_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 20: --| to mtl_material_transactions |

16: --| |
17: --| HISTORY |
18: --| 07/22/03 David Herring Created procedure |
19: --| 10/27/03 David Herring Added update |
20: --| to mtl_material_transactions |
21: --+========================================================================
22:
23: --===================
24: -- GLOBALS

Line 44: -- : mtl_material_transactions is updated with

40: -- p_transaction_quantity IN quantity retroactively priced
41: --
42: -- COMMENT : This procedure will insert records
43: -- : into mtl_consumption_transactions
44: -- : mtl_material_transactions is updated with
45: -- : the owning org of the blanket.
46: --=========================================================================
47: PROCEDURE price_update_insert
48: ( p_transaction_id IN NUMBER

Line 98: -- populate the owning org in mtl_material_transactions

94: , 'Y'
95: , p_po_distribution_id
96: );
97:
98: -- populate the owning org in mtl_material_transactions
99: -- with the vendor site id
100: -- The is needed for the isp page to pick up the
101: -- price update transactions bug 3209997
102:

Line 105: FROM mtl_material_transactions mmt

101: -- price update transactions bug 3209997
102:
103: SELECT DISTINCT mmt.transaction_source_id
104: INTO l_blanket
105: FROM mtl_material_transactions mmt
106: WHERE mmt.transaction_id = p_transaction_id;
107:
108: SELECT DISTINCT poh.vendor_site_id
109: INTO l_owning_org_id

Line 113: UPDATE mtl_material_transactions mmt

109: INTO l_owning_org_id
110: FROM po_headers_all poh
111: WHERE poh.po_header_id = l_blanket;
112:
113: UPDATE mtl_material_transactions mmt
114: SET mmt.owning_organization_id = l_owning_org_id
115: ,mmt.owning_tp_type = 1
116: WHERE mmt.transaction_id = p_transaction_id;
117: