oracle tables in general ledger
TRANSCRIPT
-
7/21/2019 Oracle Tables in General Ledger
1/1
select * from dba_tables where table_name like '%TRAN%' OR table_name like '%TRAN%' and owner='INV'
select * from mtl_parameters order by creation_date desc
select * from mtl_secondary_inventorieswhere secondary_inventory_name like 'AARU'
select * from mtl_item_locations order by creation_date
select * from MTL_INTERORG_SHIP_METHODS
select * from MTL_UOM_CONVERSIONS_A
select * from MTL_UOM_CLASS_CONVERSIONS
select * from mtl_material_transactions
select * from