base tables

[harikumarc1981@rediffmail]

can any one tell me the available base tables in GL, AP and AR 11i

and where the sob is stored in GL, where the period status stored in AP and AR.


Thanks in advance.

[oteixeira]

Hello.

The GL_SETS_OF_BOOKS table stores the sets of books. The periods for are stored in the GL_PERIOD_STATUSES yable.

Hope this helps.
Octavio

[harikumarc1981@rediffmail]

[quote]Hello.

The GL_SETS_OF_BOOKS table stores the sets of books. The periods for are stored in the GL_PERIOD_STATUSES yable.

Hope this helps.
Octavio

<i><div align="right">Originally posted by oteixeira

[tgs100]

The list will run into several pages.

Go to Metalink --> Knowledge Tab -> Knowledge Browser Tab --> Applications Electronic Technical Reference Manuals (eTRM)

This will open a new window. Keep the cursor on the required version and the click 'DBA Data'.

Enter Object names like GL%, AP%, AR%, RA%, etc and then query to find out the tables.

Alternatively run the below query in toad (or any other tool).

select * from dba_objects
where object_name like 'GL%'
and object_type = 'TABLE'
and temporary <> 'Y'
order by object_name

Cheers,
Saravanan