APPS.CSTPSMCW dependencies on MTL_MATERIAL_TRANSACTIONS

Line 182: FROM mtl_material_transactions mmt,

178: Hence this query is used to utilize existing index range
179: scans */
180: SELECT count(*)
181: INTO l_txn_mmt_flag
182: FROM mtl_material_transactions mmt,
183: wsm_split_merge_transactions wsmt
184: WHERE
185: (transaction_source_id in
186: (select wip_entity_id

Line 464: FROM MTL_MATERIAL_TRANSACTIONS

460: l_transaction_type_id,
461: l_txn_action_id,
462: l_txn_source_type_id,
463: l_wsmt_transaction_id
464: FROM MTL_MATERIAL_TRANSACTIONS
465: WHERE transaction_id = p_transaction_id;
466:
467: IF (l_wsmt_transaction_id = -1) THEN
468: RAISE NO_WSMT_TRANSACTION;