Thursday, 24 May 2012

general ledger(gl)important tables in oracle apps


GENERAL LEDGER TABLES

--CURRENCY

Select * from   FND_CURRENCIES

---PERIOD TYPES

Select * from   GL_PERIOD_TYPES

--CALENDER

Select * from   GL_PERIOD_SETS

Select * from   GL_PERIODS

--CHART OF ACCOUNTS

Select * from   FND_ID_FLEX_STRUCTURES

Select * from   FND_ID_FLEX_SEGMENTS

--LEDGERS

Select * from   GL_LEDGERS

--JOURNAL SOURCES

Select * from   GL_JE_SOURCES

--JOURNAL CATEGIRIES

Select * from   GL_JE_CATEGORIES

--JOURNALS

Select * from   GL_JE_HEADERS

Select * from   GL_JE_LINES


No comments:

Post a Comment