Page 1 of 1
base tables
Posted: Mon Sep 21, 2009 10:47 am
by 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.
Posted: Mon Sep 21, 2009 12:10 pm
by 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
Posted: Tue Sep 22, 2009 12:17 am
by 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
Posted: Tue Sep 22, 2009 12:28 am
by 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