APPS.CSE_GL_INTERFACE_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 46: FROM mtl_material_transactions mmt

42: ,decode(mmt.transaction_action_id ,
43: '2' , mmt.transfer_transaction_id ,
44: '3' , mmt.transfer_transaction_id ,
45: '28', mmt.transfer_transaction_id , mmt.transaction_id ) trf_txn_id
46: FROM mtl_material_transactions mmt
47: ,mtl_system_items msi
48: WHERE mmt.transaction_id = p_mtl_txn_id
49: AND mmt.inventory_item_id = msi.inventory_item_id
50: AND mmt.organization_id = msi.organization_id ;

Line 287: mtl_material_transactions mmt

283: IS
284: SELECT distinct caiv.ledger_id , mmt.transaction_id
285: FROM cst_acct_info_v caiv,
286: mtl_transaction_accounts mta,
287: mtl_material_transactions mmt
288: WHERE mta.transaction_id = c_mtl_transaction_id
289: AND mta.organization_id = caiv.organization_id
290: AND mmt.transaction_id = c_mtl_transaction_id
291: AND mmt.transaction_action_id <> 3

Line 296: mtl_material_transactions mmt

292: UNION
293: SELECT distinct caiv.ledger_id , mmt.transaction_id
294: FROM cst_acct_info_v caiv,
295: mtl_transaction_accounts mta ,
296: mtl_material_transactions mmt
297: WHERE mta.transaction_id in ( c_mtl_transaction_id , c_trf_txn_id )
298: AND mta.organization_id = caiv.organization_id
299: AND mmt.transaction_id in ( c_mtl_transaction_id , c_trf_txn_id )
300: AND mmt.transaction_action_id = 3 ;

Line 467: FROM mtl_material_transactions mmt , mtl_system_items msi

463: l_depreciable ,
464: l_trf_txn_id ,
465: l_mmt_txn_action_id ,
466: l_mmt_txn_id
467: FROM mtl_material_transactions mmt , mtl_system_items msi
468: WHERE mmt.transaction_id = csi_pending_txn_rec.inv_material_transaction_id
469: AND mmt.inventory_item_id = msi.inventory_item_id
470: AND mmt.organization_id = msi.organization_id ;
471: