DBA Data[Home] [Help]

APPS.WIP_PICKING_PUB dependencies on MTL_MATERIAL_TXN_ALLOCATIONS

Line 171: insert into mtl_material_txn_allocations(

167: and operation_seq_num = p_operation_seq_num
168: and inventory_item_id = p_inventory_item_id
169: and wip_supply_type = 1; -- a push component
170:
171: insert into mtl_material_txn_allocations(
172: transaction_id,
173: repetitive_schedule_id,
174: organization_id,
175: last_update_date,

Line 207: update mtl_material_txn_allocations

203: and operation_seq_num = p_operation_seq_num
204: and inventory_item_id = p_inventory_item_id
205: and wip_supply_type = 1; -- a push component
206:
207: update mtl_material_txn_allocations
208: set primary_quantity = primary_quantity - ROUND(l_rmnQty, 6),
209: transaction_quantity = transaction_quantity - ROUND(l_rmnQty, 6)
210: where repetitive_schedule_id = l_repSchedID
211: and transaction_id = p_transaction_id;