Oracle Applications

Oracle for Beginners

PL/SQL Scripts

This section will contains a list of pl/sql scripts that you may find handy in extracting info from the database.

Note the following:
a. The scripts were written and tested on an R12 environment with multiple operating units.
b. Some values are hard-coded to suit our purpose, you will of course need to review this.
c. You may have to modify the scripts to suit your purpose.
d. The scripts have not been fine-tuned. You can always suggest ways to better them.

Hope they help.


1. Function to fetch username
2. Function to fetch employee related information
3. Function to get Organization related information
4. Function to get Item info
5. Function to get Item Category Info

Shameem Bauccha
28 June 2010


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s