DBA Data[Home] [Help]

APPS.CSTPPWMT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 124: FROM mtl_material_transactions mmt,

120: l_op_seq,
121: l_org_id,
122: l_subinv,
123: l_txn_action_id
124: FROM mtl_material_transactions mmt,
125: wip_entities we
126: WHERE mmt.transaction_id = p_txn_id
127: AND mmt.transaction_source_type_id = 5
128: AND mmt.transaction_action_id IN (1,27, 33, 34)

Line 501: UPDATE mtl_material_transactions mmt

497: -- ================================================================
498: -- FP 12.0-12.1.3 Bug 9280484 fix: Update periodic primary quantity
499: -- with converted UOM transaction quantity
500: -- ================================================================
501: UPDATE mtl_material_transactions mmt
502: SET mmt.periodic_primary_quantity = l_pri_qty * l_uom_conv_rate
503: WHERE mmt.transaction_id = p_txn_id;
504:
505: x_cost_method_hook := l_cost_method_hook;