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.
base tables
-
- Posts: 110
- Joined: Mon Oct 27, 2008 9:50 am
- Location: India
-
- Posts: 110
- Joined: Mon Oct 27, 2008 9:50 am
- Location: India
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
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
Who is online
Users browsing this forum: No registered users and 2 guests