Thursday 24 May 2012

aol important tables in oracle apps


-- FLEX FIELDS (DFF)

Select * from   FND_DESCR_FLEX_CONTEXTS

Select * from   FND_DESCR_FLEX_COL_USAGE_TL

-- FLEX FIELDS (KFF)

Select * from   FND_ID_FLEX_STRUCTURES

Select * from   FND_ID_FLEX_SEGMENTS

--VALUE SETS

Select * from   FND_FLEX_VALUES

--REGISTRATION  & EXECUTABLES

Select * from   FND_EXECUTABLES

--CONCURRENT PROGRAM

Select * from   FND_CONCURRENT_PROGRAMS

--RESPONSIBILITY

Select * from   FND_RESPONSIBILITY_TL

--USERS

Select * from   FND_USER

--REQUESTS

Select * from   FND_CONCURRENT_REQUESTS

--REQUEST SETS

Select * from   FND_REQUEST_SETS

--MULTI ORG TABLES

--BUSINESS GROUPS

Select * from   PER_BUSINESS_GROUPS

--SET OF BOOKS

Select * from   GL_SETS_OF_BOOKS

--LEGAL ENTITIES

Select * from   HR_LEGAL_ENTITIES

--INVENTORY

Select * from   ORG_ORGANIZATION_DEFINITIONS

--OPERATING UNIT

Select * from   HR_OPERATING_UNITS

No comments:

Post a Comment