oracle tables in general ledger

Upload: ganeshan

Post on 04-Feb-2018

224 views

Category:

Documents


0 download

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