Learn Oracle Application || By ShrikantGarud

Oracle Apps OverView

2009-08-17T05:17:00.000-07:00

Introduction: The Oracle Applications is an ERP, which was developed by the
Oracle Corp and was used by the several companies to utilize several resources
contained with them.

Oracle Applications is designed for the Financial and Manufacturing clients. The
categories in the modules are given below.
Financial Modules: Account Payables, Account Receivables, General Ledger and Fixed
Assets.
Manufacturing Modules: Purchasing, Inventory, Bill Of Materials, Work in Progress and
Order Management.
In HRMS we maintain all the details of the employee as well as the organization details.
Module: It is a collection of forms and reports which are related to particular business
process.
Purchase order module has the forms and reports which are related to the purchasing
business process. It contains nearly 50,000 tables they are accessed by only purchase
order module.

Clover Infotech

ERP: Enterprise Resource Planning || AIM (APPLICATION IMPLEMENTATION METHODOLOGY)

2009-08-17T05:13:00.000-07:00

ERP: Enterprise Resource Planning
Here Resource means 5 m’s
1. Money
2. Man power
3. Machinery
4. Material and
5. Management
ERP Purpose: Planning for proper utilization of resources for a business organization .
ERP as a Product : all objects(i.e. forms, reports )and all other programs are
developed and throwly tested and those will be provided with these ERP.
Methodology : the process used to implement ERP Product for a business Organization.

AIM (APPLICATION IMPLEMENTATION METHODOLOGY):
Methodology for Oracle Apps is AIM(Applications Implementation Methodology)
Phases in Aim Methodology:
1. Definition Phase
2. Operational Analysis Phase
3. Solution Design Phase
4. Build Phase
5. Transition Phase
6. Production Phase
1. Definition Phase: Here the functional consultants prepare the sample structure
(Blue Print) for the real business by gathering the information.
2. Operational Analysis phase: In this the functional consultant prepare BR100
(Business Requirement).
3. Solution Design Phase: here the functional consultant will prepare MD50 by using
BR100. MD50 is the functional document.
4. Build Phase: here the technical consultant converts MD50 to MD70. MD70 is the
technical document. Then the technical consultant prepare the final object and go
with testing, i.e. Unit Testing.
5. Transition Phase: here SIT(System Integration Testing) and UAT(User
Acceptance Testing) is done. Functional consultant does SIT. After this the
functional consultant will train the user in oracle apps product and user does UAT.
If it is satisfied by the user, it is sign off and product will be given to the user.
6. Production phase: loading the project in the client place. Where the server of
oracle apps in the client place.
Clover Infotech

Oracle Application Modules

2008-01-27T05:18:00.000-08:00

ABM - Activity Based Management
AD - Applications DBA
AHL - Oracle Advanced Service Online
AK - Oracle Common Modules-AK
ALR - Oracle Alert
AMF - Oracle Fulfillment Services
AMS - Oracle Marketing
AP - Oracle Payables
AR - Oracle Receivables
AS - Oracle Sales
ASG - Oracle CRM Gateway for Mobile Services
ASL - Oracle Mobile Field Sales Laptop
ASO - Oracle Order Capture
AST - TeleSales
AX - Global Accounting Engine
AZ - Application Implementation
BEN - Oracle Advanced Benefits
BIC - Customer Intelligence
BIL - Sales Intelligence
BIM - Marketing Intelligence
BIS - Oracle Applications BIS
BIX - Call Center Intelligence
BNE - Oracle Web ADI
BOM - Oracle Bills of Material
BSC - Balanced Scorecard
CCT - Oracle Call Center and Telephony
CE - Oracle Cash Management
CHV - Oracle Supplier Scheduling
CLN - Supply Chain Trading Connector for RosettaNet
CN - Oracle Sales Compensation
CS - Oracle Service
CSC - Customer Care
CSD - Depot Repair
CSE - Oracle Enterprise Install Base
CSF - Field Service
CSI - Install Base
CSM - Oracle Field Service Palm
CSP - Oracle Spares Management
CSR - Oracle Scheduler
CSS - Support
CUG - Oracle Citizen Interaction Center
CUN - Oracle Network Logistics NATS
CZ - Oracle Configurator
EAM - Oracle Enterprise Asset Management
EC - Oracle e-Commerce Gateway
ECX - Oracle XML Gateway
EDR - Oracle E Records
ENG - Oracle Engineering
FII - Financials Intelligence
FLM - Oracle Flow Manufacturing
FND - Application Object Library
FTE - Oracle Transportation Hub
FV - Oracle Federal Financials
GHR - Oracle Federal HR
GL - Oracle General Ledger
GMA - Oracle Process Manufacturing Systems
GMD - Oracle Process Manufacturing Product Development
GME - Oracle Process Manufacturing Process Execution
GMF - Oracle Process Manufacturing Financials
GMI - Oracle Process Manufacturing Inventory
GML - Oracle Process Manufacturing Logistics
GMP - Oracle Process Manufacturing Process Planning
GMS - Oracle Grants Accounting
GR - Oracle Process Regulatory Mgmt
HRI - Human Resources Intelligence
HXC - Oracle Time and Labor
HXT - Oracle Time and Labor Rules
IBA - iMarketing
IBC - Oracle iContent
IBE - iStore
IBU - iSupport
IBY - iPayment
ICX - Oracle Self-Service Web Applications
IEB - Oracle Interaction Blending
IEC - Oracle Campaign Plus
IEM - Oracle eMail Center
IEO - Call Center Technology
IES - Scripting
IEU - Oracle Universal Work Queue
IEX - Oracle Collections
IGC - Commitment Administration
IGF - Student Systems Fin Aid
IGI - Oracle International Public Sector Financials
IGS - Oracle Student Sytems
IGW - Oracle Grants Proposal
INV - Oracle Inventory
IPD - Oracle Product Development Exchange
ISC - Supply Chain Intelligence
JTF - CRM Foundation
JTM - Oracle CRM Mobile Foundation
JTS - Oracle CRM Self Service Administration
MRP - Oracle Master Scheduling/MRP
MSC - Oracle Advanced Supply Chain Planning
MSD - Oracle Demand Planning
OFA - Oracle Assets
OKC - Oracle Contracts Core
OKI - Oracle Contracts Intelligence
OKL - Oracle Lease Management
OKR - Oracle Contracts for Rights
OKS - Oracle Contracts Service Module
ONT - Oracle Order Management
OPI - Operations Intelligence
OTA - Oracle Training Administration
OZF - Funds & Budgets
PA - Oracle Projects
PAY - Oracle Payroll
PER - Oracle Human Resources
PJM - Oracle Project Manufacturing
PN - Oracle Property Manager
PO - Oracle Purchasing
POA - Purchasing Intelligence
POM - Oracle Exchange
PON - Oracle Sourcing
POS - Internet Supplier Portal
PQH - Oracle Public Sector HR
PSA - Public Sector Applications
PSB - Oracle Public Sector Budgeting
PSP - Oracle Labor Distribution
PV - Partner Relationship Management
QA - Oracle Quality
QP - Oracle Pricing
QRM - Oracle Risk Management
RG - Application Report Generator
RLM - Oracle Release Management
VEA - Oracle Automotive
WIP - Oracle Work in Process
WMS - Oracle Warehouse Management System
WSH - Oracle Shipping
WSM - Shop Floor Management
XDP - Oracle Provisioning
XNC - Oracle Sales for Communications
XNI - Oracle Install Base Intelligence
XNP - Oracle Number Portability
XNS - Oracle Service for Communications
XTR - Oracle Treasury

Interface

2008-01-21T22:24:00.000-08:00

Interfaces are extensively used to integrate external system into oracle application
It is used at the time of data migration

- data migration from external system into oracle application
- data migration from oracle application to external system

It can also be used at the time of fresh installation of oracle application

TYPES OF INTERFACES

there are 2 main types of interfaces

1. INBOUND INTERFACE
these are used for transferring data from external system(legacy system) into oracle
application

2. OUTBOUND INTERFACE
these are used for transferring data from oracle application to external system.

There are 2 Distinct types of interfaces

1. OPEN INTERFACE
In this the logic is been provided by the oracle itself

OPEN INTERFACE LOGIC

Data from the external file is transfered to the database table called as Interface table for that specific module.
Then Validation are performed an that available data.
Any error found are then transfered to the error table.
Then the validated record are then transferred to the application tables.

2. CUSTOM INTERFACE
In this the logic has to be developed by the implementer.

For Interface we need A staging table

What is the need of a staging table or temporary table in between flat file and standard interface table while transferring data from flat file to interface table?

1.Once we have data in the interface table we are simply running the standard program and it automatically send data to the base table so in this time we can't do any validations in in between the interface table and base table that'y we use staging table to validate the data before putting into the interface table.Finally the staging tables are used to load the data from legacy systems what ever the client provided .after that we write a validation program to send proper valid data to interface table.

2.The basic need for a staging table is to serve as another step before loading into the interface tables after which we run oracle standard APIs to load them into the bas tables sometimes even after running APIS we may need some concurrent programmes to be run so for that data to be reflected across the base tables. The staging area serves for updates like date formats (MM-DD-RRRR) and other such critical data format changes neede before we load into interface tables and then running APIS in them . As explained above a bad file if formed while loading if some data format is not in consonance with the API or base file and hence the whole API/validation fails, In some case though it creates a corrupt log file which also indicates the failure of the validation.

3.These staging tables are used to hold temporary data i.e data with in the temporary table will be automatically get deleted when we issue commit or when we close oracle session that depends on how we create table

eg: create global temporary table eg1(name varchar2(20),num number(10)) on commit delete rows;

this will delete the rows on temporary table when we issue a commit at sql prompt.

moreover these staging tables are used to do some primray validations before inserting data into actual tables.

so we need data to be erased after inserting into acutal tables. so we go for staging tables.

we can use normal tables also as staging table but we need to truncate table for each insert. thats why we go for temporary tables.

What are Interface table in AP

1). AP_INTERFACE_CONTROLS.
2). AP_INTERFACE_REJECTIONS
3). AP_INVOICE_INTERFACE
4). AP_INVOICE_LINES_INTERFACE.

AR INTERFACE TABLE:

1). AR_PAYMENTS_INTERFACE_ALL
2). AR_TAX_INTERFACE
3). HZ_PARTY_INTERFACE
4). HZ_PARTY_INTERFACE_ERRORS
5). RA_CUSTOMERS_INTERFACE_ALL
6). RA_INTERFACE_DISTRIBUTIONS_ALL
7). RA_INTERFACE_ERRORS_ALL
8). RA_INTERFACE_LINES_ALL
9). RA_INTERFACE_SALESCREDITS_ALL

GL INTERFACE TABLE:

1). GL_BUDGET_INTERFACE
2). GL_DAILY_RATES_INTERFACE
3). GL_IEA_INTERFACE
4). GL_interface
5). GL_INTERFACE_CONTROL
6). GL_INTERFACE_HISTORY

EXAMPLE FOR INTERFACE TRY

ITEM UPLOAD INTERFACE

STEP1.

GO TO APPS AND CREATE STAGING TABLE

create table SG_ITEM_STAGE
(segment1 varchar2(25),
DESCRIPTION VARCHAR2(25),
TEMPLATE_NAME VARCHAR2(25),
MATERIAL_COST NUMBER,
PROCESS_FLAG NUMBER,
ENABLED_FLAG VARCHAR2(1),
TRANSACTION_TYPE VARCHAR2(25),
ORGANIZATION_CODE VARCHAR2(25))

STEP 2.

Create a SG_ITEM_DATA.dat File

SGTest Item51, SGTest Item11,Finished Good,100,
SGTest Item52, SGTest Item12, Finished Good, 500,
SGTest Item53, SGTest item13, Finished Good, 600,
SGtest Item54, SGTest Item14, Finished Good,300,

STEP 3.

Create a shri.ctl file (control file which contains the logic of uploading data from flat file to the stagging table)

LOAD DATA
INFILE '/apps/visappl/cust/11.5.0/bin/SG_ITEM_DATA.dat'
INTO TABLE SG_ITEM_STAGE
APPEND
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(SEGMENT1,
DESCRIPTION,
TEMPLATE_NAME,
MATERIAL_COST,
PROCESS_FLAG CONSTANT 1,
ENABLED_FLAG CONSTANT 'Y',
TRANSACTION_TYPE CONSTANT 'Create',
ORGANIZATION_CODE CONSTANT "V1")

STEP 4.

UP LOAD CTL AND DAT FILE
FTP
TELNET

STEP 5.

CHECK DATA IN STAGING TABLE
select count(*) from
SG_STAGE_TABLE;

STEP 6.

CREATE PRE_INTERFACE TABLE AS INTERFACE TABLE

create table SG_ITEM_PRE_INTERFACE AS
select * from mtl_system_items_interface ;

STEP 7.

RUN THIS PROCEDURE TO UPLOAD DATA FROM STAGING TABLE TO PREINTERFACE
TABLE

STAGING TABLE---------------------------->PRE-INTERFACE TABLE

CREATE OR REPLACE Procedure SG_ITEM_PRE_INTERFACE Is
m_Segment1 varchar2(40);
m_Description varchar2(40);
M_TEMPLATE_NAME VARCHAR2(40);
M_MATERIAL_COST NUMBER;
M_PROCESS_FLAG NUMBER;
m_Transaction_Type varchar2(10);
m_Organization_CODE VARCHAR2(10);
M_ENABLED_FLAG VARCHAR2(1);
m_set_process_id number;
Cursor C1 is Select * from SG_STAGE_TABLE;
Begin
For rec in C1
loop
m_Segment1 := REC.SEGMENT1;
m_Description := REC.DESCRIPTION;
M_TEMPLATE_NAME := REC.TEMPLATE_NAME;
IF M_MATERIAL_COST>500 THEN
M_MaTERIAL_COST:=500;
END IF;
IF M_PROCESS_FLAG IN(2,3,4,5) THEN
M_PROCESS_FLAG:=1;
ELSE
M_PROCESS_FLAG:=REC.PROCESS_FLAG;
END IF;
M_MATERIAL_COST := abs(REC.MATERIAL_COST);
M_PROCESS_FLAG := REC.PROCESS_FLAG;
m_Transaction_Type := REC.TRANSACTION_TYPE;
m_Organization_CODE:= REC.ORGANIZATION_CODE;
M_ENABLED_FLAG := REC.ENABLED_FLAG;
m_set_process_id := 25101974;
Insert into
SG1_ITEM_PRE_INTERFACE
(
SEGMENT1,
DESCRIPTION,
TEMPLATE_NAME,
MATERIAL_COST,
PROCESS_FLAG,
TRANSACTION_TYPE,
ORGANIZATION_CODE,
ENABLED_FLAG,
SET_PROCESS_ID
)
values
(
m_Segment1,
m_Description,
M_TEMPLATE_NAME,
M_MATERIAL_COST,
M_PROCESS_FLAG,
m_Transaction_Type,
m_Organization_CODE,
M_ENABLED_FLAG,
M_SET_PROCESS_ID
);
End Loop;
End SG_ITEM_PRE_INTERFACE;
/

Compile & execute this procedure. After this check data is uploaded in the pre-interface
table.
EXEC SG_ITEM_PRE_INTERFACE;
SELECT COUNT(*) FROM SG1_ITEM_PRE_INTERFACE;

STEP 7.

TRANSFER DATA FROM
PRE-INTERFACE TABLE-------------------------->INTERFACE TABLE

CREATE OR REPLACE Procedure SG2_ITEM_INTERFACE Is
m_Segment1 varchar2(40);
m_Description varchar2(40);
M_TEMPLATE_NAME VARCHAR2(40);
M_MATERIAL_COST NUMBER;
M_PROCESS_FLAG NUMBER;
m_Transaction_Type varchar2(10);
m_Organization_CODE VARCHAR2(10);
M_ENABLED_FLAG VARCHAR2(1);
m_set_process_id number;
Cursor C1 is Select * from SG1_ITEM_PRE_INTERFACE;
Begin
For rec in C1
loop
m_Segment1 := REC.SEGMENT1;
m_Description := REC.DESCRIPTION;
M_TEMPLATE_NAME := REC.TEMPLATE_NAME;
M_MATERIAL_COST := REC.MATERIAL_COST;
M_PROCESS_FLAG := REC.PROCESS_FLAG;
m_Transaction_Type := REC.TRANSACTION_TYPE;
m_Organization_CODE:= REC.ORGANIZATION_CODE;
M_ENABLED_FLAG := REC.ENABLED_FLAG;
m_set_process_id := 25101974;
Insert into MTL_SYSTEM_ITEMS_INTERFACE
(
SEGMENT1,
DESCRIPTION,
TEMPLATE_NAME,
MATERIAL_COST,
PROCESS_FLAG,
TRANSACTION_TYPE,
ORGANIZATION_CODE,
ENABLED_FLAG,
SET_PROCESS_ID
)
values
(
m_Segment1,
m_Description,
M_TEMPLATE_NAME,
M_MATERIAL_COST,
M_PROCESS_FLAG,
m_Transaction_Type,
m_Organization_CODE,
M_ENABLED_FLAG,
M_SET_PROCESS_ID
);
End Loop;
End SG2_ITEM_INTERFACE;

EXEC SG_ITEM_PRE_INTERFACE;

SELECT COUNT(*) FROM SG1_ITEM_PRE_INTERFACE;

STEP 8.
Check the data
SELECT COUNT(*) FROM MTL_SYSTEM_ITEMS_INTERFACE;

STEP 9.
Log on to apps(mfg/welcome).
select ==>Inventory.
In Navigator ==> Items==>Import Items ==> Select master organisation

Overview of Coding Standards

2008-01-10T22:53:00.000-08:00

Importance of these Standards

The coding standards described in this manual, together with the user
interface standards described in the Oracle Applications User Interface
Standards for Forms–Based Products, are used by Oracle Corporation
developers to build Oracle Applications. If you want to build custom
application code that integrates with and has the same look and feel as
Oracle Applications, you must follow these standards. If you do not
follow these standards exactly as they are presented, you may not
achieve an acceptable result.
This manual makes no attempt to analyze the consequences of
deviating from the standards in particular cases. The libraries and
procedures that are packaged with Oracle Applications all assume
adherence to these standards. In fact, since the behavior of Oracle
Forms, the Oracle Applications standard libraries, and the standards
are so tightly linked, a deviation from standards that appears to be
minor may in fact have far–reaching and unpredictable results.
Therefore, we recommend that when you develop custom application
code, you follow the standards exactly as they are described in this
manual and in the Oracle Applications User Interface Standards for
Forms–Based Products.

Coding Principles

Oracle Applications coding standards are guided by the following
principles:
• Code must be readable to be maintained
• Tools such as Oracle Forms and PL/SQL are used whenever
possible (avoid complex user exits using other coding languages)
• Fast performance over the World Wide Web (the web) is critical
• Platform–specific code should be avoided except where
absolutely necessary
• Reusable objects should be employed wherever possible

Coding With Handlers

Oracle Applications uses groups of packaged procedures, called
handlers, to organize PL/SQL code in forms so that it is easier to
develop, maintain, and debug.
In Oracle Forms, code is placed in triggers, which execute the code
when that trigger event occurs. Implementing complex logic may
require scattering its code across multiple triggers. Because code in
triggers is not located in one place, it cannot be written or reviewed
comprehensively, making development, maintenance, and debugging
more difficult. To determine what code and events affect a particular
item, a developer must scan many triggers throughout the form. Code
that affects multiple items can be extremely difficult to trace.
To centralize the code so it is easier to develop, maintain, and debug,
place the code in packaged procedures and call those procedures from
the triggers. Pass the name of the trigger as an argument for the
procedure to process. This scheme allows the code for a single
business rule to be associated with multiple trigger points, but to reside
in a single location.
There are different kinds of procedures for the different kinds of code
you write: item handlers, event handlers, table handlers, and business
rules. Code resides in these procedures; do not put any code in the
triggers other than calls to the procedures.
Handlers may reside in program units in the form itself, in form
libraries, or in stored packages in the database as appropriate.

Item Handlers

An item handler is a PL/SQL procedure that encapsulates all of the
code that acts upon an item. Most of the validation, defaulting, and
behavior logic for an item is typically in an item handler.

Event Handlers

An event handler is a PL/SQL procedure that encapsulates all of the
code that acts upon an event. Usually event handlers exist to satisfy
requirements of either Oracle Forms or the Oracle Applications User
Interface Standards for Forms–Based Products, as opposed to particular
business requirements for a product.

Table Handlers

A table handler encapsulates all of the code that manages interactions
between a block and its base table. When an updatable block is based
on a view, you must supply procedures to manage the insert, update,
lock and delete. Referential integrity checks often require additional
procedures. Table handlers may reside on either the forms server or
the database, depending on their size and the amount of interaction
with the database, but they typically reside in the database.

Business Rules

A business rule describes complex data behavior. For example, one
business rule is: ”A discount cannot be greater than 10% if the current
credit rating of the buyer is less than ’Good’.” Another business rule is:
”A Need–By Date is required if a requisition is made for an inventory
item.”
A business rule procedure encapsulates all of the code to implement
one business rule when the business rule is complex or affects more
than one item or event. The business rule procedure is then called by
the item or event handlers that are involved in the business rule. If the
business rule is simple and affects only one item or event, implement
the business rule directly in the item or event handler.

Libraries

Libraries contain reusable client–side code. They support these form
coding standards by allowing the same code to be used by all forms to
enforce specific validation, navigation and cosmetic behaviors and
appearances.
Libraries allow code to be written once and used by multiple forms.
Additionally, because the executables attach at runtime, they facilitate
development and maintenance without being invasive to a form.
Every form requires several standard triggers and procedures to link
the form with a library. Many of these triggers and procedures have a
default behavior that a developer overrides for specific items or blocks.

Application–Specific Libraries

Each application is strongly encouraged to create its own libraries.
Typically, each application creates a central library that governs
behaviors of objects found throughout many of its forms. Additional
libraries should be created for each major transaction form to facilitate
the following:
• Multiple developers can work on a single module, with some
developers coding the actual form and others coding the
supporting libraries.
• Shipment and installation of patches to code is vastly simplified
if the correction is isolated in a library. Libraries do not require
any porting or translation.
All libraries should reside in the $AU_TOP/resource directory (or its
equivalent).

Attaching Libraries

Sometimes library attachments can be lost on platforms that have
case–sensitive filenames. By Oracle Applications standards, library
names must be in all uppercase letters (except for the file extension).
However, for forms developed using Microsoft Windows, the library
filename may be attached using mixed case letters, making the
attachment invalid on case–sensitive platforms such as Unix. If you
attach a library to a form in the Oracle Forms Developer on Microsoft
Windows, you should avoid using the Browse mechanism to locate the
file. Instead, type in just the filename, in uppercase only, with no file
extension (for example, CUSTOM). Oracle Forms will then preserve
the attachment exactly as you typed it. Note that your attachment
should never include a directory path; your FORMS60_PATH should
include the directory that holds all your libraries.

Performance

Performance is a critical issue in any application. Applications must
avoid overloading the network that connects desktop client, server, and
database server computers, since often it is network performance that
most influences users’ perceptions of application performance.
Oracle Applications are designed to minimize network traffic on all
tiers. For example, they try to limit network round trips to one per
user–distinguishable event by employing the following coding
standards:

• Use database stored procedures when extensive SQL is required
• Code all non–SQL logic on the client side where possible
• Cache data on the client side where practical
• Base blocks on views that denormalize foreign key information
where practical

Coding for Web Compatibility

Following Oracle Applications standards carefully will help ensure that
your forms can be deployed on the Web.
You should avoid using the following features in your forms, as they
are not applicable in this architecture:
• ActiveX, VBX, OCX, OLE, DDE (Microsoft Windows–specific
features that would not be available for a browser running on a
Macintosh, for example, and cannot be displayed to users from
within the browser)
• Timers other than one–millisecond timers (one–millisecond
timers are treated as timers that fire immediately)
• WHEN–MOUSE–MOVE, WHEN–MOUSE–ENTER/LEAVE and
WHEN–WINDOW–ACTIVATED/DEACTIVATED triggers
• Open File dialog box
– It would open a file on the applications server, rather than
on the client machine (where the browser is) as a user might
expect
• Combo boxes
– Our standards do not use combo boxes anyhow
• Text_IO and HOST built–in routines
– These would take place on the applications server, rather
than on the client machine (where the browser is) as a user
might expect

The Standard Development Environment

These coding standards assume that you are developing code in the
appropriate Oracle Applications development environment, which
includes compatible versions of several products. You can ensure that
you have all the correct versions of the Oracle Applications and other
Oracle products by installing all products from one set of Oracle
Applications Release 11i CDs.
• Oracle Forms Developer 6i
• Oracle Reports Developer 6i
• Oracle Application Object Library Release 11i
• Oracle8i
• JInitiator
While you can develop forms using the standard Oracle Forms
Developer, you cannot run your Oracle Applications–based forms from
the Oracle Forms Developer. Running such forms requires additional
Oracle Application Object Library user exits referred to by the libraries,
as well as settings and runtime code that can only be seen when
running forms through a browser with JInitiator. Both the libraries and
the user exits also assume a full installation of the Oracle Application
Object Library database schema, as they reference tables, views, and
packages contained therein.

Mandatory Settings for Running Oracle Applications

The html file used to launch Oracle Applications must include several
specific settings for Oracle Applications to function properly. The
following table contains the required parameters and their required
values:
Name Value
colorScheme- blue
lookAndFeel -oracle
separateFrame- true
darkLook -true
readOnlyBackground- automatic
dontTruncateTabs- true
background- no

Additionally, the file OracleApplications.dat must contain the
following lines:
app.ui.requiredFieldVABGColor=255,242,203
app.ui.lovButtons=true
app.ui.requiredFieldVA=true
There are several variables that must be set correctly, either as Unix
environment variables or NT Registry settings, before starting up your
Forms Server for running Oracle Applications. These variables include
NLS_DATE_FORMAT. NLS_DATE_FORMAT must be set to
DD–MON–RR

Mandatory Settings for Form Generation

At form generation time, make sure you designate the character set
designed for your language in the NLS_LANG variable in your
Windows NT registry or environment file (for Unix). You must ensure
that the character set you specify is the character set being used for
your Oracle Applications installation.
You must also set the value of your FORMS60_PATH environment
variable in your environment file (or platform equivalent such as
Windows NT registry) to include any directory that contains forms,
files, or libraries you use to develop and generate your forms.
Specifically, you must include a path to the <$AU_TOP>/forms/US
directory to be able to find all referenced forms, and a path to the
<$AU_TOP>/resource directory to be able to find the Oracle
Applications library files you need (where <$AU_TOP> is the
appropriate directory path, not the variable).

Recommended Setting for Form Development

Oracle Forms Developer allows referenced objects to be overridden in
the local form. Oracle Forms Developer also does not normally
provide any indication that an object is referenced unless you set a
special environment variable (Registry setting for NT). Set the
environment variable (Registry setting) ORACLE_APPLICATIONS to
TRUE before starting Oracle Forms Developer. This setting allows you
to see the reference markers (little flags with an ”R” in them) on
referenced objects so you can avoid changing referenced objects
unintentionally. Any object referenced from the APPSTAND form must
never be changed.

Oracle Application Object Library for Release 11i

Oracle Application Object Library (AOL) for Release 11i includes
(partial list):
• Starting forms
– Template form with standard triggers (TEMPLATE)
– Form containing standard property classes for your runtime
platform (APPSTAND)
• PL/SQL libraries
– Routines for Flexfields, Function security, User Profiles,
Message Dictionary (FNDSQF)
– Standard user interface routines (APPCORE, APPCORE2)
– Routines for Calendar widget (APPDAYPK)
• Development standards
– Oracle Applications User Interface Standards for Forms–Based

Setting Object Characteristics

The characteristics of most form objects, including modules, windows,
canvases, blocks, regions, and items may be set in the following ways:
• Inherited through property classes, which cause certain
properties to be identical in all forms (such as canvas visual
attributes)
• At the discretion of the developer during form design (such as
window sizes)
• At runtime, by calling standard library routines (such as window
positions)

Shared Objects
These standards rely extensively on the object referencing capabilities
of Oracle Forms. These capabilities allow objects to be reused across
multiple forms, with changes to the master instance automatically
inherited by forms that share the object. Additionally, these shared
objects provide flexibility for cross–platform support, allowing Oracle
Applications to adhere to the look and feel conventions of the platform
they run on.
APPSTAND Form
The APPSTAND form contains the master copy of the shared objects.
It contains the following:
• Object group STANDARD_PC_AND_VA, which contains the
Visual Attributes and Property Classes required to implement
much of the user interface described in the Oracle Applications
User Interface Standards for Forms–Based Products. A property
class exists for almost every item and situation needed for
development.
• Object group STANDARD_TOOLBAR, which contains the
windows, canvasses, blocks, and items of the Applications
Toolbar. This group also contains other items which are required
in all forms but are not necessarily part of the Toolbar.
• Object group STANDARD_CALENDAR, which contains the
windows, canvasses, blocks, and items of the Applications
Calendar.
Object group QUERY_FIND, which contains a window, canvas,
block, and items used as a starting point for coding a Find
Window. This object group is copied into each form, rather than
referenced, so that it can be modified.

TEMPLATE Form

The TEMPLATE form is the required starting point for all development
of new forms. It includes references to many APPSTAND objects,
several attached libraries, required triggers, and other objects.
Start developing each new form by copying this file, located in
$AU_TOP/forms/US (or your language and platform equivalent), to a
local directory and renaming it as appropriate. Be sure to rename the
filename, the internal module name, and the name listed in the call to
FND_STANDARD.FORM_INFO found in the form–level PRE–FORM
trigger.

FNDMENU

The Oracle Applications default menu (with menu entries common to
all forms, such as File, Edit, View, Help, and so on) is contained in the
$AU_TOP/resource/US directory (or its equivalent) as the file
FNDMENU. You should never modify this file, nor should you create
your own menu for your forms.

Standard Libraries

Application Object Library contains several libraries that support the
Oracle Applications User Interface Standards for Forms–Based Products:

• FNDSQF contains packages and procedures for Message
Dictionary, flexfields, profiles, and concurrent processing. It also
has various other utilities for navigation, multicurrency, WHO,
etc.

• APPCORE and APPCORE2 contain the packages and procedures
that are required of all forms to support the menu, Toolbar, and
other required standard behaviors. APPCORE2 is a
near–duplicate of APPCORE intended for use with the CUSTOM
library.

• APPDAYPK contains the packages that control the Applications
Calendar.

• APPFLDR contains all of the packages that enable folder blocks.

• VERT, GLOBE, PSAC, PQH_GEN, GHR, JA, JE, and JL exist to
support globalization and vertical markets. These libraries are
for Oracle Applications use only and may not be attached to
custom forms. However, they appear to be attached to most
forms based on the TEMPLATE form because they are attached
to the APPCORE library or other standard libraries.

• CUSTOM contains stub calls that may be modified to provide
custom code for Oracle Applications forms without modifying
the Oracle Applications forms directly.

The TEMPLATE form includes attachments to the FNDSQF, APPCORE
and APPDAYPK libraries. Other standard Oracle Applications libraries
are attached to those libraries and may appear to be attached to the
TEMPLATE form.

Property Classes

Property classes are sets of attributes that can be applied to almost any
Oracle Forms object. The TEMPLATE form automatically contains
property classes, via references to APPSTAND, that enforce standard
cosmetic appearances and behaviors for all widgets and containers as
described in the Oracle Applications User Interface Standards for
Forms–Based Products.

Application–specific Property Classes, Object Groups and Objects
Each application should take advantage of the referencing capabilities
of Oracle Forms to help implement standards for their particular
application in the same manner as APPSTAND.
For example, the General Ledger application might have specified
standard widths and behaviors for ”Total” fields throughout the
application. A GL_TOTAL Property Class, referenced into each form,
could set properties such as width, format mask, etc. A General
Ledger developer, after referencing in this set of property classes, can
then simply apply the GL_TOTAL property class to each item in the
form that is a Total field and it inherits its standard appearance and
behavior automatically. Entire items or blocks can also be reused.
Further, property classes can be based on other property classes, so the
GL_TOTAL class could be based on the standard TEXT_ITEM_
DISPLAY_ONLY class in APPSTAND. Such subclassing allows the
application–specific object to inherit changes made within APPSTAND
automatically.
Most Oracle Applications products also have a ”standard” form
(typically called [Application short name]STAND, such as GLSTAND
or BOMSTAND) in the same directory if you install the development
versions of those products. These files are used for storing
application–specific object groups, property classes, and other objects
that are referenced into Oracle Applications forms.

Visual Attributes

All of the visual attributes described in the Oracle Applications User
Interface Standards for Forms–Based Products are automatically included
in the TEMPLATE form via references to APPSTAND. Each visual
attribute is associated with a property class or is applied at runtime by
APPCORE routines.
For detailed information about the specific color palettes and effects of
the visual attributes, see the Oracle Applications User Interface Standards
for Forms–Based Products.

Overview of Application Development Steps

This is the general process of creating an application that integrates
with Oracle Applications.
1. Register your application.
2. Set up your application directory structures.
3. Modify the appropriate environment files.
4. Register your custom Oracle schema.
5. Include your custom application and Oracle schema in data
groups.
6. Create your application tables and views.
7. Integrate your tables and views with the Oracle Applications APPS
schema.
8. Register your flexfields tables.
9. Build your application libraries and forms.
10. Build your application functions and menus.
11. Build your application responsibilities.
12. Build concurrent programs and reports.
13. Customize Oracle Applications forms if necessary using the
CUSTOM library.

Overview of Form Development Steps

This is the general process of building a form that integrates with
Oracle Applications.
1. Copy the form TEMPLATE and rename it.
2. Attach any necessary libraries to your copy of TEMPLATE.
TEMPLATE comes with several libraries already attached.
3. Create your form blocks, items, LOVs, and other objects and apply
appropriate property classes.
4. Create your window layout in adherence with the Oracle
Applications User Interface Standards for Forms–Based Products.
5. Add table handler logic.
6. Code logic for window and alternative region control.
7. Add Find windows and/or Row–LOVs and enable Query Find.
8. Code logic for item relations such as dependent fields.
9. Code any messages to use Message Dictionary.
10. Add flexfields logic if necessary.
11. Add choices to the Special menu and add logic to modify the
default menu and toolbar behavior if necessary.
12. Code any other appropriate logic.
13. Test your form by itself.
14. Register your form with Oracle Application Object Library.
15. Create a form function for your form and register any subfunctions.
16. Add your form function to a menu, or create a custom menu.
17. Assign your menu to a responsibility and assign your responsibility
to a user.
18. Test your form from within Oracle Applications (especially if it
uses features such as user profiles or function security).

Getting Help

2008-01-10T22:38:00.000-08:00

Oracle Applications provides you with a complete online help facility.
Whenever you need assistance, simply choose an item from the Help
menu to pinpoint the type of information you want.

To display help for a current window:
1. Choose Window Help from the Help menu, click the Help button
on the toolbar, or hold down the Control key and type ’h’.

Example

A web browser window appears, containing search and navigation
frames on the left, and a frame that displays help documents on the
right.
The document frame provides information on the window
containing the cursor. The navigation frame displays the top–level
topics for your responsibility, arranged in a tree control.
2. If the document frame contains a list of topics associated with the
window, click on a topic of interest to display more detailed
information.
3. You can navigate to other topics of interest in the help system, or
choose Close from your web browser’s File menu to close help.
Suppose you are using Oracle General Ledger and are in the Define
Budget Organization window. You want to know how to create a
budget organization using this window. Choose Window Help from
the Help menu to display a help on this topic.
To display online help for any of the Oracle Applications products:
1. Choose Oracle Applications Library from the Help menu.
A web browser window appears, containing search and navigation
frames on the left, and a document frame on the right.
2. In the navigation frame, click on the name of a product family to
display a list of products in that family. Click on a product name to
display the list of top–level topics in that product’s online
documentation.
3. Click on a topic of interest. Topics preceded by a plus sign (+)
expand to show subtopics. Help on the topic displays in the
document frame.
4. To collapse sections of the tree you previously expanded, click on
topics preceded by a minus sign (–).
5. When you are finished, choose Close from the web browser’s File
menu to close help.
Note: A topic called ”Library” and topics corresponding to
other products and product families are often included on the
navigation tree associated with a particular responsibility.
These topics function in a fashion similar to the Library tree
described here.
1 – 26 Oracle Applications User’s Guide
To display version information for Oracle Applications:
1. Choose About Oracle Applications from the Help menu.
2. An About Oracle Applications window appears on your screen.
The window provides details about the version of the Oracle
Applications components you are using, your login information,
and information about the current form you are using.
You can supply this information to your system administrator or to
Oracle Customer Support if you need to report a problem.
3. Choose OK to close this window.

Searching for Help

You can perform a search to find the Oracle Applications help
information you want. Simply enter your query in the text field located
in the top–left frame of the browser window when viewing help, then
click the adjacent Find button.
A list of titles, ranked by relevance and linked to the documents in
question, is returned from your search in the right–hand document
frame. Click on whichever title seems to best answer your needs to
display the complete document in this frame. If the document doesn’t
fully answer your questions, use your browser’s Back button to return
to the list of titles and try another.
The search syntax to use in constructing your query can be any of those
shown in the following table.

Use this syntax . . . To find files containing . . .
term the word ”term”
string* words that begin with ”string”
”words, and punctuation” the precise phrase ”words, and punctuation”
term1 OR term2 either term1 or term2
term1 term2
term1 AND term2 both term1 and term2
term1 +term2
term1 AND NOT term2 term1, but not term2
term1 –term2

Using Keyboard Shortcuts

2008-01-10T22:36:00.002-08:00

Experienced Oracle Applications users can access the menu by using a
keyboard shortcut, a specific combination of keystrokes that performs the
same function as a corresponding menu item. Oracle Applications
assigns many commonly used functions, such as Run Query, Save, or
Clear Record to keyboard shortcuts.
You can display a list of the keyboard shortcuts that map to your
computer terminal’s keyboard at any time.
Note: Rather than list the actual keys for a keyboard shortcut,
we refer to keyboard shortcuts in this guide using the format
[Function] where Function represents the function that the
keyboard shortcut performs.
To display a list of keyboard shortcuts:
1. Choose Keyboard Help... from the Help menu.

2. When you finish scrolling through the listing, choose OK to close
the window.
Most window buttons are also mapped to keyboard shortcuts. The
shortcut key is indicated with an underline in the button label. For
example, in the Request Summary window, the button label Hold
Request has the ”H” underlined. This indicates that you can use the
keyboard shortcut Alt–H to put a request on hold instead of using the
mouse.

Using Menus

2008-01-10T22:36:00.001-08:00

Oracle Applications use a Multiple Document Interface (MDI). All
windows are displayed inside a single container window, with a single
toolbar, menu, message line, and status line attached to that window.
Pulldown Menu
The pulldown menu bar includes the following menus:
• File
• Edit
• View
• Folder
• Tools
• Special A & B (only visible when active)
• Window
• Help
Use these menus to navigate through a form, to edit or retrieve data, or
to perform various other actions.
See Also
Oracle Applications Pulldown Menu Bar: page A – 2
Right Mouse Button Menus
In addition to the Pulldown menu, using the right mouse button allows
you to access the following menu items:
• Cut
• Copy
• Paste
• Folder Menu
• Help

Changing Your Security Access

2008-01-10T22:34:00.000-08:00

If you have several responsibilities and you want to work in Oracle
Applications under a different responsibility, you can do so without
exiting Oracle Applications.
You can also change the password to your user sign–on at any time.
Your system administrator may require all users to periodically change
their passwords to maintain better security to Oracle Applications.
To switch your responsibility:
1. Click in the Navigate window or choose Navigator from the
Window menu to make the Navigate window active.
2. Choose Switch Responsibility from the File menu.
If there are windows still open in your current responsibility,
Oracle Applications asks you to save your changes, if there are any,
before it closes those windows. You may cancel switching
responsibilities by choosing Cancel in the save changes window.
Note: The save changes window only appears if there are any
changes to save. If there are no changes to save, all open windows
other than the Navigate window close, and Oracle Applications
displays your responsibility list.
Note: If you have only one responsibility, the Switch Responsibility
menu item is disabled.
3. Select a new responsibility from the Responsibilities window and
choose OK.
The Navigate window title and contents then update to reflect the
new responsibility you chose.
To change your password:
1. Click in the Navigate window or choose Navigator from the
Window menu to make the Navigate window active.
2. Choose Change Password... from the Edit, Preferences menu, to
display the Password Update window.

3. Enter your old password in the Old Password field.
4. Enter your new password in the New Password field.
5. Enter your new password again in the Re–enter New Password
field.
6. Choose OK.
If the second entry of your new password does not match your
first, Oracle Applications asks you to re–enter your new password
again, until both entries match. Your new password takes effect
immediately.
Note: If you change your mind and do not want to alter your
password, choose Cancel to close the Password Update window.

Opening a Form from the Navigator Window

2008-01-10T22:31:00.000-08:00

The Navigator consists of three regions: Functions, Documents, and
Processes. The Functions region provides a list of forms displayed like
the files in a file system, the Documents region is a customizable region
that allows you to create links to specific documents that you use frequently,
and the Processes region provides graphical maps of
business processes, allowing you to automate business flows across
forms.

Getting Started in Oracle Applications

2008-01-10T22:27:00.000-08:00

To log on to Oracle Applications:
1. Enter your username in the User Name field.
Attention: Do not press [Enter] after entering each item, as [Enter]
is normally used to accept the default button. Instead, use [Tab] or
the mouse to navigate between fields.
2. Enter your password in the Password field.
3. Choose Connect.
Notice your password does not appear as you type it, to prevent
others from seeing it. Keep your password confidential to prevent
access to Oracle Applications by unauthorized users.

From the main tab on your personal homepage you can access a
list of links to your responsibilities.
A responsibility is a level of authority in Oracle Applications that lets
you access only those Oracle Applications functions and data
appropriate to fulfill your role in an organization. Each responsibility
allows access to:
• A specific application or applications, such as Oracle General
Ledger or Oracle Planning.
• A set of books, such as U.S. Operations or German Sales or an
organization, such as New York Manufacturing or New York
Distribution.
• A restricted list of windows that you can navigate to; for
example, a responsibility may allow certain Oracle Planning
users to enter forecast items, but not enter master demand
schedule items.
• A restricted list of functions you can perform. For example, two
responsibilities may have access to the same window, but one
responsibility’s window may have additional function buttons
that the other responsibility’s window does not have.
• Reports in a specific application; your system administrator can
assign groups of reports to one or more responsibilities, so the
responsibility you choose determines the reports you can submit.
Each user has at least one responsibility and several users can share the
same responsibility.

Two Types of Responsibilities
The Navigate region may contain links to Self–Service Web applications
as well as Forms–based applications. Forms–based responsibilities
launch Oracle Applications Forms.
For information about Oracle Self–Service Web Applications, see
Personal Homepage in Oracle Self–Service Web Applications: page
B – 2.
You will see a link for each responsibility assigned to you.

To choose a Forms–based responsibility:
Simply click on a link in the Navigate region of your Personal
Homepage. Doing this will open the Oracle Applications
Navigator window for the responsibility you have chosen.
For more information about the Navigator Window, see Opening a
Form from the Navigator Window: page 1 – 10.
Note: If your system administrator assigns you just one
Forms–based responsibility with no other options on your
homepage, your responsibility will launch when you sign on.
If you are assigned one Self–Service responsibility with many
functions, and you have no other options on your personal
homepage, your responsibility’s list of functions will display as
if you had clicked the link.
If you are assigned one Self–Service responsibility with just one
function, and you have no other options on your personal
homepage, your function will launch automatically when you
sign on.

Setting your Preferences through the Personal Homepage
There are several choices you can make about how you want to view
information in Oracle Applications. These choices include languages,
date formats, and number formats.
To access your preferences, choose the Preferences link in the Favorites
region of your personal homepage.
To select your language
• Click on the drop down list labeled ”Language.”
• Select the language in which you prefer to work. You will see
screens, reports, and some data in the language you choose.
To select your date format
• Click on the drop down list labeled ”Date Format.”
• Select the format in which you would like to view dates.
To select your number format
• Click on the drop down list labeled ”Number Format”
• Select the format in which you would like to view numbers.
Attention: Currently only the US number format is
recognized in Oracle self–service applications.
For information about Oracle Self Service Web Applications, see
Personal Homepage in Oracle Self–Service Web Applications: page
B – 2.

Overview of Oracle Applications

2008-01-10T22:18:00.000-08:00

Oracle Applications is a tightly–integrated family of application
products that share a common look and feel. Using the menus and
windows of Oracle Applications, you have access to all the functions
you need to manage your business information.
Oracle Applications is highly responsive to users, supporting a
multi–window graphical user interface (GUI) that provides you with
full point–and–click capability. You can use your mouse or keyboard to
operate graphical controls such as pull–down menus, buttons, poplists,
and check boxes.
In addition, Oracle Applications offers many other features such as
field–to–field validation and list of values to help you simplify data
entry and maintain the integrity of the data you enter.
The best way to familiarize yourself with the common look and feel of
Oracle Applications products is to log in and use the products. This
chapter describes how to get started with Oracle Applications and
provides you with the basic information you need to explore Oracle
Applications in greater depth.

Basic Business Needs

Oracle Applications provides you with features you need for your
business. With Oracle Applications you can:
• Learn how to use the system quickly. Oracle Applications uses
familiar and easy–to–use menus so you, your staff, and your new
employees can be productive after a few minutes of coaching
from a colleague.
• Be productive even if you are a novice user. A simple, intuitive
graphical user interface (GUI) lets you use all of the power of
Oracle Applications.
Getting Started 1 – 3
• Increase your productivity as a power user. When you become
familiar with Oracle Applications, you can use shortcuts in the
graphical user interface to quickly navigate and work with
multiple windows at once.
• Get help when you need it. Context–sensitive online help is
always available whenever you need assistance.
• Secure your application data from unauthorized access. You
can control access to your application data and customize the
windows available for each user based on that user’s level of
authority

Basic GUI Terminology
Before using Oracle Applications, you should familiarize yourself with
the specifics of your GUI environment and how to perform basic tasks,
such as using a menu or selecting an item. In doing so, you should
come across and become familiar with the following generic terms:

desktop - The part of your computer monitor that displays
information and where your work takes place.
This is also referred to as your screen.

window - A box around a set of related information on your
desktop

menu - A list that appears in a bar across the top of a
window that consists of commands or actions you
can perform.

click - Quickly press and release a mouse button while the
mouse pointer is on a particular item.

double–click - Rapidly click a mouse button twice while the
mouse pointer is on a particular item.

drag - Move the mouse while holding down a mouse
button.

select - Mark an item. Examples include highlighting text,
or clicking on a value from a list.

choose - Select an item and initiate the action associated
with the item. Examples include choosing a menu
item or choosing a button.

scroll bar - A vertical or horizontal bar that appears on a
window whose contents are not entirely visible.

Starting Oracle Applications
To start Oracle Applications, you need to:
• Start up your computer system
• Start your Web Browser
• Start the Oracle Applications program
• Log on to Oracle Applications
• Choose a responsibility (if necessary)
• Navigate to an application window (if necessary)

Starting and Logging On
The first step in starting Oracle Applications is to enter the appropriate
URL for your site in an Oracle Applications certified browser.
After starting Oracle Applications, the first window you see is the
sign–on window.

Preface

2008-01-10T22:15:00.000-08:00

Information Sources
You can choose from many sources of information, including online
documentation, training, and support services, to increase your
knowledge and understanding of Oracle Applications.
If this guide refers you to other Oracle Applications documentation,
use only the Release 11i versions of those guides unless we specify
otherwise.

Online Documentation
All Oracle Applications documentation is available online (HTML and
PDF). The technical reference guides are available in paper format
only. Note that the HTML documentation is translated into over
twenty languages.
The HTML version of this guide is optimized for onscreen reading, and
you can use it to follow hypertext links for easy access to other HTML
guides in the library. When you have an HTML window open, you can
use the features on the left side of the window to navigate freely
throughout all Oracle Applications documentation.
• You can use the Search feature to search by words or phrases.
• You can use the expandable menu to search for topics in the
menu structure we provide. The Library option on the menu
expands to show all Oracle Applications HTML documentation.
You can view HTML help in the following ways:
• From an application window, use the help icon or the help menu
to open a new Web browser and display help about that window.
• Use the documentation CD.
• Use a URL provided by your system administrator.

User Guides Related to All Products
Oracle Alert User Guide
Use this guide to define periodic and event alerts that monitor the
status of your Oracle Applications data.
Oracle Applications Implementation Wizard User Guide
If you are implementing more than one Oracle product, you can use the
Oracle Applications Implementation Wizard to coordinate your setup
activities. This guide describes how to use the wizard.
Oracle Applications Developer’s Guide
This guide contains the coding standards followed by the Oracle
Applications development staff. It describes the Oracle Application
Object Library components needed to implement the Oracle
Applications user interface described in the Oracle Applications User
Interface Standards for Forms–Based Products. It also provides
information to help you build your custom Oracle Developer forms so
that they integrate with Oracle Applications.
Oracle Applications User Interface Standards for Forms–Based
Products
This guide contains the user interface (UI) standards followed by the
Oracle Applications development staff. It describes the UI for the
Oracle Applications products and how to apply this UI to the design of
an application built by using Oracle Forms.

CRM CONTRACTS CORE

2008-01-10T02:01:00.000-08:00

Oracle Contracts Core

The Contracts Core module acts as a central repository for the collection and dissemination of contract information. It contains all data on terms and conditions, deliverables, and parties to the contracts. This repository is the key to provide a single source for all the information in any contract in your enterprise.

You can author, execute and control non-industry specific contracts with Contracts Core, for both buy and sell contracts. It helps companies manage internal and external obligations, control daily deliverables, and be focused on contractual goals.

Contract Phases

Authoring

Enables you to create, define, modify, and approve the contract. By using Contracts core/ service you can author and original buy or sell contract, define a contract from a template, or copy another contract. Business rules can be set up to force contracts to go through an approval process to ensure that the contracts are accurate and satisfactory.

Execution

Enables you to review deliverables schedule revisions, communications, and sales information such as quotes or orders. During execution you can track the deliverables and tasks. Communications between parties can be recorded and become part of the contract. Rule are also used to execute a contract, enforcing such things as ship-to and bill-to address, ship method, freight terms and pricing information.

Administration

Enables you to perform contract management such as change requests, renew/ extend/ terminate, copy contract, and so on. Change requests are a formal way of documenting the changes to a contract. You can submit a change request to initiate a contract change. After the change request is approved, the contract can be changed.

Authoring Flow

1. The customer and the vendor discuss the options.

2. The contracts administrator creates the new contract, by using a template, the copy function, and so on.

3. The contracts administrator authors the contract.

4. The contract is submitted for online quality assurance check to make sure that all information is accurate and complete.

5. The contracts administrator submits the contract to the manager for approval.

6. The contract manager approves the contract.

7. The contracts administrator sends the contract to the customer who then approves and signs it.

8. The contract administrator signs the contract.

9. Once the vendor and the customer have signed the contract, the contract becomes active and the customer is delivered the contract items according to the terms and conditions of the contract.

The Contracts Core / Sales (OKC/OKO) business flow:

1. Generate Lead: In Telesales or sales Online a sales representative cerates and qualifies a lead for an existing customer or a prospect for certain items.

2. Create Opportunity: As soon as the lead gets more qualified, the sales representative creates an opportunity in Telesales or Sales online.

3. Create Quote: The customer agrees with the conditions, a quote is created in the quoting module.

4. Create Contract: Based on the data in the quote and the negotiated terms and conditions a contract is created.

5. Renew Lines and Terms & Conditions: The contract administrator might review and verify the entered contract lines and terms & conditions.

6. Approve and Sign Contract: After the contract is accepted, the contract administrator will start the approval process and the administrator’s manager will approve the contract.

7. Active Contract: After the approval process passed successfully the contract has the status ‘Active’.

8. Create Sales Order: Based on the active contract a sales order can be created automatically.

9. Renewal Process: Prior or after the contract expiration a renewal process can be started.

CONTRACT BUNDLING

Contract Integration Layer (OKX)

Oracle Contracts Integration (OKX)

OKX is a layer of integration that allows contracts applications (OKC, OKO, and OKS) to interface to external applications in both ERP and CRM.

Integration to ERP Modules

General Ledger (GL), Human Resources (PER), Purchasing (PO), Order Management (ONT), Payables (AP), Pricing (QP), Configurator (CZ), Inventory (INV), Receivables (AR).

Integration to CRM

Interaction History: - Data pulled includes resources, actions and outcomes. The interaction history feature tracks all interactions between contract parties and serves as a repository for the interaction data. An interaction is a point of contact and may relate to parties, orders, quotes and so on.
Task Manager: - Data pulled includes resources, roles and task status. This information is uses when assigning tasks for specific contract deliverables.
Resources Manager: - Data pulled includes resources, roles and categories. This information is used when defining parties.
Telesales (AST)
Quoting (ASO)

CONCURRENT - EXPLAINED DEFINATION

2008-01-10T01:50:00.000-08:00

Concurrent Process:

Simultaneously executes program running in the background with online operations to fully utilize the hardware capacity.

Concurrent Program:

Can write a program that runs as a concurrent process. Use concurrent program for long running, data-intensive tasks.

Major features:

On-line requests

Automatic scheduling

Concurrent processing

Online request review

Concurrent manager

Simultaneous queuing

On-line Request:

You and end-user can submit requests from forms to start any concurrent program.

Automatic Scheduling:

Oracle Application Object Library automatically schedules requests based on when they were submitted, their priority, and their compatibility with programs those are already running.

Concurrent Manager:

Cocurrent Managers are components of concurrent processing that monitors and run, time-consuming, non-interactive tasks without tying up your terminal.

Concurrent manager processes requests and does the work in the background, giving the ability to run multiple tasks simultaneously.

Internal Concurrent Manager starts up, verifies the status of, resets, and shuts down the individual managers.

Simultaneous Queuing:

It lets requests wait in many queues at once to ensure that the first available concurrent manager starts the request.

Concurrent Program Executable:

Links an execution file and the method used to execute it with defined concurrent program. This mathod may be a program written in standard language, a reporting tool, or an operating system language.

A Concurrent program execution file is an operating system file or database stored procedure.

Concurrent Program Definition:

A concurrent program is an instance of an execution file, along with parameter definitions and incompatibilities. Concurrent programs use concurrent program executables to locate the correct execution file.

Concurrent Program written in:

Oracle reports, PL/SQL package procedures, SQL *Loader, SQL *Plus, Host script.

Parent request:

A parent request is a concurrent request that submits another concurrent request.

Child request:

A child request is a concurrent request submitted by another concurrent request.

Concurrent Manager:

Concurrent Managers are components of Concurrent Processing that monitor and run, time-consuming,non-interactive tasks without tying up terminal.

Whenever request submits to run a task, a concurrent manager processes that request and does the work in background, giving the ability to run multiple tasks simultaneously.

Tables In PO

2008-01-09T08:47:00.003-08:00

PO_PRICE_DIFFERENTIALS_ARCHIVE
PO_PRICE_DIFF_INTERFACE
PO_COMMUNICATION_GT
PO_ADDRESS_DETAILS_GT
PO_REQUISITION_SUPPLIERS
PO_ENCUMBRANCE_GT
PO_SESSION_GT
RCV_GAPLESS_INVOICE_NUMBERS
PO_JOB_ASSOCIATIONS_B
PO_JOB_ASSOCIATIONS_TL
PO_RETRIEVED_TIMECARDS
RCV_FTE_TRANSACTION_LINES
RCV_ACCOUNTING_EVENTS
RCV_ACCOUNTING_EVENT_TYPES
RCV_ROUTING_HEADERS_OLD
PO_GA_ORG_ASSIGNMENTS_ARCHIVE
PO_VENDORS
PO_VENDOR_SITES_ALL
PO_DISTRIBUTIONS_ALL
PO_LINE_LOCATIONS_ALL
PO_SYSTEM_PARAMETERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQEXPRESS_LINES_ALL
PO_RELEASES_ALL
RCV_SHIPMENT_HEADERS
PO_VENDOR_CONTACTS
PO_REQUISITION_HEADERS_ALL
PO_HEADERS_ALL
PO_NOTIFICATIONS_ALL
PO_QUOTATION_APPROVALS_ALL
PO_CONTROL_GROUPS_ALL
PO_ACCRUAL_RECONCILE_TEMP_ALL
PO_LINES_ALL
RCV_MC_SUB_LEDGER_DETAILS
RCV_RECEIVING_SUB_LEDGER
PO_VENDOR_LIST_HEADERS
PO_VENDOR_LIST_ENTRIES
PO_LOCATION_ASSOCIATIONS_ALL
RCV_TRANSACTIONS
PO_MASSCANCEL_INCLUDES_ALL
PO_UNIQUE_IDENTIFIER_CONT_ALL
PO_ASL_ATTRIBUTES
PO_SUPPLIER_ITEM_CAPACITY
PO_SUPPLIER_ITEM_TOLERANCE
PO_ASL_DOCUMENTS
PO_DOCUMENT_TYPES_ALL_B
PO_HEADERS_ARCHIVE_ALL
PO_REQ_DIST_INTERFACE_ALL
PO_REQUISITIONS_INTERFACE_ALL
PO_LINE_LOCATIONS_ARCHIVE_ALL
PO_EMPLOYEE_HIERARCHIES_ALL
RCV_TRANSACTIONS_INTERFACE
PO_UN_NUMBERS_B
PO_RELEASES_ARCHIVE_ALL
PO_LINE_TYPES_B
PO_DOCUMENT_TYPES_ALL_TL
PO_AGENTS
PO_APPROVED_SUPPLIER_LIST
FND_NOTIFICATIONS
CHV_HORIZONTAL_SCHEDULES
EDW_PO_VENDOR_HIERARCHIES
PO_MC_HEADERS
RCV_MC_REC_SUB_LEDGER
RCV_MC_TRANSACTIONS
RCV_SHIPMENT_LINES
PO_LINES_ARCHIVE_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL
POA_BIS_SAVINGS_RPT
PO_AUTOSOURCE_RULES
PO_AUTOSOURCE_VENDORS
PO_HISTORY_REQUISITIONS_ALL
PO_ACCRUAL_ACCOUNTS_TEMP_ALL
RCV_SERIAL_TRANSACTIONS
PO_QUALITY_CODES
PO_HISTORY_POS_ALL
PO_HEADERS_INTERFACE
PO_MC_DISTRIBUTIONS
PO_POSITION_CONTROLS_ALL
RCV_MC_SHIPMENT_HEADERS
PO_ACTION_HISTORY
PO_HAZARD_CLASSES_B
PO_AUTOSOURCE_DOCUMENTS_ALL
PO_REQ_DISTRIBUTIONS_ALL
PO_ACCRUAL_WRITE_OFFS_ALL
PO_REQEXPRESS_HEADERS_ALL
CHV_AUTHORIZATIONS
CHV_BUCKET_PATTERNS
CHV_CUM_ADJUSTMENTS
CHV_CUM_PERIODS
CHV_CUM_PERIOD_ITEMS
CHV_ITEM_ORDERS
CHV_ORG_OPTIONS
CHV_SCHEDULE_HEADERS
CHV_SCHEDULE_ITEMS
PO_ACCEPTANCES
PO_ASL_STATUSES
PO_CONTROL_FUNCTIONS
PO_CONTROL_RULES
PO_NOTE_REFERENCES
PO_NOTIFICATION_CONTROLS
PO_RFQ_VENDORS
RCV_LOTS_INTERFACE
RCV_ROUTING_STEPS
PO_COMMODITIES_B
PO_COMMODITIES_TL
PO_MASSCANCEL_INTERIM
PO_RELATED_TEMPLATES
RCV_LOT_TRANSACTIONS
POA_BIS_SAVINGS
PO_ASL_STATUS_RULES
PO_SI_CAPA_SN
PO_ONLINE_REPORT_TEXT
PO_INTERFACE_ERRORS
RCV_HEADERS_INTERFACE
PO_CHANGE_REQUESTS
PO_GA_ORG_ASSIGNMENTS
CHV_HISTORY_CUM_PERIODS
CHV_HISTORY_SCHEDULES
CHV_PURGE_CUM_LIST
CHV_PURGE_SCHEDULE_LIST
CHV_SCHEDULE_ORGANIZATIONS
FND_FUNCTION_PARAMETER_MAP
MLOG$_PO_ACCEPTANCES
MLOG$_PO_CHANGE_REQUESTS
MLOG$_PO_COMMODITY_CATEGOR
MLOG$_PO_SUPPLIER_ITEM_CAP
MLOG$_PO_VENDORS
MLOG$_PO_VENDOR_SITES_ALL
POA_BIS_SAVINGS_EFC
POA_BIS_SAVINGS_RPT_EFC
POA_BIS_SUPPLIER_PERFORMANCE
POA_BIS_SUPPLIER_PERFORMAN_EFC
POA_CM_DISTRIBUTIONS
POA_CM_EVALUATION
POA_CM_EVAL_SCORES
PO_ACCEPTANCES_SN
PO_ACCRUAL_WRITE_OFFS_ALL_EFC
PO_APPROVAL_LIST_HEADERS
PO_APPROVAL_LIST_LINES
PO_ATT_TMP_RECORDS
PO_CHANGE_REQUESTS_SN
PO_COMMODITY_CATEGORIES
PO_COMMODITY_GRANTS
PO_CONTROL_RULES_EFC
PO_DISTRIBUTIONS_ALL_EBS
PO_DISTRIBUTIONS_GT
PO_DISTRIBUTIONS_INTERFACE
PO_HAZARD_CLASSES_TL
PO_HEADERS_ALL_EBS
PO_HEADERS_GT
PO_HISTORY_RECEIPTS
PO_HISTORY_VENDORS
PO_LINES_ALL_EBS
PO_LINES_GT
PO_LINES_INTERFACE
PO_LINE_LOCATIONS_ALL_EBS
PO_LINE_LOCATIONS_GT
PO_LINE_TYPES_TL
PO_LOOKUP_CODES_OLD
PO_LOOKUP_TYPES_OLD
PO_NOTES
PO_NOTE_ATTRIBUTES
PO_ONLINE_REPORT_TEXT_GT
PO_PRICE_DIFFERENTIALS
PO_PURGE_PO_LIST
PO_PURGE_REQ_LIST
PO_PURGE_VENDOR_LIST
PO_RELEASES_ALL_EBS
PO_RELEASES_GT
PO_REQUISITIONS_INT_ALL_EFC
PO_REQUISITION_LINES_ALL_EFC
PO_REQ_DISTRIBUTIONS_ALL_EFC
PO_REQ_DISTRIBUTIONS_GT
PO_REQ_HEADERS_GT
PO_REQ_LINES_GT
PO_REQ_SPLIT_LINES_GT
PO_RESCHEDULE_INTERFACE
PO_RETROPRICE_GT
PO_RULE_EXPENSE_ACCOUNTS
PO_UN_NUMBERS_TL
PO_USAGES
PO_USAGE_ATTRIBUTES
PO_VENDORS_EBS
PO_VENDOR_SITES_ALL_EBS
PO_WF_CANDIDATE_REQ_LINES_TEMP
PO_WF_DEBUG
RCV_LOTS_SUPPLY
RCV_MC_SHIPMENT_LINES
RCV_PARAMETERS
RCV_SERIALS_INTERFACE
RCV_SERIALS_SUPPLY
RCV_SHIPMENT_LINES_EFC
RCV_SUB_LEDGER_DETAILS
RCV_SUPPLY
RCV_UPGRADE_STEPS

Tables In INV

2008-01-09T08:47:00.001-08:00

MTL_CONSIGNED_DIAG_ERRORS
MTL_TRANSACTION_FLOW_HEADERS
MTL_TRANSACTION_FLOW_LINES
MTL_PAC_ACT_CST_DTL_TEMP
MTL_ERES_TRANSACTIONS_GTMP
MTL_ONHAND_QUANTITIES_D_BKP
MTL_ONHAND_DISCREPANCIES
INV_MVT_EXCEP_REP_TEMP
MTL_ONHAND_LOCK_TEMP
MTL_RMA_SERIAL_TEMP
MTL_VMI_QUANTITIES_TEMP
INV_ERES_EVENTS_TEMP
INV_MSN_GTEMP
MTL_ALLOCATIONS_GTMP
MTL_CONSIGNED_DIAG_TEMP
MTL_SYSTEM_ITEMS_B
MTL_UOM_CONVERSIONS
MTL_RESERVATIONS
MTL_INTERORG_SHIP_METHODS
MTL_TRANSACTION_TYPES
MTL_ITEM_LOCATIONS
MTL_ITEM_CATEGORIES
MTL_EAM_ASSET_ACTIVITIES
MTL_SERIAL_NUMBERS
MTL_UNITS_OF_MEASURE_TL
MTL_RELATED_ITEMS_PLN_INFO
MTL_PHYSICAL_ADJUSTMENTS
MTL_RELATED_ITEMS_CUST_REF
ORG_FREIGHT_TL
MTL_ITEM_TEMPLATES
MTL_INTERORG_PARAMETERS
MTL_UOM_CONVERSIONS_A
MTL_PARAMETERS
MTL_EAM_ASSET_ATTR_VALUES
MTL_SYSTEM_ITEMS_TL
MTL_ONHAND_QUANTITIES_DETAIL
MTL_TRANSACTION_ACCOUNTS
MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_MATERIAL_TRANSACTIONS
MTL_CROSS_REFERENCES
MTL_CST_ACTUAL_COST_DETAILS
MTL_CST_TXN_COST_DETAILS
MTL_DEMAND_INTERFACE
MTL_CATEGORIES_B
MTL_TXN_SOURCE_TYPES
MTL_MFG_PART_NUMBERS
MTL_ITEM_ATTRIBUTES
MTL_DESCR_ELEMENT_VALUES
MTL_SECONDARY_INVENTORIES
MTL_MATERIAL_STATUSES_B
MTL_MVT_STATS_RULE_SETS_TL
MTL_STATUS_TRANSACTION_CONTROL
MTL_ITEM_STATUS
MTL_TXN_REQUEST_LINES
MTL_TRANSACTION_LOTS_TEMP
MTL_TRANSACTION_REASONS
MTL_MGD_INVENTORY_POSITIONS
MTL_DEMAND
MTL_TXN_REQUEST_HEADERS
MTL_MOVEMENT_STATISTICS
MTL_DESCRIPTIVE_ELEMENTS
MTL_RELATED_ITEMS
MTL_RTG_ITEM_REVISIONS
MTL_ITEM_REVISIONS_B
MTL_CROSS_REFERENCE_TYPES
MTL_STATUS_ATTRIBUTE_VALUES
MTL_MANUFACTURERS
MTL_MOVEMENT_PARAMETERS
MTL_UOM_CLASS_CONVERSIONS
MTL_FORECAST_RULES
MTL_LOT_NUMBERS
ORG_ACCT_PERIODS
MTL_PLANNERS
MTL_ABC_ASSGN_GROUP_CLASSES
MTL_ABC_ASSIGNMENTS
MTL_ABC_ASSIGNMENT_GROUPS
MTL_ABC_CLASSES
MTL_CUSTOMER_ITEM_XREFS
MTL_CYCLE_COUNT_HEADERS
MTL_CYCLE_COUNT_ENTRIES
MTL_CYCLE_COUNT_CLASSES
MTL_CYCLE_COUNT_ITEMS
MTL_PENDING_ITEM_STATUS
MTL_GENERIC_DISPOSITIONS
MTL_ATP_RULES
ORG_GL_BATCHES
MTL_REPLENISH_LINES
MTL_KANBAN_CARDS
MTL_KANBAN_CARD_ACTIVITY
MTL_KANBAN_PULL_SEQUENCES
MTL_TRANSACTION_LOT_NUMBERS
MTL_PHYSICAL_INVENTORIES
MTL_PHYSICAL_INVENTORY_TAGS
MTL_UNIT_TRANSACTIONS
MTL_REPLENISH_HEADERS
MTL_SUPPLY
MTL_CATEGORY_SETS_B
MTL_ITEM_SUB_INVENTORIES
MTL_TRANSACTIONS_INTERFACE
MTL_SALES_ORDERS
MTL_DEFAULT_CATEGORY_SETS
ORG_ACCESS
MTL_COMMODITY_CODES
MTL_MATERIAL_TXN_ALLOCATIONS
MTL_CATEGORY_SETS_TL
MTL_UOM_CLASSES_TL
MTL_CUSTOMER_ITEMS
MTL_SERIAL_NUMBERS_TEMP
MTL_SO_RMA_INTERFACE
MTL_ABC_COMPILE_HEADERS
MTL_CC_SUBINVENTORIES
MTL_SYS_ITEMS_SN
MTL_ATTR_APPL_DEPENDENCIES
MTL_ITEM_CATALOG_GROUPS_B
MTL_BIS_INV_BY_PERIOD
MTL_ECONOMIC_ZONES_B
MTL_SAFETY_STOCKS
MTL_SUPPLY_DEMAND_TEMP
MTL_OH_QTYS_SN
MTL_SUPPLY_SN
MTL_CC_ENTRIES_INTERFACE
MTL_CC_SCHEDULE_REQUESTS
MTL_EAM_NETWORK_ASSETS
MTL_INTERCOMPANY_PARAMETERS
MTL_RESERVATIONS_INTERFACE
MTL_SHORT_CHK_PARAM
MTL_CATEGORIES_TL
MTL_ITEM_CATALOG_GROUPS_TL
MTL_SECONDARY_LOCATORS
MTL_CATEGORY_SET_VALID_CATS
MTL_COUNTRY_ASSIGNMENTS
MTL_CATEGORY_ACCOUNTS
MTL_EAM_ASSET_ATTR_GROUPS
MTL_DEMAND_SN
MTL_MATERIAL_STATUSES_TL
MTL_PICKING_RULES
MTL_DEMAND_HISTORIES
MTL_TXN_COST_DET_INTERFACE
MTL_STAT_TYPE_USAGES
MTL_CC_SERIAL_NUMBERS
WMS_CARTONIZATION_TEMP
COST_UPGR_ERROR_TABLE
INV_ITEM_TEMP
INV_MIN_MAX_TEMP
JE_IT_INV_PACKSLIPS
JE_IT_STK_VALUATION
MLOG$_MTL_DEFAULT_CATEGORY
MLOG$_MTL_DEMAND
MLOG$_MTL_MATERIAL_TRANSAC
MLOG$_MTL_RESERVATIONS
MLOG$_MTL_SUPPLY
MLOG$_MTL_TXN_REQUEST_HEAD
MLOG$_MTL_USER_DEMAND
MLOG$_MTL_USER_SUPPLY
MTL_ABC_COMPILES
MTL_ABC_COMPILES_EFC
MTL_ABC_COMPILE_HEADERS_EFC
MTL_ACTUAL_COST_SUBELEMENT
MTL_ACTUAL_COST_SUBELEMENT_EFC
MTL_CATALOG_SEARCH_ITEMS
MTL_CC_INTERFACE_ERRORS
MTL_CC_SCHED_COUNT_XREFS
MTL_CI_INTERFACE
MTL_CI_XREFS_INTERFACE
MTL_CONSIGNED_QTY_TEMP
MTL_CONSUMPTION_DEFINITION
MTL_CONSUMPTION_TRANSACTIONS
MTL_CONSUMPTION_TXN_TEMP
MTL_COPY_ORG_INTERFACE
MTL_COPY_ORG_REPORT
MTL_COPY_ORG_REPORT_TEMP
MTL_COPY_ORG_TEMP
MTL_CROSS_REFERENCES_INTERFACE
MTL_CST_ACTUAL_COST_DETAIL_EFC
MTL_CST_LAYER_ACT_COST_DETAILS
MTL_CST_TXN_COST_DETAILS_EFC
MTL_CYCLE_COUNT_CLASSES_EFC
MTL_CYCLE_COUNT_ENTRIES_EFC
MTL_CYCLE_COUNT_HEADERS_EFC
MTL_DESC_ELEM_VAL_INTERFACE
MTL_DO_CHECK_TEMP
MTL_EAM_ASSET_NUM_INTERFACE
MTL_EAM_ASSET_SEARCH_TEMP
MTL_EAM_ATTR_VAL_INTERFACE
MTL_EAM_LOCATIONS
MTL_ECONOMIC_ZONES_TL
MTL_EXT_OBJECTS
MTL_FISCAL_CAT_ACCOUNTS
MTL_FLEX_CONTEXT
MTL_ICG_ALIASES
MTL_ICG_CATEGORIES
MTL_INTERFACE_ERRORS
MTL_INTERFACE_PROC_CONTROLS
MTL_ITEM_ATTRIBUTES_TEMP
MTL_ITEM_CATEGORIES_INTERFACE
MTL_ITEM_CHILD_INFO_INTERFACE
MTL_ITEM_LOC_DEFAULTS
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_REVISIONS_TL
MTL_ITEM_SUB_DEFAULTS
MTL_ITEM_SUB_INVS_INTERFACE
MTL_ITEM_TEMPL_ATTRIBUTES
MTL_ITEM_VALUES_TEMP
MTL_KANBAN_CARD_PRINT_TEMP
MTL_KANBAN_TEMPLATES
MTL_LE_ECONOMIC_ZONES
MTL_LOT_NUMBERS_CLUP
MTL_MATERIAL_STATUS_HISTORY
MTL_MATERIAL_TRANSACTIONS_EFC
MTL_MOBILE_LOGIN_HIST
MTL_MOVEMENT_STATISTICS_EFC
MTL_MTRX_TMP_SN
MTL_MVT_STATS_RULE
MTL_MVT_STATS_RULES
MTL_MVT_STATS_RULE_SETS_B
MTL_OBJECT_EVENTS
MTL_OBJECT_GENEALOGY
MTL_OBJECT_GENEALOGY_INTERFACE
MTL_ONHAND_QUANTITIES_BACKUP
MTL_ONHAND_QUANTITY_TEMP
MTL_ORG_REPORT_TEMP
MTL_PAC_ACTUAL_COST_DETAILS
MTL_PAC_ACTUAL_COST_DETAIL_EFC
MTL_PAC_COST_SUBELEMENTS
MTL_PAC_COST_SUBELEMENTS_EFC
MTL_PAC_TXN_COST_DETAILS
MTL_PAC_TXN_COST_DETAILS_EFC
MTL_PERIOD_CG_SUMMARY
MTL_PERIOD_SUMMARY
MTL_PERIOD_SUMMARY_EFC
MTL_PER_CLOSE_DTLS
MTL_PER_CLOSE_DTLS_EFC
MTL_PHYSICAL_ADJUSTMENTS_EFC
MTL_PHYSICAL_INVENTORIES_EFC
MTL_PHYSICAL_SUBINVENTORIES
MTL_PURGE_HEADER
MTL_QOH_ITEM_TMP
MTL_QOH_LOCATOR_TMP
MTL_QOH_LOT_TMP
MTL_QOH_REV_TMP
MTL_QOH_SUB_TMP
MTL_RELATED_ITEMS_INTERFACE
MTL_REPLENISH_HEADERS_INT
MTL_REPLENISH_LINES_INT
MTL_RESERVATIONS_SN
MTL_RSV_QUANTITIES_TEMP
MTL_RTG_ITEM_REVS_INTERFACE
MTL_SEASONALITY_INDICES
MTL_SECONDARY_LOCS_INTERFACE
MTL_SERIAL_NUMBERS_CLUP
MTL_SERIAL_NUMBERS_INTERFACE
MTL_SERIAL_NUM_INTC_CLUP
MTL_SERIAL_NUM_TEMP_CLUP
MTL_SHORT_CHK_STATEMENTS
MTL_SHORT_CHK_TEMP
MTL_SO_RMA_RECEIPTS
MTL_SUMMARY_TEMP
MTL_SYSTEM_ITEMS_B_EFC
MTL_SYSTEM_ITEMS_INTERFACE
MTL_TRANSACTION_ACCOUNTS_EFC
MTL_TRANSACTION_LOTS_INFC_CLUP
MTL_TRANSACTION_LOTS_INTERFACE
MTL_TRANSACTION_LOTS_TEMP_CLUP
MTL_TRANSACTION_LOT_NUM_CLUP
MTL_TRANSFER_TEMP
MTL_UNIT_TXNS_CLUP
MTL_UPDATE_RECORDS_TEMP
MTL_USER_DEMAND
MTL_USER_SUPPLY
MTL_U_DEMAND_SN
MTL_U_SUPPLY_SN
RSV_TEMP
TOTAL_PROD

Tables In HR

2008-01-09T08:46:00.003-08:00

AME_ACTIONS
AME_ACTION_TYPES
AME_ACTION_TYPE_USAGES
AME_APPROVALS_HISTORY
AME_APPROVAL_GROUPS
AME_APPROVAL_GROUP_ITEMS
AME_APPROVAL_GROUP_MEMBERS
AME_ATTRIBUTES
AME_ATTRIBUTE_USAGES
AME_CALLING_APPS
AME_CONDITIONS
AME_CONDITION_USAGES
AME_CONFIG_VARS
AME_EXCEPTIONS_LOG
AME_FIELD_HELP
AME_HELP
AME_MANDATORY_ATTRIBUTES
AME_RULES
AME_RULE_USAGES
AME_STRING_VALUES
AME_TEMP_DELETIONS
AME_TEMP_HANDLER_STATES
AME_TEMP_INSERTIONS
AME_TEMP_OLD_APPROVER_LISTS
AME_TEMP_TRANSACTIONS
AME_TEMP_TRANS_LOCKS
AME_TEST_TRANS_ATT_VALUES
BEN_BENEFICIARIES_F
BEN_BENEFIT_CLASSIFICATIONS
BEN_BENEFIT_CONTRIBUTIONS_F
BEN_COVERED_DEPENDENTS_F
BEN_VALID_DEPENDENT_TYPES
DT_COLUMN_PROMPTS_TL
DT_DATE_PROMPTS_TL
DT_TITLE_PROMPTS_TL
FF_ARCHIVE_ITEMS
FF_ARCHIVE_ITEM_CONTEXTS
FF_COMPILED_INFO_F
FF_CONTEXTS
FF_DATABASE_ITEMS
FF_FDI_USAGES_F
FF_FORMULAS_F
FF_FORMULA_TYPES
FF_FTYPE_CONTEXT_USAGES
FF_FUNCTIONS
FF_FUNCTION_CONTEXT_USAGES
FF_FUNCTION_PARAMETERS
FF_GLOBALS_F
FF_HARNESS
FF_LOOKUPS
FF_QP_REPORTS
FF_ROUTES
FF_ROUTE_CONTEXT_USAGES
FF_ROUTE_PARAMETERS
FF_ROUTE_PARAMETER_VALUES
FF_USER_ENTITIES
GHR_BREAKDOWN_CRITERIA
GHR_BREAKDOWN_RESULTS
GHR_COMPLAINTS2
GHR_COMPL_ADRS
GHR_COMPL_AGENCY_APPEALS
GHR_COMPL_APPEALS
GHR_COMPL_BASES
GHR_COMPL_CA_DETAILS
GHR_COMPL_CA_HEADERS
GHR_COMPL_CLAIMS
GHR_COMPL_INCIDENTS
GHR_COMPL_PEOPLE
GHR_CPDF_TEMP
GHR_DUAL_ACTIONS
GHR_DUAL_PROC_METHODS
GHR_DUTY_STATIONS
GHR_DUTY_STATIONS_F
GHR_EVENTS
GHR_EVENT_HISTORY
GHR_FAMILIES
GHR_GROUPBOXES
GHR_GROUPBOX_USERS
GHR_INTERFACE
GHR_LOCALITY_PAY_AREAS
GHR_LOCALITY_PAY_AREAS_F
GHR_MASS_ACTIONS_PREVIEW
GHR_MASS_AWARDS
GHR_MASS_AWARD_CRITERIA_COLS
GHR_MASS_AWARD_CRITERIA_VALS
GHR_MASS_REALIGNMENT
GHR_MASS_SALARIES
GHR_MASS_SALARY_CRITERIA
GHR_MASS_TRANSFERS
GHR_MASS_TRANSFER_CRITERIA
GHR_NATURE_OF_ACTIONS
GHR_NOAC_LAS
GHR_NOAC_REMARKS
GHR_NOA_FAMILIES
GHR_NOA_FAM_PROC_METHODS
GHR_PAYROLL
GHR_PAY_PLANS
GHR_PAY_PLAN_WAITING_PERIODS
GHR_PA_DATA_FIELDS
GHR_PA_HISTORY
GHR_PA_REMARKS
GHR_PA_REQUESTS
GHR_PA_REQUEST_EI_SHADOW
GHR_PA_REQUEST_EXTRA_INFO
GHR_PA_REQUEST_INFO_TYPES
GHR_PA_REQUEST_SHADOW
GHR_PA_ROUTING_HISTORY
GHR_PD_CLASSIFICATIONS
GHR_PD_ROUTING_HISTORY
GHR_PLAN_SERVICE_AREAS_F
GHR_POIS
GHR_POSITION_DESCRIPTIONS
GHR_PREMIUM_PAY_INDICATORS
GHR_PROCESS_LOG
GHR_REMARKS
GHR_RESTRICTED_PROC_METHODS
GHR_RIF_CRITERIA
GHR_RIF_REGISTERS
GHR_ROUTING_GROUPS
GHR_ROUTING_LISTS
GHR_ROUTING_LIST_MEMBERS
HR_ALL_ORGANIZATION_UNITS
HR_ALL_ORGANIZATION_UNITS_TL
HR_ALL_POSITIONS_F
HR_ALL_POSITIONS_F_TL
HR_API_BATCH_MESSAGE_LINES
HR_API_HOOKS
HR_API_HOOK_CALLS
HR_API_MODULES
HR_API_TRANSACTIONS
HR_API_TRANSACTION_STEPS
HR_API_TRANSACTION_VALUES
HR_API_USER_HOOK_REPORTS
HR_APPLICATION_OWNERSHIPS
HR_ASSIGNMENT_SETS
HR_ASSIGNMENT_SET_AMENDMENTS
HR_ASSIGNMENT_SET_CRITERIA
HR_ATH_ELIGIBLE_TBLS
HR_ATH_ENROLL_TBLS
HR_ATH_VARIABLEMAP
HR_AUDITS
HR_AUDIT_COLUMNS
HR_AUTHORIA_MAPPINGS
HR_CALENDARS
HR_CALENDAR_USAGES
HR_CANVAS_PROPERTIES
HR_COMMENTS
HR_COMPARISON_ROWS
HR_DE_LIABILITY_PREMIUMS_F
HR_DE_ORGANIZATION_LINKS
HR_DE_SOC_INS_CONTR_LVLS_F
HR_DM_APPLICATION_GROUPS
HR_DM_COLUMN_DEFINITIONS
HR_DM_DATABASES
HR_DM_DT_DELETES
HR_DM_EXP_IMPS
HR_DM_GROUPS
HR_DM_HIERARCHIES
HR_DM_LOADER_PARAMS
HR_DM_LOADER_PHASE_ITEMS
HR_DM_MIGRATIONS
HR_DM_MIGRATION_RANGES
HR_DM_MIGRATION_REQUESTS
HR_DM_PHASES
HR_DM_PHASE_ITEMS
HR_DM_PHASE_RULES
HR_DM_RESOLVE_PKS
HR_DM_SEQUENCE_DEFINITIONS
HR_DM_SEQUENCE_HISTORIES
HR_DM_SEQUENCE_RANGES
HR_DM_TABLES
HR_DM_TABLE_GROUPINGS
HR_DU_COLUMN_MAPPINGS
HR_DU_DESCRIPTORS
HR_DU_ERRORS
HR_DU_MODULES
HR_DU_UPLOADS
HR_DU_UPLOAD_HEADERS
HR_DU_UPLOAD_LINES
HR_EFC_ACTIONS
HR_EFC_CURRENCY_HISTORIES
HR_EFC_PROCESS_COMPONENTS
HR_EFC_ROUNDING_ERRORS
HR_EFC_WORKERS
HR_EFC_WORKER_AUDITS
HR_EXCEPTION_USAGES
HR_FORM_CANVASES_B
HR_FORM_CANVASES_TL
HR_FORM_DATA_GROUPS_B
HR_FORM_DATA_GROUPS_TL
HR_FORM_DATA_GROUP_ITEMS
HR_FORM_ITEMS_B
HR_FORM_ITEMS_TL
HR_FORM_PROPERTIES
HR_FORM_TAB_PAGES_B
HR_FORM_TAB_PAGES_TL
HR_FORM_TAB_STACKED_CANVASES
HR_FORM_TEMPLATES_B
HR_FORM_TEMPLATES_TL
HR_FORM_WINDOWS_B
HR_FORM_WINDOWS_TL
HR_H2PI_ADDRESSES
HR_H2PI_ASSIGNMENTS
HR_H2PI_BG_AND_GRE
HR_H2PI_CITY_TAX_RULES
HR_H2PI_COST_ALLOCATIONS
HR_H2PI_COUNTY_TAX_RULES
HR_H2PI_DATA_FEED_HIST
HR_H2PI_ELEMENT_ENTRIES
HR_H2PI_ELEMENT_ENTRY_VALUES
HR_H2PI_ELEMENT_LINKS
HR_H2PI_ELEMENT_NAMES
HR_H2PI_ELEMENT_TYPES
HR_H2PI_EMPLOYEES
HR_H2PI_FEDERAL_TAX_RULES
HR_H2PI_HR_ORGANIZATIONS
HR_H2PI_ID_MAPPING
HR_H2PI_INPUT_VALUES
HR_H2PI_LOCATIONS
HR_H2PI_MESSAGE_LINES
HR_H2PI_ORGANIZATION_CLASS
HR_H2PI_ORGANIZATION_INFO
HR_H2PI_ORG_PAYMENT_METHODS
HR_H2PI_PATCH_STATUS
HR_H2PI_PAYMENT_METHODS
HR_H2PI_PAYROLLS
HR_H2PI_PAY_BASES
HR_H2PI_PERIODS_OF_SERVICE
HR_H2PI_SALARIES
HR_H2PI_STATE_TAX_RULES
HR_H2PI_US_CITY_NAMES
HR_H2PI_US_MODIFIED_GEOCODES
HR_INCOMPATIBILITY_RULES
HR_ITEM_CONTEXTS
HR_ITEM_PROPERTIES_B
HR_ITEM_PROPERTIES_TL
HR_JP_PARAMETERS
HR_KI_EXT_APPLICATIONS
HR_KI_SESSIONS
HR_LEGISLATION_INSTALLATIONS
HR_LEGISLATION_SUBGROUPS
HR_LOCATIONS_ALL
HR_LOCATIONS_ALL_TL
HR_LOCATION_EXTRA_INFO
HR_LOCATION_INFO_TYPES
HR_NAVIGATION_CONTEXT_RULES
HR_NAVIGATION_CONTEXT_RULES_T
HR_NAVIGATION_NODES
HR_NAVIGATION_NODE_USAGES
HR_NAVIGATION_NODE_USAGES_TEMP
HR_NAVIGATION_PATHS
HR_NAVIGATION_PATHS_TEMP
HR_NAVIGATION_PATHS_TL
HR_NAVIGATION_UNITS
HR_NAVIGATION_UNITS_TEMP
HR_NAVIGATION_UNITS_TL
HR_NAV_UNIT_GLOBAL_USAGES
HR_ORGANIZATION_INFORMATION
HR_ORGANIZATION_INFORMATIO_EFC
HR_ORG_INFORMATION_TYPES
HR_ORG_INFORMATION_TYPES_TL
HR_ORG_INFO_TYPES_BY_CLASS
HR_OWNER_DEFINITIONS
HR_PATTERNS
HR_PATTERN_BITS
HR_PATTERN_CONSTRUCTIONS
HR_PATTERN_EXCEPTIONS
HR_PATTERN_PURPOSES
HR_PATTERN_PURPOSE_USAGES
HR_PTL_SUMMARY_DATA
HR_PUMP_BATCH_EXCEPTIONS
HR_PUMP_BATCH_HEADERS
HR_PUMP_BATCH_LINES
HR_PUMP_BATCH_LINE_USER_KEYS
HR_PUMP_DEFAULT_EXCEPTIONS
HR_PUMP_MAPPING_PACKAGES
HR_PUMP_MODULE_PARAMETERS
HR_PUMP_RANGES
HR_PUMP_REQUESTS
HR_PURGE_PARTIES_GT
HR_QUESTIONNAIRES
HR_QUEST_ANSWERS
HR_QUEST_ANSWER_VALUES
HR_QUEST_FIELDS
HR_REPORT_LOOKUPS
HR_SOFT_CODING_KEYFLEX
HR_SOURCE_FORM_TEMPLATES
HR_STU_EXCEPTIONS
HR_STU_HISTORY
HR_SUMMARY
HR_SUMMARY_EFC
HR_S_APPLICATION_OWNERSHIPS
HR_S_ASSIGNMENT_INFO_TYPES
HR_S_ASSIGNMENT_STATUS_TYPES
HR_S_BALANCE_CATEGORIES_F
HR_S_BALANCE_CLASSIFICATIONS
HR_S_BALANCE_DIMENSIONS
HR_S_BALANCE_FEEDS_F
HR_S_BALANCE_TYPES
HR_S_BENEFIT_CLASSIFICATIONS
HR_S_COBRA_QFYING_EVENTS_F
HR_S_COMMON_LOOKUPS
HR_S_COMMON_LOOKUP_TYPES
HR_S_CONTEXTS
HR_S_DATABASE_ITEMS
HR_S_DEFINED_BALANCES
HR_S_DIMENSION_ROUTES
HR_S_ELEMENT_CLASSIFICATIONS
HR_S_ELEMENT_SETS
HR_S_ELEMENT_TYPES_F
HR_S_ELEMENT_TYPE_RULES
HR_S_ELE_CLASSN_RULES
HR_S_FORMULAS_F
HR_S_FORMULA_RESULT_RULES_F
HR_S_FORMULA_TYPES
HR_S_FTYPE_CONTEXT_USAGES
HR_S_FUNCTIONS
HR_S_FUNCTION_CONTEXT_USAGES
HR_S_FUNCTION_PARAMETERS
HR_S_GLOBALS_F
HR_S_HISTORY
HR_S_INPUT_VALUES_F
HR_S_LEGISLATION_RULES
HR_S_LEGISLATION_SUBGROUPS
HR_S_LEGISLATIVE_FIELD_INFO
HR_S_LOOKUP_TYPE_USAGES
HR_S_MAGNETIC_BLOCKS
HR_S_MAGNETIC_RECORDS
HR_S_MONETARY_UNITS
HR_S_ORG_INFORMATION_TYPES
HR_S_ORG_INFO_TYPES_BY_CLASS
HR_S_PAYMENT_TYPES
HR_S_QP_REPORTS
HR_S_REPORT_FORMAT_ITEMS_F
HR_S_REPORT_FORMAT_MAPPINGS_F
HR_S_REPORT_LOOKUPS
HR_S_ROUTES
HR_S_ROUTE_CONTEXT_USAGES
HR_S_ROUTE_PARAMETERS
HR_S_ROUTE_PARAMETER_VALUES
HR_S_STATE_RULES
HR_S_STATUS_PROCESSING_RULES_F
HR_S_SUB_CLASSN_RULES_F
HR_S_TAXABILITY_RULES
HR_S_TAXABILITY_RULES_DATES
HR_S_USER_COLUMNS
HR_S_USER_COLUMN_INSTANCES_F
HR_S_USER_ENTITIES
HR_S_USER_ROWS_F
HR_S_USER_TABLES
HR_S_US_CITY_GEOCODES
HR_S_US_CITY_NAMES
HR_S_US_CITY_SCHOOL_DSTS
HR_S_US_CITY_TAX_INFO_F
HR_S_US_COUNTY_TAX_INFO_F
HR_S_US_FEDERAL_TAX_INFO_F
HR_S_US_GARN_EXEMPTION_RULES_F
HR_S_US_GARN_FEE_RULES_F
HR_S_US_GARN_LIMIT_RULES_F
HR_S_US_STATE_TAX_INFO_F
HR_S_US_ZIP_CODES
HR_S_VALID_DEPENDENT_TYPES
HR_S_WC_STATE_SURCHARGES
HR_TAB_PAGE_PROPERTIES_B
HR_TAB_PAGE_PROPERTIES_TL
HR_TEMPLATE_CANVASES_B
HR_TEMPLATE_DATA_GROUPS
HR_TEMPLATE_ITEMS_B
HR_TEMPLATE_ITEM_CONTEXTS_B
HR_TEMPLATE_ITEM_CONTEXT_PAGES
HR_TEMPLATE_ITEM_TAB_PAGES
HR_TEMPLATE_TAB_PAGES_B
HR_TEMPLATE_WINDOWS_B
HR_TIPS
HR_WINDOW_PROPERTIES_B
HR_WINDOW_PROPERTIES_TL
HR_WIP_LOCKS
HR_WIP_TRANSACTIONS
HR_WORKFLOWS
HR_WORKFLOWS_TEMP
HR_WORKING_PERSON_LISTS
IRC_ALL_RECRUITING_SITES
IRC_ASSIGNMENT_STATUSES
IRC_DEFAULT_POSTINGS
IRC_DEFAULT_POSTINGS_TL
IRC_DOCUMENTS
IRC_JOB_BASKET_ITEMS
IRC_NOTIFICATION_PREFERENCES
IRC_POSTING_CONTENTS
IRC_POSTING_CONTENTS_TL
IRC_REC_TEAM_MEMBERS
IRC_REFERENCES
IRC_SEARCH_CRITERIA
IRC_VACANCY_CONSIDERATIONS
IRC_VAC_ALLOWED_STATUS_TYPES
IRC_VARIABLE_COMP_ELEMENTS
PAY_ACCRUAL_BANDS
PAY_ACCRUAL_PLANS
PAY_ACTION_CLASSIFICATIONS
PAY_ACTION_CONTEXTS
PAY_ACTION_INFORMATION
PAY_ACTION_INTERLOCKS
PAY_ACTION_PARAMETERS_OLD
PAY_ACTION_PARAMETER_GROUPS
PAY_ACTION_PARAMETER_VALUES
PAY_AC_VENDOR_MAPPINGS
PAY_ALL_PAYROLLS_F
PAY_ASSIGNMENT_ACTIONS
PAY_ASSIGNMENT_LATEST_BALANCES
PAY_ASSIGNMENT_LINK_USAGES_F
PAY_AU_MODULES
PAY_AU_MODULE_PARAMETERS
PAY_AU_MODULE_TYPES
PAY_AU_PROCESSES
PAY_AU_PROCESS_MODULES
PAY_AU_PROCESS_PARAMETERS
PAY_BACKPAY_RULES
PAY_BACKPAY_SETS
PAY_BALANCE_ATTRIBUTES
PAY_BALANCE_BATCH_HEADERS
PAY_BALANCE_BATCH_LINES
PAY_BALANCE_CATEGORIES_F
PAY_BALANCE_CLASSIFICATIONS
PAY_BALANCE_CONTEXT_VALUES
PAY_BALANCE_DIMENSIONS
PAY_BALANCE_FEEDS_F
PAY_BALANCE_SETS
PAY_BALANCE_SET_MEMBERS
PAY_BALANCE_TYPES
PAY_BALANCE_TYPES_EFC
PAY_BALANCE_TYPES_TL
PAY_BALANCE_VALIDATION
PAY_BAL_ATTRIBUTE_DEFAULTS
PAY_BAL_ATTRIBUTE_DEFINITIONS
PAY_BANK_BRANCHES
PAY_BATCH_CONTROL_TOTALS
PAY_BATCH_HEADERS
PAY_BATCH_LINES
PAY_CALENDARS
PAY_CA_DISPLAY_CITIES
PAY_CA_EMP_FED_TAX_INFO_F
PAY_CA_EMP_PROV_TAX_INFO_F
PAY_CA_FILE_CREATION_NUMBERS
PAY_CA_LEGISLATION_INFO
PAY_CA_PMED_ACCOUNTS
PAY_CE_RECONCILED_PAYMENTS
PAY_COIN_ANAL_ELEMENTS
PAY_CONSOLIDATION_SETS
PAY_COSTS
PAY_COSTS_EFC
PAY_COST_ALLOCATIONS_F
PAY_COST_ALLOCATION_KEYFLEX
PAY_CUSTOMIZED_RESTRICTIONS
PAY_CUSTOM_RESTRICTIONS_TL
PAY_DATED_TABLES
PAY_DATETRACKED_EVENTS
PAY_DEFINED_BALANCES
PAY_DIMENSION_ROUTES
PAY_ELEMENT_CLASSIFICATIONS
PAY_ELEMENT_CLASSIFICATIONS_TL
PAY_ELEMENT_ENTRIES_F
PAY_ELEMENT_ENTRY_VALUES_F
PAY_ELEMENT_ENTRY_VALUES_F_EFC
PAY_ELEMENT_LINKS_F
PAY_ELEMENT_SETS
PAY_ELEMENT_SPAN_USAGES
PAY_ELEMENT_TEMPLATES
PAY_ELEMENT_TYPES_F
PAY_ELEMENT_TYPES_F_EFC
PAY_ELEMENT_TYPES_F_TL
PAY_ELEMENT_TYPE_EXTRA_INFO
PAY_ELEMENT_TYPE_INFO_TYPES
PAY_ELEMENT_TYPE_RULES
PAY_ELEMENT_TYPE_USAGES_F
PAY_ELE_CLASSIFICATION_RULES
PAY_ELE_PAYROLL_FREQ_RULES
PAY_ENTRY_PROCESS_DETAILS
PAY_EVENT_GROUPS
PAY_EVENT_PROCEDURES
PAY_EVENT_QUALIFIERS_F
PAY_EVENT_UPDATES
PAY_EVENT_VALUE_CHANGES_F
PAY_EXCHANGE_RATES_F
PAY_EXTERNAL_ACCOUNTS
PAY_FORMULA_RESULT_RULES_F
PAY_FREQ_RULE_PERIODS
PAY_FR_CONTRIBUTION_USAGES
PAY_FUNCTIONAL_AREAS
PAY_FUNCTIONAL_TRIGGERS
PAY_FUNCTIONAL_USAGES
PAY_GB_SOY_OUTPUTS
PAY_GB_TAX_CODE_INTERFACE
PAY_GB_YEAR_END_ASSIGNMENTS
PAY_GB_YEAR_END_PAYROLLS
PAY_GB_YEAR_END_VALUES
PAY_GEOCODES
PAY_GL_INTERFACE
PAY_GRADE_RULES_F
PAY_GRADE_RULES_F_EFC
PAY_GROSSUP_BAL_EXCLUSIONS
PAY_IE_PAYE_DETAILS_F
PAY_IE_PRSI_DETAILS_F
PAY_IE_SOCIAL_BENEFITS_F
PAY_IE_TAX_BODY_INTERFACE
PAY_IE_TAX_ERROR
PAY_IE_TAX_HEADER_INTERFACE
PAY_IE_TAX_TRAILER_INTERFACE
PAY_INPUT_VALUES_F
PAY_INPUT_VALUES_F_EFC
PAY_INPUT_VALUES_F_TL
PAY_ITERATIVE_RULES_F
PAY_JOB_WC_CODE_USAGES
PAY_JP_BANKS
PAY_JP_BANK_BRANCHES
PAY_JP_PRE_TAX
PAY_JP_SWOT_NUMBERS
PAY_LEGISLATION_CONTEXTS
PAY_LEGISLATION_RULES
PAY_LEGISLATIVE_FIELD_INFO
PAY_LEG_SETUP_DEFAULTS
PAY_LINK_INPUT_VALUES_F
PAY_LINK_INPUT_VALUES_F_EFC
PAY_MAGNETIC_BLOCKS
PAY_MAGNETIC_RECORDS
PAY_MESSAGE_LINES
PAY_MONETARY_UNITS
PAY_MONETARY_UNITS_TL
PAY_MONITOR_BALANCE_RETRIEVALS
PAY_NET_CALCULATION_RULES
PAY_ORG_PAYMENT_METHODS_F
PAY_ORG_PAYMENT_METHODS_F_EFC
PAY_ORG_PAYMENT_METHODS_F_TL
PAY_ORG_PAY_METHOD_USAGES_F
PAY_PATCH_STATUS
PAY_PAYMENT_TYPES
PAY_PAYMENT_TYPES_TL
PAY_PAYROLL_ACTIONS
PAY_PAYROLL_ACTIONS_EFC
PAY_PAYROLL_GL_FLEX_MAPS
PAY_PAYROLL_LIST
PAY_PDT_BATCH_CHECKS_OLD
PAY_PDT_BATCH_EXCEPTIONS_OLD
PAY_PDT_BATCH_HEADERS_OLD
PAY_PDT_BATCH_LINES_OLD
PAY_PDT_LINE_ERRORS_OLD
PAY_PEOPLE_GROUPS
PAY_PERSONAL_PAYMENT_METHODS_F
PAY_PERSONAL_PAYMENT_METHO_EFC
PAY_PERSON_LATEST_BALANCES
PAY_POPULATION_RANGES
PAY_PRE_PAYMENTS
PAY_PRE_PAYMENTS_EFC
PAY_PROCESS_EVENTS
PAY_PROCESS_GROUPS
PAY_PROCESS_GROUP_ACTIONS
PAY_PSS_TRANSACTION_STEPS
PAY_PURGE_ACTION_TYPES
PAY_PURGE_ROLLUP_BALANCES
PAY_QUICKPAY_INCLUSIONS
PAY_RATES
PAY_RECORDED_REQUESTS
PAY_REPORT_FORMAT_ITEMS_F
PAY_REPORT_FORMAT_MAPPINGS_F
PAY_REPORT_TOTALS
PAY_RESTRICTION_PARAMETERS
PAY_RESTRICTION_VALUES
PAY_RETRO_ASSIGNMENTS
PAY_RETRO_COMPONENTS
PAY_RETRO_COMPONENT_USAGES
PAY_RETRO_DEFINITIONS
PAY_RETRO_DEFN_COMPONENTS
PAY_RETRO_ENTRIES
PAY_RETRO_NOTIF_REPORTS
PAY_ROUTE_TO_DESCR_FLEXS
PAY_RUN_BALANCES
PAY_RUN_RESULTS
PAY_RUN_RESULT_VALUES
PAY_RUN_RESULT_VALUES_EFC
PAY_RUN_TYPES_F
PAY_RUN_TYPES_F_TL
PAY_RUN_TYPE_ORG_METHODS_F
PAY_RUN_TYPE_ORG_METHODS_F_EFC
PAY_RUN_TYPE_USAGES_F
PAY_SECURITY_PAYROLLS
PAY_SHADOW_BALANCE_CLASSI
PAY_SHADOW_BALANCE_FEEDS
PAY_SHADOW_BALANCE_TYPES
PAY_SHADOW_DEFINED_BALANCES
PAY_SHADOW_ELEMENT_TYPES
PAY_SHADOW_ELE_TYPE_USAGES
PAY_SHADOW_FORMULAS
PAY_SHADOW_FORMULA_RULES
PAY_SHADOW_GU_BAL_EXCLUSIONS
PAY_SHADOW_INPUT_VALUES
PAY_SHADOW_ITERATIVE_RULES
PAY_SHADOW_SUB_CLASSI_RULES
PAY_STATE_RULES
PAY_STATUS_PROCESSING_RULES_F
PAY_STAT_TRANS_AUDIT
PAY_SUB_CLASSIFICATION_RULES_F
PAY_TAXABILITY_RULES
PAY_TAXABILITY_RULES_DATES
PAY_TEMPLATE_CORE_OBJECTS
PAY_TEMPLATE_EXCLUSION_RULES
PAY_TEMP_BALANCE_ADJUSTMENTS
PAY_TIME_DEFINITIONS
PAY_TIME_SPANS
PAY_TRIGGER_COMPONENTS
PAY_TRIGGER_DECLARATIONS
PAY_TRIGGER_EVENTS
PAY_TRIGGER_INITIALISATIONS
PAY_TRIGGER_PARAMETERS
PAY_TRIGGER_SUPPORT
PAY_USER_COLUMNS
PAY_USER_COLUMN_INSTANCES_F
PAY_USER_ROWS_F
PAY_USER_TABLES
PAY_US_ASG_REPORTING
PAY_US_CITIES
PAY_US_CITY_GEOCODES
PAY_US_CITY_NAMES
PAY_US_CITY_SCHOOL_DSTS
PAY_US_CITY_TAX_INFO_F
PAY_US_CONTRIBUTION_HISTORY
PAY_US_COUNTIES
PAY_US_COUNTY_SCHOOL_DSTS
PAY_US_COUNTY_TAX_INFO_F
PAY_US_EMP_CITY_TAX_RULES_F
PAY_US_EMP_COUNTY_TAX_RULES_F
PAY_US_EMP_FED_TAX_RULES_F
PAY_US_EMP_STATE_TAX_RULES_F
PAY_US_FEDERAL_TAX_INFO_F
PAY_US_GARN_ARREARS_RULES_F
PAY_US_GARN_EXEMPTION_RULES_F
PAY_US_GARN_FEE_RULES_F
PAY_US_GARN_LIMIT_RULES_F
PAY_US_GEO_UPDATE
PAY_US_MODIFIED_GEOCODES
PAY_US_RPT_TOTALS
PAY_US_SCHOOL_DSTS_TAX_INFO_F
PAY_US_STATES
PAY_US_STATE_TAX_INFO_F
PAY_US_TAX_BALANCES
PAY_US_TAX_REPORT_BALANCES
PAY_US_TAX_REPORT_DIMENSIONS
PAY_US_TAX_TYPES
PAY_US_ZIP_CODES
PAY_WCI_ACCOUNTS
PAY_WCI_OCCUPATIONS
PAY_WCI_RATES
PAY_WC_FUNDS
PAY_WC_RATES
PAY_WC_STATE_SURCHARGES
PAY_ZA_ACB_USER_GEN_NOS
PAY_ZA_BRANCH_CDV_DETAILS
PAY_ZA_CDV_PARAMETERS
PAY_ZA_IRP5_BAL_CODES
PAY_ZA_TAXREG_BAL_TEMP
PAY_ZA_TAX_REGISTERS
PAY_ZA_TAX_TRACES
PAY_ZA_TEMP_BRANCH_DETAILS
PAY_ZA_TYS_PROCESSES
PER_ABSENCE_ATTENDANCES
PER_ABSENCE_ATTENDANCES_EFC
PER_ABSENCE_ATTENDANCE_TYPES
PER_ABS_ATTENDANCE_REASONS
PER_ADDRESSES
PER_ALL_ASSIGNMENTS_F
PER_ALL_PEOPLE_F
PER_ALL_POSITIONS
PER_ALL_VACANCIES
PER_ANALYSIS_CRITERIA
PER_APPLICATIONS
PER_APPRAISALS
PER_APPRAISAL_TEMPLATES
PER_ASSESSMENTS
PER_ASSESSMENT_GROUPS
PER_ASSESSMENT_TYPES
PER_ASSIGNMENT_BUDGET_VALUES_F
PER_ASSIGNMENT_BUDGET_VALU_EFC
PER_ASSIGNMENT_EXTRA_INFO
PER_ASSIGNMENT_EXTRA_INFO_EFC
PER_ASSIGNMENT_INFO_TYPES
PER_ASSIGNMENT_INFO_TYPES_TL
PER_ASSIGNMENT_STATUS_TYPES
PER_ASSIGNMENT_STATUS_TYPES_TL
PER_ASSIGN_PROPOSAL_ANSWERS
PER_ASS_STATUS_TYPE_AMENDS
PER_ASS_STATUS_TYPE_AMENDS_TL
PER_BF_BALANCE_AMOUNTS
PER_BF_BALANCE_AMOUNTS_EFC
PER_BF_BALANCE_TYPES
PER_BF_BALANCE_TYPES_EFC
PER_BF_PAYMENT_DETAILS
PER_BF_PAYMENT_DETAILS_EFC
PER_BF_PAYROLL_RUNS
PER_BF_PROCESSED_ASSIGNMENTS
PER_BOOKINGS
PER_BUDGETS
PER_BUDGET_ELEMENTS
PER_BUDGET_VALUES
PER_BUDGET_VALUES_EFC
PER_BUDGET_VERSIONS
PER_CAGR_APIS
PER_CAGR_APIS_TL
PER_CAGR_API_PARAMETERS
PER_CAGR_API_PARAMETERS_TL
PER_CAGR_ENTITLEMENTS
PER_CAGR_ENTITLEMENT_ITEMS
PER_CAGR_ENTITLEMENT_ITEMS_TL
PER_CAGR_ENTITLEMENT_LINES_F
PER_CAGR_ENTITLEMENT_RESULTS
PER_CAGR_GRADES
PER_CAGR_GRADES_DEF
PER_CAGR_GRADE_STRUCTURES
PER_CAGR_LOG
PER_CAGR_REQUESTS
PER_CAGR_RETAINED_RIGHTS
PER_CALENDAR_ENTRIES
PER_CAL_ENTRY_VALUES
PER_CAREER_PATHS
PER_CAREER_PATH_ELEMENTS
PER_CA_EE_REPORT_LINES
PER_CHECKLIST_ITEMS
PER_COBRA_COVERAGE_BENEFITS_F
PER_COBRA_COVERAGE_PERIODS
PER_COBRA_COVERAGE_STATUSES
PER_COBRA_COV_ENROLLMENTS
PER_COBRA_DEPENDENTS_F
PER_COBRA_QFYING_EVENTS_F
PER_COLLECTIVE_AGREEMENTS
PER_COMPETENCES
PER_COMPETENCES_TL
PER_COMPETENCE_DEFINITIONS
PER_COMPETENCE_ELEMENTS
PER_CONTACT_EXTRA_INFO_F
PER_CONTACT_INFO_TYPES
PER_CONTACT_INFO_TYPES_TL
PER_CONTACT_RELATIONSHIPS
PER_CONTRACTS_F
PER_CPN_DATA_UPGRADE
PER_DEPLOYMENT_FACTORS
PER_DISABILITIES_F
PER_ELECTIONS
PER_ELECTION_CANDIDATES
PER_ELECTION_CONSTITUENCYS
PER_EMPDIR_ASSIGNMENTS
PER_EMPDIR_IMAGES
PER_EMPDIR_JOBS
PER_EMPDIR_LOCATIONS
PER_EMPDIR_LOCATIONS_TL
PER_EMPDIR_ORGANIZATIONS
PER_EMPDIR_PEOPLE
PER_EMPDIR_PHONES
PER_EMPDIR_POSITIONS
PER_ESTABLISHMENTS
PER_ESTABLISHMENT_ATTENDANCES
PER_EVENTS
PER_FORM_FUNCTIONS
PER_GENERIC_REPORT_OUTPUT
PER_GEN_HIERARCHY
PER_GEN_HIERARCHY_NODES
PER_GEN_HIERARCHY_VERSIONS
PER_GEN_HIER_NODE_TYPES
PER_GRADES
PER_GRADES_TL
PER_GRADE_DEFINITIONS
PER_GRADE_SPINES_F
PER_HTML_TOOLKIT_REC_TYPES
PER_IMAGES
PER_INFO_TYPE_SECURITY
PER_JOBS
PER_JOBS_TL
PER_JOB_DEFINITIONS
PER_JOB_EVALUATIONS
PER_JOB_EXTRA_INFO
PER_JOB_GROUPS
PER_JOB_INFO_TYPES
PER_JOB_REQUIREMENTS
PER_JP_ADDRESS_LOOKUPS
PER_JP_BANK_LOOKUPS_ALL
PER_JP_POSTAL_CODES
PER_JP_SCHOOL_LOOKUPS
PER_KR_ADDRESSES
PER_KR_GRADES
PER_KR_GRADE_AMOUNT_F
PER_KR_G_POINTS
PER_KR_G_POINT_AMOUNT_F
PER_LETTER_GEN_STATUSES
PER_LETTER_REQUESTS
PER_LETTER_REQUEST_LINES
PER_LETTER_TYPES
PER_MASS_MOVES
PER_MEDICAL_ASSESSMENTS
PER_MM_ASSIGNMENTS
PER_MM_JOB_REQUIREMENTS
PER_MM_POSITIONS
PER_MM_VALID_GRADES
PER_NL_ABSENCE_ACTIONS
PER_NL_ABSENCE_CHANGES
PER_NL_ASG_SCL_UPGRADE
PER_NUMBER_GENERATION_CONTROLS
PER_OBJECTIVES
PER_ORGANIZATION_LIST
PER_ORGANIZATION_STRUCTURES
PER_ORG_HRCHY_SUMMARY
PER_ORG_STRUCTURE_ELEMENTS
PER_ORG_STRUCTURE_VERSIONS
PER_PARENT_SPINES
PER_PARTICIPANTS
PER_PAY_BASES
PER_PAY_PROPOSALS
PER_PAY_PROPOSALS_EFC
PER_PAY_PROPOSAL_COMPONENTS
PER_PAY_PROPOSAL_COMPONENT_EFC
PER_PEOPLE_EXTRA_INFO
PER_PEOPLE_INFO_TYPES
PER_PERFORMANCE_RATINGS
PER_PERFORMANCE_REVIEWS
PER_PERIODS_OF_PLACEMENT
PER_PERIODS_OF_SERVICE
PER_PERIODS_OF_SERVICE_EFC
PER_PERSON_ANALYSES
PER_PERSON_DLVRY_METHODS
PER_PERSON_LIST
PER_PERSON_LIST_CHANGES
PER_PERSON_LIST_CHG_ARCH
PER_PERSON_TYPES
PER_PERSON_TYPES_TL
PER_PERSON_TYPE_USAGES_F
PER_PHONES
PER_POSITION_DEFINITIONS
PER_POSITION_EXTRA_INFO
PER_POSITION_INFO_TYPES
PER_POSITION_LIST
PER_POSITION_STRUCTURES
PER_POS_STRUCTURE_ELEMENTS
PER_POS_STRUCTURE_VERSIONS
PER_PREVIOUS_EMPLOYERS
PER_PREVIOUS_JOBS
PER_PREVIOUS_JOB_USAGES
PER_PREV_JOB_EXTRA_INFO
PER_PREV_JOB_INFO_TYPES
PER_PROPOSAL_CATEGORY_MEMBERS
PER_PROPOSAL_CATEGORY_TYPES
PER_PROPOSAL_OFFER_PARAGRAPHS
PER_PROPOSAL_QUESTIONS_ADV
PER_PROPOSAL_QUESTION_MEMBERS
PER_PROPOSAL_QUESTION_TYPES
PER_PROPOSAL_TEMPLATES
PER_QUALIFICATIONS
PER_QUALIFICATIONS_EFC
PER_QUALIFICATIONS_TL
PER_QUALIFICATION_TYPES
PER_QUALIFICATION_TYPES_TL
PER_QUERY_CRITERIA
PER_QUICKPAINT_INVOCATIONS
PER_QUICKPAINT_RESULT_TEXT
PER_RATING_LEVELS
PER_RATING_LEVELS_TL
PER_RATING_SCALES
PER_RATING_SCALES_TL
PER_RECRUITMENT_ACTIVITIES
PER_RECRUITMENT_ACTIVITIES_EFC
PER_RECRUITMENT_ACTIVITY_FOR
PER_REQUISITIONS
PER_ROLES
PER_SALARY_SURVEYS
PER_SALARY_SURVEY_LINES
PER_SALARY_SURVEY_LINES_EFC
PER_SALARY_SURVEY_MAPPINGS
PER_SCHED_COBRA_PAYMENTS
PER_SECONDARY_ASS_STATUSES
PER_SECURITY_ORGANIZATIONS
PER_SECURITY_PROFILES
PER_SEC_PROFILE_ASSIGNMENTS
PER_SHARED_TYPES
PER_SHARED_TYPES_TL
PER_SPECIAL_INFO_TYPES
PER_SPECIAL_INFO_TYPE_USAGES
PER_SPINAL_POINTS
PER_SPINAL_POINT_PLACEMENTS_F
PER_SPINAL_POINT_STEPS_F
PER_STANDARD_HOLIDAYS
PER_STARTUP_PERSON_TYPES_TL
PER_STD_HOLIDAY_ABSENCES
PER_SUBJECTS_TAKEN
PER_SUBJECTS_TAKEN_TL
PER_SUCCESSION_PLANNING
PER_SUITMATCH_COMP
PER_SUITMATCH_PERSON
PER_SUITMATCH_WORKOPPS
PER_TIME_PERIODS
PER_TIME_PERIOD_RULES
PER_TIME_PERIOD_SETS
PER_TIME_PERIOD_TYPES
PER_TIME_PERIOD_TYPES_TL
PER_US_INVAL_ADDRESSES
PER_US_INVAL_LOCATIONS
PER_US_OSHA_NUMBERS
PER_VALID_GRADES
PER_WORK_INCIDENTS
PER_WORK_INCIDENTS_EFC
PER_ZA_AREAS_OF_ASSESSMENT
PER_ZA_ASSESSMENTS
PER_ZA_EMPLOYMENT_EQUITY
PER_ZA_FORMAL_QUALIFICATIONS
PER_ZA_LEARNERSHIP_AGREEMENTS
PER_ZA_QUALIFICATION_TYPES
PER_ZA_TRAINING
PQH_ACCOMMODATIONS_F
PQH_ASSIGN_ACCOMMODATIONS_F
PQH_ATTRIBUTES
PQH_ATTRIBUTES_TL
PQH_ATTRIBUTE_RANGES
PQH_BDGT_CMMTMNT_ELMNTS
PQH_BDGT_POOL_REALLOCTIONS
PQH_BDGT_POOL_REALLOCTIONS_EFC
PQH_BUDGETS
PQH_BUDGETS_EFC
PQH_BUDGET_DETAILS
PQH_BUDGET_DETAILS_EFC
PQH_BUDGET_ELEMENTS
PQH_BUDGET_FUND_SRCS
PQH_BUDGET_GL_FLEX_MAPS
PQH_BUDGET_PERIODS
PQH_BUDGET_PERIODS_EFC
PQH_BUDGET_POOLS
PQH_BUDGET_SETS
PQH_BUDGET_SETS_EFC
PQH_BUDGET_VERSIONS
PQH_BUDGET_VERSIONS_EFC
PQH_COPY_ENTITY_ATTRIBS
PQH_COPY_ENTITY_CONTEXTS
PQH_COPY_ENTITY_FUNCTIONS
PQH_COPY_ENTITY_PREFS
PQH_COPY_ENTITY_RESULTS
PQH_COPY_ENTITY_TXNS
PQH_CORPS_DEFINITIONS
PQH_CORPS_EXTRA_INFO
PQH_DE_CASE_GROUPS
PQH_DE_ENT_MINUTES
PQH_DE_INS_END_REASONS
PQH_DE_LEVEL_CODES
PQH_DE_LEVEL_NUMBERS
PQH_DE_OPERATIONS
PQH_DE_OPERATION_GROUPS
PQH_DE_RESULT_SETS
PQH_DE_TATIGKEIT_DETAILS
PQH_DE_WRKPLC_VLDTNS
PQH_DE_WRKPLC_VLDTN_JOBFTRS
PQH_DE_WRKPLC_VLDTN_JOBS
PQH_DE_WRKPLC_VLDTN_LVLNUMS
PQH_DE_WRKPLC_VLDTN_OPS
PQH_DE_WRKPLC_VLDTN_VERS
PQH_DFLT_BUDGET_ELEMENTS
PQH_DFLT_BUDGET_SETS
PQH_DFLT_FUND_SRCS
PQH_DOCUMENTS_F
PQH_DOCUMENT_ATTRIBUTES_F
PQH_ELEMENT_COMMITMENTS
PQH_ELEMENT_COMMITMENTS_EFC
PQH_FR_VALIDATIONS
PQH_FR_VALIDATION_EVENTS
PQH_FR_VALIDATION_PERIODS
PQH_FYI_NOTIFY
PQH_GL_INTERFACE
PQH_GL_INTERFACE_EFC
PQH_GMS_EXCESS
PQH_PA_WHATIF_RESULTS
PQH_POSITION_TRANSACTIONS
PQH_PROCESS_LOG
PQH_PTE_SHADOW
PQH_PTX_DPF_DF
PQH_PTX_DPF_DF_SHADOW
PQH_PTX_EXTRA_INFO
PQH_PTX_INFO_TYPES
PQH_PTX_SHADOW
PQH_REF_TEMPLATES
PQH_ROLES
PQH_ROLE_EXTRA_INFO
PQH_ROLE_INFO_TYPES
PQH_ROLE_TEMPLATES
PQH_ROUTING_CATEGORIES
PQH_ROUTING_HISTORY
PQH_ROUTING_HIST_ATTRIBS
PQH_ROUTING_LISTS
PQH_ROUTING_LIST_MEMBERS
PQH_RULES
PQH_RULE_ATTRIBUTES
PQH_RULE_SETS
PQH_RULE_SETS_TL
PQH_SITUATIONS
PQH_SPECIAL_ATTRIBUTES
PQH_SS_APPROVAL_HISTORY
PQH_SS_PRINT_DATA
PQH_SS_PRINT_LABEL_TEMP
PQH_SS_STEP_HISTORY
PQH_SS_TRANSACTION_HISTORY
PQH_SS_VALUE_HISTORY
PQH_TABLE_ROUTE
PQH_TABLE_ROUTE_TL
PQH_TEMPLATES
PQH_TEMPLATES_TL
PQH_TEMPLATE_ATTRIBUTES
PQH_TJR_SHADOW
PQH_TRANSACTION_CATEGORIES
PQH_TRANSACTION_CATEGORIES_TL
PQH_TRANSACTION_TEMPLATES
PQH_TXN_CATEGORY_ATTRIBUTES
PQH_TXN_CATEGORY_DOCUMENTS
PQH_TXN_JOB_REQUIREMENTS
PQH_WIZARD_CANVASES
PQH_WORKSHEETS
PQH_WORKSHEET_BDGT_ELMNTS
PQH_WORKSHEET_BUDGET_SETS
PQH_WORKSHEET_BUDGET_SETS_EFC
PQH_WORKSHEET_DETAILS
PQH_WORKSHEET_DETAILS_EFC
PQH_WORKSHEET_FUND_SRCS
PQH_WORKSHEET_PERIODS
PQH_WORKSHEET_PERIODS_EFC
PQP_ALIEN_STATE_TREATIES_F
PQP_ALIEN_TRANSACTION_DATA
PQP_ANALYZED_ALIEN_DATA
PQP_ANALYZED_ALIEN_DETAILS
PQP_ASSIGNMENT_ATTRIBUTES_F
PQP_CONFIGURATION_VALUES
PQP_EXCEPTION_REPORTS
PQP_EXCEPTION_REPORTS_TL
PQP_EXCEPTION_REPORT_GROUPS
PQP_EXCEPTION_REPORT_SUFFIX
PQP_EXTRACT_ATTRIBUTES
PQP_GAP_ABSENCE_PLANS
PQP_GAP_DAILY_ABSENCES
PQP_PENSION_TYPES_F
PQP_SERVICE_HISTORY_PERIODS
PQP_VEHICLE_ALLOCATIONS_F
PQP_VEHICLE_DETAILS
PQP_VEHICLE_DETAILS_EFC
PQP_VEHICLE_REPOSITORY_F
DR$HR_LOCATIONS_N1$I
MDRT_57072$
DR$IRC_DOCUMENTS_CTX$I
DR$IRC_DOCUMENTS_CTX$K
DR$IRC_DOCUMENTS_CTX$R
DR$IRC_DOCUMENTS_CTX$N
PAY_TEMP_OBJECT_ACTIONS
PAY_CHUNK_STATUS
HR_ADI_INTG_RESP
PER_GB_XDO_TEMPLATES
IRC_ALL_RECRUITING_SITES_TL
DR$IRC_DOCUMENTS_CTX1$I
DR$IRC_DOCUMENTS_CTX1$K
DR$IRC_DOCUMENTS_CTX1$R
DR$IRC_DOCUMENTS_CTX1$N
MDRT_5706F$
PAY_GROUP_DEFINITIONS
PAY_OBJECT_GROUPS
PAY_FILE_DETAILS
HR_KI_UI_CONTEXTS
AME_APPROVER_TYPES
AME_APPROVER_TYPE_USAGES
HR_KI_HIERARCHIES
HR_KI_HIERARCHIES_TL
HR_LEGISLATION_SUB_INST
AME_APPROVAL_GROUP_CONFIG
HR_TCA_PARTY_UNMERGE
HR_KI_USER_INTERFACES
PER_COMPETENCE_OUTCOMES_TL
HR_KI_TOPICS
HR_KI_TOPICS_TL
HR_KI_HIERARCHY_NODE_MAPS
HR_KI_INTEGRATIONS
AME_ACTION_TYPE_CONFIG
HR_KI_INTEGRATIONS_TL
AME_ACTION_USAGES
HR_KI_TOPIC_INTEGRATIONS
AME_ITEM_CLASSES
HR_KI_OPTION_TYPES
PER_RI_WORKBENCH_ITEMS
PER_RI_WORKBENCH_ITEMS_TL
PER_RI_SETUP_TASKS
PER_RI_SETUP_TASKS_TL
HR_KI_OPTION_TYPES_TL
AME_ITEM_CLASS_USAGES
PER_RI_SETUP_SUB_TASKS
HR_KI_OPTIONS
PER_RI_SETUP_SUB_TASKS_TL
DR$IRC_SEARCH_CRITERIA_CTX$I
DR$IRC_POSTING_CON_TL_CTX$I
DR$PER_ADDRESSES_N4$I
DR$IRC_POSTING_CON_TL_CTX$K
DR$IRC_POSTING_CON_TL_CTX$R
DR$IRC_POSTING_CON_TL_CTX$N
PQH_FR_STAT_SITUATIONS
PQH_FR_STAT_SITUATION_RULES
PQH_FR_GLOBAL_INDICES_F
PQP_EXT_CROSS_PERSON_RECORDS
PQP_VEH_REPOS_INFO_TYPES
PQP_VEH_REPOS_EXTRA_INFO
PQP_VEH_ALLOC_INFO_TYPES
PQP_VEH_ALLOC_EXTRA_INFO
PER_RI_VIEW_REPORTS
PER_COMPETENCE_OUTCOMES
PER_RI_VIEW_REPORTS_TL
HR_KI_CONTEXTS
PER_RI_DEPENDENCIES
PER_COMP_ELEMENT_OUTCOMES
PER_RI_REQUESTS
PER_SOLUTIONS_SELECTED
PER_SOLUTIONS
PER_SOLUTION_CMPT_NAMES
PER_SOLUTION_SETS
PER_SOLUTION_TYPES
PER_SOLUTION_TYPE_CMPTS
PAY_QUICKPAY_EXCLUSIONS
PAY_UPGRADE_DEFINITIONS
PAY_UPGRADE_DEFINITIONS_TL
PAY_UPGRADE_LEGISLATIONS
PAY_UPGRADE_STATUS
PAY_LATEST_BALANCES
PAY_REPORT_FORMAT_PARAMETERS
PAY_REPORT_FORMAT_MAPPINGS_TL
GHR_COMPL_AGENCY_COSTS
GHR_MASS_SALARY_CRITERIA_EXT
GHR_MTS_TEMP
GHR_PERF_CERT
PQH_CORPS_INFO_TYPES
PER_SECURITY_USERS
PER_ASSIGNMENT_LIST
PER_INTERIM_PERSON_LIST
DR$PER_EMPDIR_PEOPLE_N1$I
DR$PER_EMPDIR_PEOPLE_N1$K
DR$PER_EMPDIR_PEOPLE_N1$R
DR$PER_EMPDIR_PEOPLE_N1$N

Tables In GL

2008-01-09T08:46:00.001-08:00

GL_BALANCES_DELTA_INTERIM
GL_CROSS_RATE_TEMP
GL_CROSS_RATE_RULES
GL_CROSS_RATE_RULE_DTLS
GL_DAILY_POST_INT2
GL_BUDGET_INTERIM
GL_TRANSLATION_INTERIM
GL_XLATE_POSTING_INTERIM
GL_SETS_OF_BOOKS
GL_PERIODS
GL_CODE_COMBINATIONS
GL_DAILY_CONVERSION_TYPES
GL_ENCUMBRANCE_TYPES
GL_BUDGET_VERSIONS
JG_ZZ_TA_RULE_SETS
JG_ZZ_TA_RULE_LINES
JG_ZZ_TA_CC_RANGES
JG_ZZ_TA_ACCOUNT_RANGES
GL_JE_LINES
GL_JE_CATEGORIES_TL
GL_PERIOD_TYPES
GL_PERIOD_STATUSES
GL_TRANSACTION_CALENDAR
GL_PERIOD_SETS
GL_RECURRING_BATCHES
GL_BUDGET_PERIOD_RANGES
GL_SUMMARY_TEMPLATES
GL_JE_SOURCES_TL
GL_JE_HEADERS
GL_BALANCES
GL_BUDGET_ENTITIES
GL_ACCOUNT_HIERARCHIES
GL_ELIMINATION_SETS
GL_IEA_SUBSIDIARIES
GL_DAILY_RATES
GL_STAT_ACCOUNT_UOM
GL_BUDGETS
GL_CONS_SEGMENT_MAP
GL_DATE_PERIOD_MAP
GL_IMPORT_REFERENCES
JG_ZZ_TA_ALLOCATED_LINES
GL_MC_REPORTING_OPTIONS
GL_JE_BATCHES
GL_TRANSLATION_RATES
GL_TRANSLATION_TRACKING
GL_USSGL_TRANSACTION_CODES
GL_CONS_FLEX_HIERARCHIES
GL_CONSOLIDATION
GL_WEIGHTED_AVG_DETAILS
GL_INTERFACE
GL_IEA_TRANSACTIONS
GL_IEA_TRANSACTION_TYPES
GL_IEA_RECUR_TRANSACTIONS
GL_IEA_CLEARING_ACCOUNTS
GL_CONSOLIDATION_AUDIT
GL_CONS_FLEXFIELD_MAP
GL_CONS_SET_ASSIGNMENTS
GL_CONSOLIDATION_SETS
GL_ALLOC_FORMULAS
GL_AUTOMATIC_POSTING_OPTIONS
GL_ALLOC_BATCHES
GL_IEA_SEGMENT_MAP
GL_AUTO_ALLOC_BAT_HIST_DET
GL_AUTO_ALLOC_SETS
GL_MC_BOOK_ASSIGNMENTS
GL_REVALUATIONS
GL_REVAL_ACCOUNT_RANGES
GL_SUSPENSE_ACCOUNTS
JE_BE_VAT_REP_RULES
GL_AUTOREVERSE_OPTIONS
GL_INTERCOMPANY_ACC_SETS
GL_OASIS_SUMMARY_DATA
GL_BC_PACKETS
GL_BC_OPTION_DETAILS
GL_IEA_AUTOGEN_MAP
GL_AUTO_ALLOC_SET_HISTORY
GL_ENTITY_BUDGETS
GL_ROW_MULTIPLIERS
GL_RECURRING_HEADERS
GL_HISTORICAL_RATES
GL_AUTO_ALLOC_BATCH_HISTORY
GL_AUTHORIZATION_LIMITS
GL_BUDGET_BATCHES
AP_MC_INVOICES_TMP
GL_AHE_DETAIL_RANGES_GT
GL_ALLOC_FORMULA_LINES
GL_ALLOC_HISTORY
GL_ALLOC_INT_1_2618275
GL_ALLOC_INT_1_2618555
GL_ALLOC_INT_1_2618750
GL_ALLOC_INT_1_2618752
GL_ALLOC_INT_1_2618780
GL_ALLOC_INT_1_2618783
GL_ALLOC_INT_1_2618798
GL_ALLOC_INT_1_2618809
GL_ALLOC_INT_1_2618846
GL_ALLOC_INT_1_2618906
GL_ALLOC_INT_1_2618940
GL_ALLOC_INT_1_2618941
GL_ALLOC_INT_1_2622147
GL_ALLOC_INT_1_2626340
GL_ALLOC_INT_1_2626368
GL_ALLOC_INT_1_2627515
GL_ALLOC_INT_1_2627516
GL_ALLOC_INT_1_2627517
GL_ALLOC_INT_1_2627518
GL_ALLOC_INT_1_2627531
GL_ALLOC_INT_1_2627533
GL_ALLOC_INT_1_2632882
GL_ALLOC_INT_1_2633706
GL_ALLOC_INT_2_2618275
GL_ALLOC_INT_2_2618750
GL_ALLOC_INT_2_2618752
GL_ALLOC_INT_2_2618780
GL_ALLOC_INT_2_2618783
GL_ALLOC_INT_2_2618798
GL_ALLOC_INT_2_2618809
GL_ALLOC_INT_2_2618846
GL_ALLOC_INT_2_2618906
GL_ALLOC_INT_2_2618940
GL_ALLOC_INT_2_2618941
GL_ALLOC_INT_2_2622147
GL_ALLOC_INT_2_2626340
GL_ALLOC_INT_2_2626368
GL_ALLOC_INT_2_2627515
GL_ALLOC_INT_2_2627516
GL_ALLOC_INT_2_2627517
GL_ALLOC_INT_2_2627518
GL_ALLOC_INT_2_2627531
GL_ALLOC_INT_2_2627533
GL_ALLOC_INT_2_2632882
GL_ALLOC_INT_2_2633706
GL_ALLOC_INT_3_2618275
GL_ALLOC_INT_3_2618750
GL_ALLOC_INT_3_2618752
GL_ALLOC_INT_3_2618780
GL_ALLOC_INT_3_2618783
GL_ALLOC_INT_3_2618798
GL_ALLOC_INT_3_2618809
GL_ALLOC_INT_3_2618846
GL_ALLOC_INT_3_2618906
GL_ALLOC_INT_3_2618940
GL_ALLOC_INT_3_2618941
GL_ALLOC_INT_3_2622147
GL_ALLOC_INT_3_2626340
GL_ALLOC_INT_3_2626368
GL_ALLOC_INT_3_2627515
GL_ALLOC_INT_3_2627516
GL_ALLOC_INT_3_2627517
GL_ALLOC_INT_3_2627518
GL_ALLOC_INT_3_2627531
GL_ALLOC_INT_3_2627533
GL_ALLOC_INT_3_2632882
GL_ALLOC_INT_3_2633706
GL_ALLOC_SEGVALS_INT
GL_ALLOC_TARGET_2618275
GL_ALLOC_TARGET_2618750
GL_ALLOC_TARGET_2618752
GL_ALLOC_TARGET_2618780
GL_ALLOC_TARGET_2618783
GL_ALLOC_TARGET_2618798
GL_ALLOC_TARGET_2618809
GL_ALLOC_TARGET_2618846
GL_ALLOC_TARGET_2618906
GL_ALLOC_TARGET_2618940
GL_ALLOC_TARGET_2618941
GL_ALLOC_TARGET_2622147
GL_ALLOC_TARGET_2626340
GL_ALLOC_TARGET_2626368
GL_ALLOC_TARGET_2627515
GL_ALLOC_TARGET_2627516
GL_ALLOC_TARGET_2627517
GL_ALLOC_TARGET_2627518
GL_ALLOC_TARGET_2627531
GL_ALLOC_TARGET_2627533
GL_ALLOC_TARGET_2632882
GL_ALLOC_TARGET_2633706
GL_APPLICATION_GROUPS
GL_ARCHIVE_BALANCES
GL_ARCHIVE_BATCHES
GL_ARCHIVE_DAILY_BALANCES
GL_ARCHIVE_HEADERS
GL_ARCHIVE_HISTORY
GL_ARCHIVE_LINES
GL_ARCHIVE_REFERENCES
GL_AUTOMATIC_POSTING_SETS
GL_AUTO_ALLOC_BATCHES
GL_AUTO_ALLOC_REV_BATCHES
GL_BALANCES_DELTA
GL_BC_DUAL
GL_BC_DUAL2
GL_BC_EVENT_TIMESTAMPS
GL_BC_OPTIONS
GL_BC_PACKET_ARRIVAL_ORDER
GL_BC_PERIOD_MAP
GL_BIS_SEGVAL_INT
GL_BUDGET_ASSIGNMENTS
GL_BUDGET_ASSIGNMENT_RANGES
GL_BUDGET_FROZEN_RANGES
GL_BUDGET_INTERFACE
GL_BUDGET_RANGE_INTERIM
GL_BUDGET_TYPES
GL_CARRYFORWARD_RANGES
GL_CONCURRENCY_CONTROL
GL_CONCURRENT_SCHEDULES
GL_CONSOLIDATION_ACCOUNTS
GL_CONSOLIDATION_HISTORY
GL_CONS_BATCHES
GL_CONS_INTERFACE_24401
GL_CONS_INTERFACE_24406
GL_CONS_INTERFACE_24407
GL_DAILY_BALANCES
GL_DAILY_CONVERSION_RATES_R10
GL_DAILY_OPEN_INT
GL_DAILY_RATES_INTERFACE
GL_DOC_SEQUENCE_AUDIT
GL_DYNAMIC_SUMM_COMBINATIONS
GL_EFC_BUDGET_MAPPING
GL_EFC_CHANGED_TRX
GL_EFC_DATA_UTILITY
GL_EFC_DISABLED_TRIGGERS
GL_EFC_RUN_HISTORY
GL_ELIMINATION_HISTORY
GL_ELIMINATION_JOURNALS
GL_ELIM_ACCOUNTS_MAP
GL_ELIM_BAL_OPTIONS
GL_EXTRACT_HISTORY
GL_HISTORICAL_RATE_RANGES
GL_IEA_IMPORT_REGISTRY
GL_IEA_INTERFACE
GL_IEA_RECUR_BATCHES
GL_IEA_RECUR_HISTORY
GL_IEA_RECUR_LINES
GL_IEA_SEGMENT_RULE_MAP
GL_IEA_TRANSACTION_LINES
GL_INTERFACE_CONTROL
GL_INTERCOMPANY_ACCOUNTS
GL_INTERCO_ACCOUNTS_R110
GL_INTERCO_BSV_INT_24656
GL_INTERCO_BSV_INT_24659
GL_INTERCO_BSV_INT_24884
GL_INTERCO_BSV_INT_24936
GL_INTERCO_BSV_INT_25002
GL_INTERCO_BSV_INT_25184
GL_INTERCO_BSV_INT_25355
GL_INTERCO_BSV_INT_25356
GL_INTERCO_BSV_INT_26078
GL_INTERCO_BSV_INT_26081
GL_INTERCO_BSV_INT_26127
GL_INTERCO_BSV_INT_26184
GL_INTERCO_BSV_INT_26212
GL_INTERCO_BSV_INT_26214
GL_INTERCO_BSV_INT_26420
GL_INTERCO_BSV_INT_26481
GL_INTERCO_BSV_INT_26547
GL_INTERCO_BSV_INT_26666
GL_INTERCO_BSV_INT_26681
GL_INTERCO_BSV_INT_26774
GL_INTERCO_BSV_INT_26978
GL_INTERCO_BSV_INT_27022
GL_INTERCO_BSV_INT_27060
GL_INTERCO_BSV_INT_27180
GL_INTERCO_BSV_INT_27263
GL_INTERCO_BSV_INT_27422
GL_INTERCO_BSV_INT_27486
GL_INTERCO_BSV_INT_27564
GL_INTERCO_BSV_INT_27663
GL_INTERCO_BSV_INT_27729
GL_INTERCO_BSV_INT_27912
GL_INTERCO_BSV_INT_27994
GL_INTERCO_BSV_INT_28030
GL_INTERCO_BSV_INT_28102
GL_INTERCO_BSV_INT_28178
GL_INTERCO_BSV_INT_28346
GL_INTERCO_BSV_INT_28424
GL_INTERCO_BSV_INT_28692
GL_INTERCO_BSV_INT_28756
GL_INTERCO_BSV_INT_29006
GL_INTERCO_BSV_INT_29092
GL_INTERCO_BSV_INT_29229
GL_INTERCO_BSV_INT_29265
GL_INTERCO_BSV_INT_29307
GL_INTERCO_BSV_INT_29372
GL_INTERCO_BSV_INT_29650
GL_INTERCO_BSV_INT_29740
GL_INTERCO_BSV_INT_29882
GL_INTERCO_BSV_INT_30002
GL_INTERCO_BSV_INT_30062
GL_INTERCO_BSV_INT_30518
GL_INTERCO_BSV_INT_30539
GL_INTERCO_BSV_INT_30671
GL_INTERCO_BSV_INT_30724
GL_INTERCO_BSV_INT_30728
GL_INTERCO_BSV_INT_30732
GL_INTERCO_BSV_INT_30734
GL_INTERCO_BSV_INT_30738
GL_INTERCO_BSV_INT_30798
GL_INTERCO_BSV_INT_30952
GL_INTERCO_BSV_INT_31022
GL_INTERCO_BSV_INT_31073
GL_INTERCO_BSV_INT_31074
GL_INTERCO_LINES_INT_30724
GL_INTERCO_LINES_INT_30728
GL_INTERCO_LINES_INT_30732
GL_INTERCO_LINES_INT_30734
GL_INTERCO_LINES_INT_30738
GL_INTERCO_LINES_INT_30798
GL_INTERCO_LINES_INT_30952
GL_INTERCO_LINES_INT_31022
GL_INTERCO_LINES_INT_31073
GL_INTERCO_LINES_INT_31074
GL_INTERFACE_HISTORY
GL_JE_INCLUSION_RULES
GL_JOURNAL_REPORTS_ITF
GL_LOOKUPS_OLD
GL_MC_CONVERSION_RULES
GL_MC_CONV_INT_30717
GL_MC_CONV_INT_30719
GL_MC_CONV_INT_30721
GL_MC_CONV_INT_30724
GL_MC_CONV_INT_30730
GL_MC_CONV_INT_30732
GL_MC_CONV_INT_30734
GL_MC_CONV_INT_30736
GL_MC_CONV_INT_30738
GL_MC_CONV_INT_30794
GL_MC_CONV_INT_30852
GL_MC_CONV_INT_30932
GL_MC_CONV_INT_31018
GL_MC_CONV_INT_31058
GL_MC_CONV_INT_31060
GL_MC_CONV_INT_31061
GL_MC_CONV_INT_31069
GL_MC_CONV_INT_31070
GL_MC_CONV_INT_31085
GL_MC_CONV_INT_31122
GL_MC_OPTIONS_INT_30717
GL_MC_OPTIONS_INT_30719
GL_MC_OPTIONS_INT_30721
GL_MC_OPTIONS_INT_30724
GL_MC_OPTIONS_INT_30730
GL_MC_OPTIONS_INT_30732
GL_MC_OPTIONS_INT_30734
GL_MC_OPTIONS_INT_30736
GL_MC_OPTIONS_INT_30738
GL_MC_OPTIONS_INT_30794
GL_MC_OPTIONS_INT_30852
GL_MC_OPTIONS_INT_30932
GL_MC_OPTIONS_INT_31018
GL_MC_OPTIONS_INT_31058
GL_MC_OPTIONS_INT_31060
GL_MC_OPTIONS_INT_31061
GL_MC_OPTIONS_INT_31069
GL_MC_OPTIONS_INT_31070
GL_MC_OPTIONS_INT_31085
GL_MC_OPTIONS_INT_31122
GL_MC_UPGRADE_HISTORY
GL_MC_UPGRADE_RATES
GL_MOVEMERGE_ACCOUNTS
GL_MOVEMERGE_BAL_103
GL_MOVEMERGE_BAL_104
GL_MOVEMERGE_BAL_123
GL_MOVEMERGE_BAL_143
GL_MOVEMERGE_BAL_164
GL_MOVEMERGE_BAL_184
GL_MOVEMERGE_BAL_63
GL_MOVEMERGE_BAL_83
GL_MOVEMERGE_BAL_84
GL_MOVEMERGE_INTERIM_103
GL_MOVEMERGE_INTERIM_104
GL_MOVEMERGE_INTERIM_123
GL_MOVEMERGE_INTERIM_143
GL_MOVEMERGE_INTERIM_164
GL_MOVEMERGE_INTERIM_184
GL_MOVEMERGE_INTERIM_63
GL_MOVEMERGE_INTERIM_83
GL_MOVEMERGE_INTERIM_84
GL_MOVEMERGE_REQUESTS
GL_NET_INCOME_ACCOUNTS
GL_OASIS_COLLECTION_INT
GL_OASIS_FIN_ASSIGNMENTS
GL_OASIS_FIN_ITEMS
GL_OASIS_FIN_METRICS
GL_OPEN_INTERIM
GL_POSTING_INTERIM
GL_POSTING_INTERIM_24331
GL_POSTING_INTERIM_24656
GL_POSTING_INTERIM_30716
GL_RECURRING_LINES
GL_RECURRING_LINE_CALC_RULES
GL_REVALUATION
GL_REVALUATION_ACCOUNTS
GL_REVAL_CHD_RANGES_GT
GL_REVAL_EXP_RANGES_GT
GL_ROLLUP_GROUP_SCORES
GL_RX_TRIAL_BALANCE_ITF
GL_SEGMENT_FREQUENCIES
GL_SEGVAL_INHERIT_HISTORY
GL_SHARES_ACTIVITY
GL_SHARES_OUTSTANDING
GL_STORAGE_PARAMETERS
GL_SUMMARY_HIERARCHIES
GL_SUMMARY_HIERARCHY_INT
GL_SYSTEM_SETUP
GL_SYSTEM_USAGES
GL_TAX_OPTIONS
GL_TAX_OPTION_ACCOUNTS
GL_TEMPORARY_COMBINATIONS
GL_TRANSACTION_DATES
GL_TRANSACTION_RATE_EXCEPTIONS
GL_TRANSLATION_STATUSES
GL_USSGL_ACCOUNT_PAIRS
GL_YEAR_END_ACCT_INT_1
GL_YEAR_END_ACCT_INT_8
GL_YEAR_END_BAL_INT_1
GL_YEAR_END_BAL_INT_8
JE_BE_ANNUAL_VAT
JE_BE_ESL_SUMMARIES
JE_BE_LINE_TYPE_MAP
JE_BE_LOGS
JE_BE_REPORTERS
JE_BE_VAT_ALLOCATIONS
JE_BE_VAT_ALLOC_ERRORS
JE_DOC_SEQUENCE_AUDIT
JE_GR_CUTOFF_RULES
JE_GR_JE_HEADER_SEQUENCE
JE_IT_REPORT_PARAMETERS
JE_IT_TMP_RPT_HEADERS

Tables In FA

2008-01-09T08:45:00.003-08:00

FA_MASS_REVAL_REP_ITF
FA_RESERVE_LEDGER_GT
FA_BALANCES_REPORT_GT
FA_METHODS
FA_ACE_BOOKS
FA_ADDITIONS_B
FA_ADDITIONS_TL
FA_ADDITION_REP_ITF
FA_ADD_WARRANTIES
FA_ADJUSTMENTS
FA_ADJUST_REP_ITF
FA_AMORT_SCHEDULES
FA_ARCHIVE_HISTORY
FA_ASSET_HIERARCHY
FA_ASSET_HIERARCHY_PURPOSE
FA_ASSET_HIERARCHY_VALUES
FA_ASSET_HISTORY
FA_ASSET_INVOICES
FA_ASSET_KEYWORDS
FA_ASSET_LISTING_REP_ITF
FA_AS_EFC_07_JAN_2002_03
FA_AS_EFC_20_FEB_2003_12
FA_BALANCES_REPORT
FA_BALANCES_REP_ITF
FA_BONUS_RATES
FA_BONUS_RULES
FA_BOOKS
FA_BOOKS_GROUPS
FA_BOOKS_SUMMARY
FA_BOOK_CONTROLS
FA_BOOK_CONTROLS_HISTORY
FA_BUDGET_DISTRIBUTION
FA_BUDGET_INTERFACE
FA_CALENDAR_PERIODS
FA_CALENDAR_TYPES
FA_CAPITAL_BUDGET
FA_CAP_BUD_EFC_07_JAN_2002_03
FA_CAP_BUD_EFC_20_FEB_2003_12
FA_CAP_REP_ITF
FA_CATEGORIES_B
FA_CATEGORIES_TL
FA_CATEGORY_BOOKS
FA_CATEGORY_BOOK_DEFAULTS
FA_CBD_EFC_07_JAN_2002_03
FA_CBD_EFC_20_FEB_2003_12
FA_CEILINGS
FA_CEILING_TYPES
FA_CL_EFC_07_JAN_2002_03
FA_CL_EFC_20_FEB_2003_12
FA_CONVENTIONS
FA_CONVENTION_TYPES
FA_COSTCLEAR_REP_ITF
FA_CT_EFC_07_JAN_2002_03
FA_CT_EFC_20_FEB_2003_12
FA_DEFERRED_DEPRN
FA_DELETED_MASS_ADDITIONS
FA_DEPRN_BASIS_RULES
FA_DEPRN_DETAIL
FA_DEPRN_OVERRIDE
FA_DEPRN_PERIODS
FA_DEPRN_REP_ITF
FA_DEPRN_RULE_DETAILS
FA_DEPRN_SUMMARY
FA_DEPRN_TAX_REP_ITF
FA_DEPRN_TAX_REP_NBVS
FA_DISTRIBUTION_ACCOUNTS
FA_DISTRIBUTION_DEFAULTS
FA_DISTRIBUTION_HISTORY
FA_DISTRIBUTION_SETS
FA_EXCLUDE_HIERARCHY_LEVELS
FA_EXT_INV_RETIREMENTS
FA_FISCAL_YEAR
FA_FLAT_RATES
FA_FORMULAS
FA_GAR_EFC_07_JAN_2002_03
FA_GAR_EFC_20_FEB_2003_12
FA_GROUP_ASSETS
FA_GROUP_ASSET_DEFAULT
FA_GROUP_ASSET_RULES
FA_GROUP_DEPRN_DETAIL
FA_GROUP_DEPRN_RATES
FA_GROUP_DEPRN_SUMMARY
FA_GROUP_REP_ITF
FA_HIERARCHY_CONTROLS
FA_HIERARCHY_DISTRIBUTIONS
FA_HIERARCHY_RULE_DETAILS
FA_HIERARCHY_RULE_SET
FA_HRD_EFC_07_JAN_2002_03
FA_HRD_EFC_20_FEB_2003_12
FA_HRH_EFC_07_JAN_2002_03
FA_HRH_EFC_20_FEB_2003_12
FA_HR_RETIREMENT_DETAILS
FA_HR_RETIREMENT_HEADERS
FA_INS_LINES
FA_INS_MST_POLS
FA_INS_POLICIES
FA_INS_VALUES
FA_INVENTORY
FA_INVMISS_REP_ITF
FA_INVOICE_TRANSACTIONS
FA_INV_COMPARE_REP_ITF
FA_INV_INTERFACE
FA_IP_EFC_07_JAN_2002_03
FA_IP_EFC_20_FEB_2003_12
FA_ITC_RATES
FA_ITC_RECAPTURE_RATES
FA_IV_EFC_07_JAN_2002_03
FA_IV_EFC_20_FEB_2003_12
FA_JOURNAL_ENTRIES
FA_LEASES
FA_LEASE_PAYMENTS
FA_LEASE_PAYMENT_ITEMS
FA_LEASE_SCHEDULES
FA_LIFE_DERIVATION_INFO
FA_LOCATIONS
FA_LOOKUPS_B
FA_LOOKUPS_TL
FA_LOOKUP_TYPES_B
FA_LOOKUP_TYPES_TL
FA_LSP_EFC_07_JAN_2002_03
FA_LSP_EFC_20_FEB_2003_12
FA_LSS_EFC_07_JAN_2002_03
FA_LSS_EFC_20_FEB_2003_12
FA_LS_EFC_07_JAN_2002_03
FA_LS_EFC_20_FEB_2003_12
FA_MAINT_EVENTS
FA_MAINT_REP_ITF
FA_MAINT_SCHEDULE_DTL
FA_MAINT_SCHEDULE_HDR
FA_MASSADD_DISTRIBUTIONS
FA_MASSADD_REP_ITF
FA_MASS_ADDITIONS
FA_MASS_CHANGES
FA_MASS_CHANGES_ITF
FA_MASS_EXTERNAL_TRANSFERS
FA_MASS_EXT_RETIREMENTS
FA_MASS_EXT_RET_EXCEPTS
FA_MASS_RECLASS
FA_MASS_RECLASS_ITF
FA_MASS_RETIREMENTS
FA_MASS_RET_EXCEPTS
FA_MASS_REVALUATIONS
FA_MASS_REVALUATION_RULES
FA_MASS_TAX_ADJUSTMENTS
FA_MASS_TRANSFERS
FA_MASS_UPDATE_BATCH_DETAILS
FA_MASS_UPDATE_BATCH_HEADERS
FA_MC_ADJUSTMENTS
FA_MC_ASSET_INVOICES
FA_MC_BOOKS
FA_MC_BOOKS_GROUPS
FA_MC_BOOKS_RATES
FA_MC_BOOKS_SUMMARY
FA_MC_BOOK_CONTROLS
FA_MC_BR_EFC_07_JAN_2002_03
FA_MC_BR_EFC_20_FEB_2003_12
FA_MC_CH_EFC_07_JAN_2002_03
FA_MC_CH_EFC_20_FEB_2003_12
FA_MC_CONVERSION_HISTORY
FA_MC_CONVERSION_RATES
FA_MC_DEFERRED_DEPRN
FA_MC_DEPRN_DETAIL
FA_MC_DEPRN_PERIODS
FA_MC_DEPRN_SUMMARY
FA_MC_GROUP_DEPRN_DETAIL
FA_MC_GROUP_DEPRN_SUMMARY
FA_MC_MASS_RATES
FA_MC_RETIREMENTS
FA_ME_EFC_07_JAN_2002_03
FA_ME_EFC_20_FEB_2003_12
FA_MRC_INQ_FINANCIALS
FA_MSD_EFC_07_JAN_2002_03
FA_MSD_EFC_20_FEB_2003_12
FA_MSH_EFC_07_JAN_2002_03
FA_MSH_EFC_20_FEB_2003_12
FA_PARALLEL_WORKERS
FA_PERIODIC_PRODUCTION
FA_PERIOD_MAPS
FA_PLSQL_DEBUG
FA_PRICE_INDEXES
FA_PRICE_INDEX_VALUES
FA_PRODUCTION_INTERFACE
FA_PROJECT_REP_ITF
FA_PROPTAX_REP_ITF
FA_RATES
FA_RECLASS_REP_ITF
FA_RESERVE_LEDGER
FA_RETIREMENTS
FA_RETIRE_REP_ITF
FA_RX_ATTRSETS_B
FA_RX_ATTRSETS_TL
FA_RX_DYNAMIC_COLUMNS
FA_RX_LOV
FA_RX_MULTIFORMAT_REPS
FA_RX_REPORTS
FA_RX_REP_COLUMNS_B
FA_RX_REP_COLUMNS_TL
FA_RX_REP_PARAMETERS
FA_RX_SECURITY
FA_RX_SUMMARY_TL
FA_SHORT_TAX_RESERVES
FA_SUPER_GROUPS
FA_SUPER_GROUP_RULES
FA_SYSTEM_CONTROLS
FA_TAX_INTERFACE
FA_TAX_REPORT
FA_TRACK_MEMBERS
FA_TRANSACTION_HEADERS
FA_TRANSFER_DETAILS
FA_TRANSFER_REP_ITF
FA_TRX_REFERENCES
FA_WARRANTIES
FA_WAR_EFC_07_JAN_2002_03
FA_WAR_EFC_20_FEB_2003_12
FA_WHATIF_ITF
JE_DE_FA_SUMMARY
JE_HU_BALANCES_REPORT
JG_ZZ_FA_INS_LINES_R110
JG_ZZ_FA_INS_MST_POLS_R110
JG_ZZ_FA_INS_POLICIES_R110
JG_ZZ_FA_INS_VALUES_R110

Tables In CN

2008-01-09T08:45:00.001-08:00

CN_ATTAIN_SCHEDULES
CN_ATTAIN_TIERS
CN_ATTRIBUTE_RULES_ALL
CN_CALC_EDGES_ALL
CN_CALC_EXT_TABLES_ALL
CN_CALC_EXT_TBL_DTLS_ALL
CN_CALC_FORMULAS_ALL
CN_CALC_SQL_EXPS_ALL
CN_CALC_SUBMISSION_BATCHES_ALL
CN_CALC_SUBMISSION_ENTRIES_ALL
CN_CALC_SUB_QUOTAS_ALL
CN_CAL_PER_INT_TYPES_ALL
CN_CLRL_API_ALL
CN_COLUMN_IND_MAPS
CN_COLUMN_MAPS_ALL
CN_COLUMN_TRG_MAPS
CN_COMMISSION_HEADERS_ALL
CN_COMMISSION_LINES_ALL
CN_COMM_LINES_API_ALL
CN_COMP_ANCHORS
CN_COMP_PLANS_ALL
CN_CREDIT_CONV_FCTS_ALL
CN_CREDIT_TYPES_ALL_B
CN_CREDIT_TYPES_ALL_TL
CN_DIMENSIONS_ALL_B
CN_DIMENSIONS_ALL_TL
CN_DIM_EXPLOSION_ALL
CN_DIM_HIERARCHIES_ALL
CN_EVENTS_ALL_B
CN_EVENTS_ALL_TL
CN_EVENT_LOG_ALL
CN_FORMULA_INPUTS_ALL
CN_HEAD_HIERARCHIES_ALL_B
CN_HEAD_HIERARCHIES_ALL_TL
CN_HIERARCHIES_API_ALL
CN_HIERARCHY_EDGES_ALL
CN_HIERARCHY_MAPS
CN_HIERARCHY_NODES_ALL
CN_IMPORT_TYPES
CN_IMP_HEADERS
CN_IMP_LINES
CN_IMP_MAPS
CN_IMP_MAP_FIELDS
CN_INTERVAL_TYPES_ALL_B
CN_INTERVAL_TYPES_ALL_TL
CN_INVOICE_CHANGES_ALL
CN_ITEMS_ALL
CN_JOB_ROLES
CN_LEDGER_BAL_TYPES_ALL_B
CN_LEDGER_BAL_TYPES_ALL_TL
CN_LEDGER_JE_BATCHES_ALL
CN_LEDGER_JOURNAL_ENTRIES_ALL
CN_LINE_ROLLUP_PATHS_ALL
CN_LOOKUPS_ALL_OLD
CN_LOOKUP_TYPES_ALL_OLD
CN_MODEL_RESOURCES_ALL
CN_MODULES_ALL_B
CN_MODULES_ALL_TL
CN_MOD_OBJ_DEPENDS_ALL
CN_NOTIFY_LOG_ALL
CN_NOT_TRX_ALL
CN_OBJECTS_ALL
CN_PAYMENT_API_ALL
CN_PAYMENT_TRANSACTIONS_ALL
CN_PAYMENT_WORKSHEETS_ALL
CN_PAYRUNS_ALL
CN_PAY_APPROVAL_FLOW_ALL
CN_PAY_ELEMENT_INPUTS_ALL
CN_PAY_GROUPS_ALL
CN_PERF_MEASURES_ALL
CN_PERIOD_QUOTAS_ALL
CN_PERIOD_SETS_ALL
CN_PERIOD_STATUSES_ALL
CN_PERIOD_TYPES_ALL
CN_PLAN_TEXTS
CN_PMT_PLANS_ALL
CN_POSTING_BATCHES_ALL
CN_POSTING_DETAILS_ALL
CN_POSTING_DETAILS_SUM_ALL
CN_PROCESS_AUDITS_ALL
CN_PROCESS_AUDIT_LINES_ALL
CN_PROCESS_BATCHES_ALL
CN_QUARTER_BCK_ALL
CN_QUOTAS_ALL
CN_QUOTA_ASSIGNS_ALL
CN_QUOTA_CATEGORIES
CN_QUOTA_PAY_ELEMENTS_ALL
CN_QUOTA_RULES_ALL
CN_QUOTA_RULE_UPLIFTS_ALL
CN_RATE_DIMENSIONS_ALL
CN_RATE_DIM_TIERS_ALL
CN_RATE_SCHEDULES_ALL
CN_RATE_SCH_DIMS_ALL
CN_RATE_TIERS_ALL
CN_REASONS_ALL
CN_REASON_HISTORY_ALL
CN_REPOSITORIES_ALL
CN_REVENUE_CLASSES_ALL
CN_ROLE_DETAILS
CN_ROLE_MODELS_ALL
CN_ROLE_PLANS_ALL
CN_ROLE_PLAN_MAPS
CN_ROLE_QUOTA_CATES
CN_ROLE_QUOTA_FORMULAS
CN_ROLE_QUOTA_RATES
CN_RT_FORMULA_ASGNS_ALL
CN_RT_QUOTA_ASGNS_ALL
CN_RULESETS_ALL_B
CN_RULESETS_ALL_TL
CN_RULES_ALL_B
CN_RULES_ALL_TL
CN_RULES_HIERARCHY_ALL
CN_RULE_ATTR_EXPRESSION_ALL
CN_SALESREPS_API_ALL
CN_SCH_DIM_TIERS_ALL
CN_SEASONALITIES_ALL
CN_SEAS_SCHEDULES_ALL
CN_SECURITY_PROFILES_ALL
CN_SEC_PROF_ASSIGNS_ALL
CN_SF_REPOSITORIES_ALL
CN_SOURCE_ALL
CN_SRP_CNRT_HISTORY_ALL
CN_SRP_COMP_ANCHORS_ALL
CN_SRP_DATA_SUMM_F
CN_SRP_DENORM_DATA_ALL
CN_SRP_DENORM_DATA_BCK_ALL
CN_SRP_INTEL_PERIODS_ALL
CN_SRP_PAYEE_ASSIGNS_ALL
CN_SRP_PAY_GROUPS_ALL
CN_SRP_PERIODS_ALL
CN_SRP_PERIOD_PAYEES_ALL
CN_SRP_PERIOD_QUOTAS_ALL
CN_SRP_PERIOD_QUOTAS_EXT_ALL
CN_SRP_PER_QUOTA_RC_ALL
CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_PMT_PLANS_ALL
CN_SRP_QUOTA_ASSIGNS_ALL
CN_SRP_QUOTA_CATES_ALL
CN_SRP_QUOTA_RATES_ALL
CN_SRP_QUOTA_RULES_ALL
CN_SRP_RATE_ASSIGNS_ALL
CN_SRP_ROLE_DTLS_ALL
CN_SRP_ROLE_HISTORY_ALL
CN_SRP_RULE_UPLIFTS_ALL
CN_SRP_TOTAL_COMPS_ALL
CN_TABLE_MAPS_ALL
CN_TABLE_MAP_OBJECTS_ALL
CN_TRX_ALL
CN_TRX_BATCHES_ALL
CN_TRX_FACTORS_ALL
CN_TRX_LINES_ALL
CN_TRX_SALES_LINES_ALL
CN_USER_ACCESSES_ALL
CN_WORKSHEET_BONUSES_ALL
CN_WORKSHEET_QG_DTLS_ALL
CN_SCA_HEADERS_INTERFACE_ALL
CN_SCA_WINNING_RULES_GTT
MLOG$_CN_SCA_CONDITIONS_AL
MLOG$_CN_SCA_DENORM_RULES_
MLOG$_CN_SCA_COND_DETAILS_
CN_SCA_DENORM_RULES_ALL
CN_SCA_RULE_ATTRIBUTES_ALL_B
CN_SCA_RULE_ATTRIBUTES_ALL_TL
CN_ROLE_PMT_PLANS_ALL
CN_ROLE_PAY_GROUPS_ALL
CN_SCA_HEADERS_INTERFACE_GTT
CN_SCA_LINES_INTERFACE_GTT
CN_SRP_PAYOUT_DTLS_ALL
CN_PROJ_COMPENSATION_GTT
CN_SCA_LINES_OUTPUT_GTT
CN_SCA_LINES_INTERFACE_ALL
CN_SCA_LINES_OUTPUT_ALL
CN_ROLLOVER_QUOTAS_ALL
CN_SRP_ROLLOVER_QUOTAS_ALL
CN_SCA_PROCESS_BATCHES_ALL
CN_SCA_CREDIT_RULES_ALL
CN_SCA_CONDITIONS_ALL
CN_SCA_COND_DETAILS_ALL
CN_SCA_ALLOCATIONS_ALL
CN_SCA_ALLOC_DETAILS_ALL
CN_SCA_COMBINATIONS_ALL
CN_SCA_WINNERS_ALL
CN_SCA_MATCHES_ALL

Tables In BIM

2008-01-09T08:44:00.002-08:00

BIM_ALL_INDEXES
BIM_CAMPAIGNS_DENORM
BIM_CMPGN_PERF_SUMM
BIM_CMPGN_RESP_SUMM
BIM_CMPGN_REVCOST_SUMM
BIM_CUSTOMER_REV_SUMM
BIM_DATES
BIM_EDW_CMPFRCST_F
BIM_EDW_CMPFRCST_FSTG
BIM_EDW_CMPFRCST_F_DLOG
BIM_EDW_CMPFRCST_INC
BIM_EDW_EVTFRCST_F
BIM_EDW_EVTFRCST_FSTG
BIM_EDW_EVTFRCST_F_DLOG
BIM_EDW_EVTFRCST_INC
BIM_EDW_INTRCTNS_F
BIM_EDW_INTRCTNS_FSTG
BIM_EDW_INTRCTNS_F_DLOG
BIM_EDW_INTRCTNS_F_ILOG
BIM_EDW_INTRCTNS_INC
BIM_EDW_LEADS_F
BIM_EDW_LEADS_FSTG
BIM_EDW_LEADS_F_DLOG
BIM_EDW_LEADS_INC
BIM_EDW_OPRNTIES_F
BIM_EDW_OPRNTIES_FSTG
BIM_EDW_OPRNTIES_F_DLOG
BIM_EDW_OPRNTIES_INC
BIM_EDW_RVCT_DLY_F
BIM_EDW_RVCT_MTH_F
BIM_EVENT_PERF_SUMM
BIM_EVENT_RESP_SUMM
BIM_EVENT_REVCOST_SUMM
BIM_GEOGRAPHY
BIM_INTL_DATES
BIM_I_ADMIN_GROUP
BIM_I_LEAD_FACTS
BIM_I_LEAD_FACTS_STG
BIM_I_LOCATIONS
BIM_I_MARKETING_FACTS
BIM_I_PROGRAMS_DENORM
BIM_I_SOURCE_CODES
BIM_LEAD_CONV_SUMM
BIM_OPPR_CYCLE_SUMM
BIM_REP_HISTORY
BIM_R_CAMP_COLLECTION
BIM_R_CAMP_COLLECTION_COPY
BIM_R_CAMP_DAILY_FACTS
BIM_R_CAMP_LOAD
BIM_R_CAMP_WEEKLY_FACTS
BIM_R_CODE_DEFINITIONS
BIM_R_EVEN_DAILY_FACTS
BIM_R_EVEN_LOAD
BIM_R_EVEN_WEEKLY_FACTS
BIM_R_FDSP_DAILY_FACTS
BIM_R_FDSP_LOAD
BIM_R_FDSP_WEEKLY_FACTS
BIM_R_FP_DIMSUM
BIM_R_FUND_BALANCE
BIM_R_FUND_DAILY_FACTS
BIM_R_FUND_DIMSUM
BIM_R_FUND_LOAD
BIM_R_FUND_WEEKLY_FACTS
BIM_R_IRES_COLLECTION
BIM_R_KPI_FACTS
BIM_R_LEAD_DAILY_FACTS
BIM_R_LEAD_GRP_MGR
BIM_R_LEAD_RES_DENORM
BIM_R_LEAD_SUM_FACTS
BIM_R_LEAD_WEEKLY_FACTS
BIM_R_LIMP_DAILY_FACTS
BIM_R_LIMP_WEEKLY_FACTS
BIM_R_LOCATIONS
BIM_R_PERIODS
BIM_R_RESP_INT_GRADES
BIM_R_RESP_INT_HEADER
BIM_R_RESP_INT_REASON
BIM_R_RGRD_DAILY_FACTS
BIM_R_RGRD_WEEKLY_FACTS
BIM_R_RRSN_DAILY_FACTS
BIM_R_RRSN_WEEKLY_FACTS
BIM_R_SOURCE_CODES
BIM_R_WEEKLY_CPL
BIM_SALES_CATEGORY_HIER
BIM_SALES_CYCLE_SUMM
BIM_SLIST_PROFIT_SUMM
BIM_SOURCE_CODE_DETAILS
BIM_TARGET_SEGMENTS_DENORM
BIM_TRGT_SGMT_PERF_SUMM
EDW_BIM_CAMP_CMPGNS_L1_LSTG
EDW_BIM_CAMP_CMPGNS_L1_LTC
EDW_BIM_CAMP_CMPGNS_L2_LSTG
EDW_BIM_CAMP_CMPGNS_L2_LTC
EDW_BIM_CAMP_CMPGNS_L3_LSTG
EDW_BIM_CAMP_CMPGNS_L3_LTC
EDW_BIM_CAMP_CMPGNS_L4_LSTG
EDW_BIM_CAMP_CMPGNS_L4_LTC
EDW_BIM_CAMP_CMPGNS_L5_LSTG
EDW_BIM_CAMP_CMPGNS_L5_LTC
EDW_BIM_CAMP_CMPGNS_L6_LSTG
EDW_BIM_CAMP_CMPGNS_L6_LTC
EDW_BIM_CAMP_CMPGNS_L7_LSTG
EDW_BIM_CAMP_CMPGNS_L7_LTC
EDW_BIM_CAMP_CMPGNS_L8_LSTG
EDW_BIM_CAMP_CMPGNS_L8_LTC
EDW_BIM_CAMP_CMPGNS_LSTG
EDW_BIM_CAMP_CMPGNS_LTC
EDW_BIM_CAMP_SCHEDULES_LSTG
EDW_BIM_CAMP_SCHEDULES_LTC
EDW_BIM_CMPGNS_A_LTC
EDW_BIM_CMPGNS_DENORM
EDW_BIM_CMPGNS_M
EDW_BIM_CMPSTATS_A_LTC
EDW_BIM_CMPSTATS_M
EDW_BIM_CSTA_CMPSTATS_LSTG
EDW_BIM_CSTA_CMPSTATS_LTC
EDW_BIM_EVENTS_A_LTC
EDW_BIM_EVENTS_M
EDW_BIM_EVNT_EVENTS_LSTG
EDW_BIM_EVNT_EVENTS_LTC
EDW_BIM_EVNT_EVTOFFERS_LSTG
EDW_BIM_EVNT_EVTOFFERS_LTC
EDW_BIM_IHMD_IH_MEDIA_LSTG
EDW_BIM_IHMD_IH_MEDIA_LTC
EDW_BIM_IHOT_IH_OUTCOME_LSTG
EDW_BIM_IHOT_IH_OUTCOME_LTC
EDW_BIM_IHRN_IH_REASON_LSTG
EDW_BIM_IHRN_IH_REASON_LTC
EDW_BIM_IHRS_IH_RESULT_LSTG
EDW_BIM_IHRS_IH_RESULT_LTC
EDW_BIM_IH_MEDIA_A_LTC
EDW_BIM_IH_MEDIA_M
EDW_BIM_IH_OUTCM_A_LTC
EDW_BIM_IH_OUTCM_M
EDW_BIM_IH_REASN_A_LTC
EDW_BIM_IH_REASN_M
EDW_BIM_IH_RESLT_A_LTC
EDW_BIM_IH_RESLT_M
EDW_BIM_LEADS_A_LTC
EDW_BIM_LEADS_M
EDW_BIM_LEAD_LEADLINES_LSTG
EDW_BIM_LEAD_LEADLINES_LTC
EDW_BIM_LEAD_LEADS_LSTG
EDW_BIM_LEAD_LEADS_LTC
EDW_BIM_LEAD_STATUS_A_LTC
EDW_BIM_LEAD_STATUS_M
EDW_BIM_LIST_SRCLSTS_LSTG
EDW_BIM_LIST_SRCLSTS_LTC
EDW_BIM_LSTA_LEADSTATUS_LSTG
EDW_BIM_LSTA_LEADSTATUS_LTC
EDW_BIM_MDCHN_A_LTC
EDW_BIM_MDCHN_M
EDW_BIM_MDCH_CHANNELS_LSTG
EDW_BIM_MDCH_CHANNELS_LTC
EDW_BIM_MDCH_MDCHN_LSTG
EDW_BIM_MDCH_MDCHN_LTC
EDW_BIM_MDCH_MDTYPES_LSTG
EDW_BIM_MDCH_MDTYPES_LTC
EDW_BIM_MDCH_MEDIA_LSTG
EDW_BIM_MDCH_MEDIA_LTC
EDW_BIM_MKSG_MKTSGMTS_LSTG
EDW_BIM_MKSG_MKTSGMTS_LTC
EDW_BIM_MKTSGMTS_A_LTC
EDW_BIM_MKTSGMTS_M
EDW_BIM_OFFERS_A_LTC
EDW_BIM_OFFERS_M
EDW_BIM_OFFR_OFFERS_LSTG
EDW_BIM_OFFR_OFFERS_LTC
EDW_BIM_OPPORTUNITIES_A_LTC
EDW_BIM_OPPORTUNITIES_M
EDW_BIM_OPPR_OPPLINES_LSTG
EDW_BIM_OPPR_OPPLINES_LTC
EDW_BIM_OPPR_OPRNTIES_LSTG
EDW_BIM_OPPR_OPRNTIES_LTC
EDW_BIM_OPP_STATUS_A_LTC
EDW_BIM_OPP_STATUS_M
EDW_BIM_OSTA_OPPSTATUS_LSTG
EDW_BIM_OSTA_OPPSTATUS_LTC
EDW_BIM_SOURCE_CODE_DETAILS
EDW_BIM_SRCLSTS_A_LTC
EDW_BIM_SRCLSTS_M
EDW_BIM_TGSMT_A_LTC
EDW_BIM_TGSMT_DENORM
EDW_BIM_TGSMT_M
EDW_BIM_TGST_TGSMT_L1_LSTG
EDW_BIM_TGST_TGSMT_L1_LTC
EDW_BIM_TGST_TGSMT_L2_LSTG
EDW_BIM_TGST_TGSMT_L2_LTC
EDW_BIM_TGST_TGSMT_L3_LSTG
EDW_BIM_TGST_TGSMT_L3_LTC
EDW_BIM_TGST_TGSMT_L4_LSTG
EDW_BIM_TGST_TGSMT_L4_LTC
EDW_BIM_TGST_TGSMT_L5_LSTG
EDW_BIM_TGST_TGSMT_L5_LTC
EDW_BIM_TGST_TGSMT_L6_LSTG
EDW_BIM_TGST_TGSMT_L6_LTC
EDW_BIM_TGST_TGSMT_L7_LSTG
EDW_BIM_TGST_TGSMT_L7_LTC
EDW_BIM_TGST_TGSMT_L8_LSTG
EDW_BIM_TGST_TGSMT_L8_LTC
EDW_BIM_TGST_TGSMT_LSTG
EDW_BIM_TGST_TGSMT_LTC
MLOG$_BIM_I_LEAD_FACTS
MLOG$_BIM_I_MARKETING_FACT
MLOG$_BIM_I_PROGRAMS_DENOR
MLOG$_BIM_I_SOURCE_CODES
MLOG$_BIM_R_CODE_DEFINITIO
MLOG$_BIM_I_BUDGETS_DENORM
MLOG$_BIM_I_BUDGET_FACTS
EDW_BIM_CMPGNS_M_TEMP
MLOG$_EDW_BIM_CMPGNS_A_LTC
MLOG$_EDW_BIM_CAMP_CMPGNS_
MLOG$_EDW_BIM_CAMP_CMPGNS_1
MLOG$_EDW_BIM_CAMP_CMPGNS_2
MLOG$_EDW_BIM_CAMP_CMPGNS_3
MLOG$_EDW_BIM_CAMP_CMPGNS_4
MLOG$_EDW_BIM_CAMP_CMPGNS_5
MLOG$_EDW_BIM_CAMP_CMPGNS_6
MLOG$_EDW_BIM_CAMP_CMPGNS_7
MLOG$_EDW_BIM_CAMP_CMPGNS_8
MLOG$_EDW_BIM_CAMP_SCHEDUL
MLOG$_EDW_BIM_CMPSTATS_A_L
MLOG$_EDW_BIM_CSTA_CMPSTAT
MLOG$_EDW_BIM_EVENTS_A_LTC
MLOG$_EDW_BIM_EVNT_EVENTS_
MLOG$_EDW_BIM_EVNT_EVTOFFE
MLOG$_EDW_BIM_IH_MEDIA_A_L
MLOG$_EDW_BIM_IHMD_IH_MEDI
EDW_BIM_CMPSTATS_M_TEMP
MLOG$_EDW_BIM_IH_OUTCM_A_L
MLOG$_EDW_BIM_IHOT_IH_OUTC
MLOG$_EDW_BIM_IH_REASN_A_L
EDW_BIM_EVENTS_M_TEMP
MLOG$_EDW_BIM_IHRN_IH_REAS
MLOG$_EDW_BIM_IH_RESLT_A_L
MLOG$_EDW_BIM_IHRS_IH_RESU
MLOG$_EDW_BIM_LEADS_A_LTC
MLOG$_EDW_BIM_LEAD_LEADS_L
MLOG$_EDW_BIM_LEAD_LEADLIN
EDW_BIM_IH_MEDIA_M_TEMP
MLOG$_EDW_BIM_LEAD_STATUS_
MLOG$_EDW_BIM_LSTA_LEADSTA
EDW_BIM_IH_OUTCM_M_TEMP
MLOG$_EDW_BIM_MDCHN_A_LTC
EDW_BIM_IH_REASN_M_TEMP
MLOG$_EDW_BIM_MDCH_CHANNEL
MLOG$_EDW_BIM_MDCH_MDTYPES
EDW_BIM_IH_RESLT_M_TEMP
EDW_BIM_LEADS_M_TEMP
MLOG$_EDW_BIM_MDCH_MEDIA_L
MLOG$_EDW_BIM_MDCH_MDCHN_L
BIM_I_MARKETING_FACTS_STG
BIM_I_MKT_RATES
BIM_I_BGT_RATES
BIM_I_BUDGET_FACTS
BIM_I_BUDGET_FACTS_STG
BIM_CAMP_ACQU_SUMM_TEMP
BIM_I_BUDGETS_DENORM
BIM_I_TOP_OBJECTS
EDW_BIM_LEAD_STATUS_M_TEMP
MLOG$_EDW_BIM_MKTSGMTS_A_L
EDW_BIM_MDCHN_M_TEMP
EDW_BIM_MKTSGMTS_M_TEMP
MLOG$_EDW_BIM_MKSG_MKTSGMT
EDW_BIM_OFFERS_M_TEMP
MLOG$_EDW_BIM_OFFERS_A_LTC
EDW_BIM_OPPORTUNITIES_M_TEMP
MLOG$_EDW_BIM_OFFR_OFFERS_
MLOG$_EDW_BIM_OPPORTUNITIE
EDW_BIM_OPP_STATUS_M_TEMP
MLOG$_EDW_BIM_OPPR_OPRNTIE
EDW_BIM_SRCLSTS_M_TEMP
MLOG$_EDW_BIM_OPPR_OPPLINE
EDW_BIM_TGSMT_M_TEMP
MLOG$_EDW_BIM_OPP_STATUS_A
MLOG$_EDW_BIM_OSTA_OPPSTAT
MLOG$_EDW_BIM_SRCLSTS_A_LT
BIM_EDW_RVCT_DLY_F_TEMP
MLOG$_EDW_BIM_LIST_SRCLSTS
MLOG$_EDW_BIM_TGSMT_A_LTC
MLOG$_EDW_BIM_TGST_TGSMT_L
BIM_EDW_RVCT_MTH_F_TEMP
MLOG$_EDW_BIM_TGST_TGSMT_L1
MLOG$_EDW_BIM_TGST_TGSMT_L2
MLOG$_EDW_BIM_TGST_TGSMT_L3
BIM_EDW_CMPFRCST_F_TEMP
MLOG$_EDW_BIM_TGST_TGSMT_L4
MLOG$_EDW_BIM_TGST_TGSMT_L5
BIM_EDW_EVTFRCST_F_TEMP
MLOG$_EDW_BIM_TGST_TGSMT_L6
MLOG$_EDW_BIM_TGST_TGSMT_L7
BIM_EDW_INTRCTNS_F_TEMP
MLOG$_EDW_BIM_TGST_TGSMT_L8
MLOG$_BIM_EDW_CMPFRCST_F
BIM_EDW_LEADS_F_TEMP
MLOG$_BIM_EDW_EVTFRCST_F
MLOG$_BIM_EDW_LEADS_F
MLOG$_BIM_EDW_OPRNTIES_F
BIM_EDW_OPRNTIES_F_TEMP

Tables In AR

2008-01-09T08:44:00.001-08:00

AR_ACTION_NOTIFICATIONS
AR_ADJUSTMENTS_ALL
AR_ADJUSTMENTS_REP_ITF
AR_AE_ALLOC_REC_GT
AR_AGING_BUCKETS
AR_AGING_BUCKET_LINES_B
AR_AGING_BUCKET_LINES_TL
AR_APPROVAL_ACTION_HISTORY
AR_APPROVAL_USER_LIMITS
AR_APP_RULES
AR_APP_RULE_DETAILS
AR_APP_RULE_SETS
AR_ARCHIVE_CONTROL
AR_ARCHIVE_CONTROL_DETAIL
AR_ARCHIVE_DETAIL
AR_ARCHIVE_HEADER
AR_ARCHIVE_PURGE_INTERIM
AR_ARCHIVE_PURGE_LOG
AR_AUDIT_DATA
AR_AUTOCASH_HIERARCHIES
AR_AUTOCASH_RULES
AR_AUTOREC_EXCEPTIONS
AR_BANK_DIRECTORY
AR_BATCHES_ALL
AR_BATCH_SOURCES_ALL
AR_BPA_AREA_ITEMS
AR_BPA_CONTENT_AREAS_B
AR_BPA_CONTENT_AREAS_TL
AR_BPA_DATASRC_APPS_B
AR_BPA_DATASRC_APPS_TL
AR_BPA_DATA_SOURCES_B
AR_BPA_DATA_SOURCES_TL
AR_BPA_DATA_SRC_PARAMS
AR_BPA_ITEMS_B
AR_BPA_ITEMS_TL
AR_BPA_RULES_B
AR_BPA_RULES_TL
AR_BPA_RULE_ATTRIBUTES_B
AR_BPA_RULE_ATTRIBUTES_TL
AR_BPA_RULE_TEMPLATES
AR_BPA_TEMPLATES_B
AR_BPA_TEMPLATES_TL
AR_BPA_URLS_B
AR_BPA_URLS_TL
AR_BPA_URL_PARAMS
AR_BR_FMT_TMP
AR_BR_STAMP_VALUES_ALL
AR_BR_STATUS_REP_ITF
AR_BR_STATUS_SUM_ITF
AR_BR_TRX_BATCH_RPT
AR_CALL_ACTIONS
AR_CASH_BASIS_DISTS_ALL
AR_CASH_RECEIPTS_ALL
AR_CASH_RECEIPT_HISTORY_ALL
AR_CHANGE_MATRIX
AR_CMGT_AUTO_RECOMMENDS
AR_CMGT_AUTO_RULES
AR_CMGT_AUTO_RULE_DTLS
AR_CMGT_BANK_REF_ACCTS
AR_CMGT_BANK_REF_DATA
AR_CMGT_CASE_FOLDERS
AR_CMGT_CF_AGING_DTLS
AR_CMGT_CF_ANL_NOTES
AR_CMGT_CF_DNB_DTLS
AR_CMGT_CF_DTLS
AR_CMGT_CF_RECOMMENDS
AR_CMGT_CHECK_LISTS
AR_CMGT_CHECK_LIST_DTLS
AR_CMGT_COLLATERAL_DATA
AR_CMGT_CREDIT_REQUESTS
AR_CMGT_CURR_USAGE_GT
AR_CMGT_DATA_POINTS_B
AR_CMGT_DATA_POINTS_TL
AR_CMGT_DNB_ELEMENTS_B
AR_CMGT_DNB_ELEMENTS_TL
AR_CMGT_DNB_MAPPINGS
AR_CMGT_FINANCIAL_DATA
AR_CMGT_GUARANTOR_DATA
AR_CMGT_OTHER_DATA
AR_CMGT_SCORES
AR_CMGT_SCORE_DTLS
AR_CMGT_SCORE_WEIGHTS
AR_CMGT_SETUP_OPTIONS
AR_CMGT_TRADE_REF_DATA
AR_CM_SUM_TRX_DAYS_GT
AR_COLIND
AR_COLLECTION_INDICATORS_ALL
AR_COLLECTORS
AR_CONC_PROCESS_REQUESTS
AR_CONC_REQUEST_MESSAGES
AR_CONFIRMATION_ACTIONS
AR_CONS_INV_ALL
AR_CONS_INV_TRX_ALL
AR_CONS_INV_TRX_LINES_ALL
AR_CORRESPONDENCES_ALL
AR_CORR_PAY_SCHED_ALL
AR_CREDIT_HISTORIES
AR_CREDIT_MEMO_AMOUNTS
AR_CUSTOMER_ALT_NAMES
AR_CUSTOMER_BALANCE_ITF
AR_CUSTOMER_CALLS_ALL
AR_CUSTOMER_CALL_TOPICS_ALL
AR_CUSTOMER_PROFILES
AR_CUSTOMER_PROFILE_AMOUNTS
AR_CUSTOMER_PROFILE_CLASSES
AR_CUST_PROF_CLASS_AMOUNTS
AR_CUST_SEARCH_GT
AR_DEBUG
AR_DISPUTE_HISTORY
AR_DISTRIBUTIONS_ALL
AR_DISTRIBUTION_SETS_ALL
AR_DISTRIBUTION_SET_LINES_ALL
AR_DOCUMENT_TRANSFERS
AR_DOC_SEQUENCE_AUDIT
AR_DUNNING_LETTERS_B
AR_DUNNING_LETTERS_CUSTOM_TL
AR_DUNNING_LETTERS_TL
AR_DUNNING_LETTER_SETS
AR_DUNNING_LETTER_SET_LINES
AR_INTERIM_CASH_RCPT_LINES_ALL
AR_INTERIM_CASH_RECEIPTS_ALL
AR_INTERIM_POSTING
AR_IREC_CUSTOM_SRCH_GT
AR_IREC_PAYMENT_LIST_GT
AR_JOURNAL_INTERIM_ALL
AR_LOCATION_ACCOUNTS_ALL
AR_LOCATION_COMBINATIONS
AR_LOCATION_RATES
AR_LOCATION_VALUES
AR_LOCKBOXES_ALL
AR_LOOKUPS_OLD
AR_LOOKUP_TYPES_OLD
AR_MC_ADJUSTMENTS
AR_MC_BATCHES
AR_MC_CASH_BASIS_DISTS_ALL
AR_MC_CASH_RECEIPTS
AR_MC_CASH_RECEIPT_HIST
AR_MC_DISTRIBUTIONS_ALL
AR_MC_MISC_CASH_DISTS
AR_MC_PAYMENT_SCHEDULES
AR_MC_RATE_ADJUSTMENTS
AR_MC_RECEIVABLE_APPS
AR_MC_TRANSACTION_HISTORY
AR_MEMO_LINES_ALL_B
AR_MEMO_LINES_ALL_TL
AR_MISC_CASH_DISTRIBUTIONS_ALL
AR_MRC_CASH_HEADER
AR_MRC_CASH_LINES
AR_MRC_INQ_TRANS_BALANCES
AR_NOTES
AR_PARALLEL_AUTOINSTALL
AR_PAYMENTS_INTERFACE_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_PERIODS
AR_PERIOD_TYPES
AR_POSTING_CONTROL
AR_POSTING_REPORT_INTERIM
AR_PURGE_OE_EXCEPTIONS
AR_PURGE_REC_AUX
AR_PURGE_TRX_AUX
AR_RAMC_AUDIT_TRAIL
AR_RATE_ADJUSTMENTS_ALL
AR_RECEIPTS_REP_ITF
AR_RECEIPT_CLASSES
AR_RECEIPT_METHODS
AR_RECEIPT_METHOD_ACCOUNTS_ALL
AR_RECEIVABLES_TRX_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
AR_REVENUE_ADJUSTMENTS_ALL
AR_SALES_TAX
AR_SALES_TAX_REP_ITF
AR_SELECTION_CRITERIA
AR_STANDARD_TEXT_B
AR_STANDARD_TEXT_TL
AR_STATEMENTS_HISTORY_ALL
AR_STATEMENTS_HISTORY_ALL_TEMP
AR_STATEMENT_CYCLES
AR_STATEMENT_CYCLE_DATES_ALL
AR_STATEMENT_CYCLE_INTERVALS
AR_STATEMENT_HEADERS
AR_STATEMENT_LINE_CLUSTERS
AR_SUM_REF_EVENT_HIST
AR_SYSTEM_PARAMETERS_ALL
AR_TAX_CONDITIONS_ALL
AR_TAX_CONDITION_ACTIONS_ALL
AR_TAX_CONDITION_LINES_ALL
AR_TAX_EXTRACT_DCL_ITF
AR_TAX_EXTRACT_MATRIX_ITF
AR_TAX_EXTRACT_SUB_ITF
AR_TAX_GROUP_CODES_ALL
AR_TAX_INTERFACE
AR_TA_ASGN_TO_INT_ALL
AR_TA_CASHAPP_OB_ALL
AR_TA_CR_AGEN_INF_ALL
AR_TA_CUST_HIER_CHILD
AR_TA_CUST_HIER_PARNT
AR_TA_CUST_INT_ALL
AR_TA_CUST_TRXSTR_ALL
AR_TA_DEDN_ASSGNS_ALL
AR_TA_DEDN_INT_ALL
AR_TA_DEDN_RELATE_ALL
AR_TA_LEGACY_CUST_INT
AR_TA_LEGACY_STAT_INT
AR_TA_PAYMNT_HIST_ALL
AR_TA_PROF_ASSGNT_ALL
AR_TA_PROMOTIONS_ALL
AR_TA_PROMOTIONS_INT
AR_TA_PROM_CUST_ALL
AR_TA_PROM_CUST_MAP
AR_TA_PROM_LINES_INT
AR_TA_PROM_PAYMNT_ALL
AR_TA_PROM_PAYMNT_TYP
AR_TA_PROM_PRODS_ALL
AR_TA_PROM_STATUS_MAP
AR_TA_RECON_INFO_ALL
AR_TA_RECV_TRXSET_ALL
AR_TA_REMIT_HIST_ALL
AR_TA_REMIT_PROF_ALL
AR_TA_RISK_COMENT_ALL
AR_TA_RULES_ALL
AR_TA_RULE_OUTPUT
AR_TA_RULE_SETS_ALL
AR_TA_RULE_SET_LN_ALL
AR_TA_TRX_SETS_ALL
AR_TA_TRX_SET_LN_ALL
AR_TA_TRX_TO_CREATE
AR_TA_TRX_TYP_INT_ALL
AR_TA_VERSIONS
AR_TRANSACTIONS_REP_ITF
AR_TRANSACTION_HISTORY_ALL
AR_TRANSMISSIONS_ALL
AR_TRANSMISSION_FORMATS
AR_TRANS_FIELD_FORMATS
AR_TRANS_RECORD_FORMATS
AR_TRX_BAL_SUMMARY
AR_TRX_SUMMARY
AR_TRX_SUMMARY_HIST
AR_VAT_TAX_ALL_B
AR_VAT_TAX_ALL_TL
HZ_APPLICATION_TRANS_GT
HZ_BANK_VAL_GT
HZ_BILLING_PREFERENCES
HZ_CERTIFICATIONS
HZ_CITIZENSHIP
HZ_CLASS_CATEGORIES
HZ_CLASS_CATEGORY_USES
HZ_CLASS_CODE_DENORM
HZ_CLASS_CODE_RELATIONS
HZ_CODE_ASSIGNMENTS
HZ_CONTACT_POINTS
HZ_CONTACT_POINT_VAL_GT
HZ_CONTACT_PREFERENCES
HZ_CONTACT_RESTRICTIONS
HZ_CREDIT_PROFILES
HZ_CREDIT_PROFILE_AMTS
HZ_CREDIT_RATINGS
HZ_CREDIT_USAGES
HZ_CREDIT_USAGE_RULES
HZ_CREDIT_USAGE_RULE_SETS_B
HZ_CREDIT_USAGE_RULE_SETS_TL
HZ_CUSTOMER_MERGE_LOG
HZ_CUSTOMER_PROFILES
HZ_CUSTOMER_PROFILES_M
HZ_CUST_ACCOUNTS
HZ_CUST_ACCOUNTS_M
HZ_CUST_ACCOUNT_ROLES
HZ_CUST_ACCOUNT_ROLES_M
HZ_CUST_ACCT_RELATE_ALL
HZ_CUST_ACCT_RELATE_ALL_M
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_ACCT_SITES_ALL_M
HZ_CUST_CONTACT_POINTS
HZ_CUST_MERGE_LOG_DICT
HZ_CUST_PROFILE_AMTS
HZ_CUST_PROFILE_AMTS_M
HZ_CUST_PROFILE_CLASSES
HZ_CUST_PROF_CLASS_AMTS
HZ_CUST_SITE_USES_ALL
HZ_CUST_SITE_USES_ALL_M
HZ_DNB_REQUEST_LOG
HZ_DQM_DETAILS_GT
HZ_DQM_PARTIES_GT
HZ_DQM_STAGE_GT
HZ_DQM_STAGE_LOG
HZ_DQM_SYNC_GT
HZ_DQM_SYNC_INTERFACE
HZ_DSS_ASSIGNMENTS
HZ_DSS_CRITERIA
HZ_DSS_ENTITIES
HZ_DSS_GROUPS_B
HZ_DSS_GROUPS_TL
HZ_DSS_SCHEME_FUNCTIONS
HZ_DSS_SECURED_ENTITIES
HZ_DUP_BATCH
HZ_DUP_EXCLUSIONS
HZ_DUP_MATCH_DETAILS
HZ_DUP_MERGE_PARTIES
HZ_DUP_SETS
HZ_DUP_SET_PARTIES
HZ_EDUCATION
HZ_EMPLOYMENT_HISTORY
HZ_ENTITY_ATTRIBUTES
HZ_EXT_DATA_RULES_TL
HZ_FINANCIAL_NUMBERS
HZ_FINANCIAL_PROFILE
HZ_FINANCIAL_REPORTS
HZ_GROUP_VAL_GT
HZ_HIERARCHY_NODES
HZ_INDUSTRIAL_CLASSES
HZ_INDUSTRIAL_CLASS_APP
HZ_INDUSTRIAL_REFERENCE
HZ_LOCATIONS
HZ_LOCATION_VAL_GT
HZ_LOC_ASSIGNMENTS
HZ_LOG
HZ_LOG2
HZ_MATCHED_CONTACTS_GT
HZ_MATCHED_CPTS_GT
HZ_MATCHED_PARTIES_GT
HZ_MATCHED_PARTY_SITES_GT
HZ_MATCH_RULES_B
HZ_MATCH_RULES_TL
HZ_MATCH_RULE_PRIMARY
HZ_MATCH_RULE_SECONDARY
HZ_MERGE_BATCH
HZ_MERGE_DICTIONARY
HZ_MERGE_ENTITY_ATTRIBUTES
HZ_MERGE_PARTIES
HZ_MERGE_PARTIES_SUGG
HZ_MERGE_PARTYDTLS_SUGG
HZ_MERGE_PARTY_DETAILS
HZ_MERGE_PARTY_HISTORY
HZ_MERGE_PARTY_LOG
HZ_MOBILE_PREFIXES
HZ_ORGANIZATION_INDICATORS
HZ_ORGANIZATION_PROFILES
HZ_ORG_CONTACTS
HZ_ORG_CONTACT_ROLES
HZ_ORG_CONTACT_VAL_GT
HZ_ORG_PROFILE_VAL_GT
HZ_PARAM_TAB
HZ_PARTIES
HZ_PARTY_INTERFACE
HZ_PARTY_INTERFACE_ERRORS
HZ_PARTY_PREFERENCES
HZ_PARTY_RELATIONSHIPS
HZ_PARTY_SCORE_DTLS_GT
HZ_PARTY_SITES
HZ_PARTY_SITE_USES
HZ_PARTY_SITE_VAL_GT
HZ_PARTY_VAL_GT
HZ_PERSON_INTEREST
HZ_PERSON_LANGUAGE
HZ_PERSON_PROFILES
HZ_PHONE_AREA_CODES
HZ_PHONE_COUNTRY_CODES
HZ_PHONE_FORMATS
HZ_PRIMARY_TRANS
HZ_PURGE_BATCHES
HZ_PURGE_CANDIDATES
HZ_PURGE_GT
HZ_REFERENCES
HZ_REGISTRATIONS
HZ_REG_VERIFICATIONS
HZ_RELATIONSHIPS
HZ_RELATIONSHIP_TYPES
HZ_RELATIONSHIP_VAL_GT
HZ_ROLE_RESPONSIBILITY
HZ_SECONDARY_TRANS
HZ_SECURITY_ISSUED
HZ_SELECT_DATA_SOURCES
HZ_STAGED_CONTACTS
HZ_STAGED_CONTACT_POINTS
HZ_STAGED_PARTIES
HZ_STAGED_PARTY_SITES
HZ_STOCK_MARKETS
HZ_STYLES_B
HZ_STYLES_TL
HZ_STYLE_FMT_LAYOUTS_B
HZ_STYLE_FMT_LAYOUTS_TL
HZ_STYLE_FMT_LOCALES
HZ_STYLE_FMT_VARIATIONS
HZ_STYLE_FORMATS_B
HZ_STYLE_FORMATS_TL
HZ_SUSPENSION_ACTIVITY
HZ_THIRDPARTY_EXCEPS
HZ_THIRDPARTY_RULE
HZ_TIMEZONES
HZ_TIMEZONES_TL
HZ_TIMEZONE_MAPPING
HZ_TRANS_ATTRIBUTES_B
HZ_TRANS_ATTRIBUTES_TL
HZ_TRANS_FUNCTIONS_B
HZ_TRANS_FUNCTIONS_TL
HZ_USER_CREATE_RULES
HZ_USER_ORG_GT
HZ_USER_OVERWRITE_RULES
HZ_WIN_SOURCE_EXCEPS
HZ_WORD_LISTS
HZ_WORD_REPLACEMENTS
HZ_WORK_CLASS
JE_DE_AR_BATCHES
JE_DE_REMITTANCE_RESULTS
JG_ZZ_AR_BALANCES
JG_ZZ_AR_TMP_ACCOUNT
JG_ZZ_AR_TMP_BAL
JG_ZZ_AR_TMP_DETAIL
JG_ZZ_BATCH_NUMBER_R106
JG_ZZ_II_INT_RATES_ALL
JG_ZZ_INTEREST_BATCHES_ALL
JG_ZZ_INTEREST_BATCH_R106
JG_ZZ_INTEREST_INVOICES_ALL
JG_ZZ_INTEREST_MEMOS_R106
JG_ZZ_INT_INV_LINES_ALL
JG_ZZ_INT_MEMO_INVOICES_R106
JG_ZZ_JGZZCSLP_MESSAGES
JG_ZZ_LOOKUP_VALUES_ALL_R110
JG_ZZ_SYSTEM_PARAMETERS_R106
MLOG$_HZ_RELATIONSHIPS
MONTH_SRC_TI
RA_ACCOUNT_COMBINATIONS
RA_ACCOUNT_DEFAULTS_ALL
RA_ACCOUNT_DEFAULT_SEGMENTS
RA_ADDRESSES_ALL
RA_BATCHES_ALL
RA_BATCH_SOURCES_ALL
RA_CM_REQUESTS_ALL
RA_CM_REQUEST_LINES_ALL
RA_CONTACTS
RA_CONTACT_PHONES_INT_ALL
RA_CONTACT_ROLES
RA_CUSTOMERS
RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_BANKS_INT_ALL
RA_CUSTOMER_MERGES
RA_CUSTOMER_MERGE_HEADERS
RA_CUSTOMER_PROFILES_INT_ALL
RA_CUSTOMER_RELATIONSHIPS_ALL
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_PAY_METHOD_INT_ALL
RA_CUST_RECEIPT_METHODS
RA_CUST_TRX_LINE_GL_DIST_ALL
RA_CUST_TRX_LINE_SALESREPS_ALL
RA_CUST_TRX_TYPES_ALL
RA_GROUPING_RULES
RA_GROUPING_TRX_TYPES
RA_GROUP_BYS
RA_GROUP_BY_COLUMNS
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_ERRORS_ALL
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
RA_INT_LINES_BAK
RA_ITEM_EXCEPTION_RATES
RA_LINE_ORDERING_RULES
RA_LINE_ORDER_BYS
RA_LINE_ORDER_BY_COLUMNS
RA_MC_BATCHES
RA_MC_CUSTOMER_TRX
RA_MC_CUSTOMER_TRX_LINES
RA_MC_TRX_LINE_GL_DIST
RA_PHONES
RA_RECUR_INTERIM
RA_REGIONS
RA_REMIT_TOS_ALL
RA_RULES
RA_RULE_SCHEDULES
RA_SALESREPS_ALL_OLD
RA_SALESREP_TERRITORIES
RA_SALESREP_TERRITORIES_WH
RA_SITE_USES_ALL
RA_TAX_EXEMPTIONS_ALL
RA_TERMS_B
RA_TERMS_LINES
RA_TERMS_LINES_DISCOUNTS
RA_TERMS_TL
RA_TERRITORIES
RUPD$_HZ_RELATIONSHIPS
TOTAL_CUST
AR_TAX_CODE_COMBINATION_ID_GT
OCM_CREDIT_REVIEW_GT
DR$HZ_STAGE_CONTACT_T1$I
DR$HZ_STAGE_CONTACT_T1$K
DR$HZ_STAGE_CONTACT_T1$R
DR$HZ_STAGE_CPT_T1$I
DR$HZ_STAGE_CONTACT_T1$N
DR$HZ_STAGE_CPT_T1$K
DR$HZ_STAGE_CPT_T1$R
DR$HZ_STAGE_CPT_T1$N
DR$HZ_CLASS_CODE_DENORM_T1$I
DR$HZ_CLASS_CODE_DENORM_T1$K
DR$HZ_CLASS_CODE_DENORM_T1$R
DR$HZ_CLASS_CODE_DENORM_T1$N
DR$HZ_STAGE_PARTIES_T1$I
DR$HZ_STAGE_PARTY_SITES_T1$I
DR$HZ_STAGE_PARTIES_T1$K
DR$HZ_STAGE_PARTY_SITES_T1$K
DR$HZ_STAGE_PARTIES_T1$R
DR$HZ_STAGE_PARTY_SITES_T1$R
DR$HZ_STAGE_PARTIES_T1$N
DR$HZ_STAGE_PARTY_SITES_T1$N
HZ_SRCH_PSITES
HZ_DUP_RESULTS
HZ_INT_DUP_RESULTS
HZ_IMP_DUP_DETAILS
HZ_IMP_DUP_PARTIES
HZ_IMP_INT_DEDUP_RESULTS
HZ_IMP_PARTIES_SG
HZ_IMP_ADDRESSES_SG
HZ_IMP_CONTACTPTS_SG
HZ_IMP_CREDITRTNGS_SG
HZ_IMP_CLASSIFICS_SG
HZ_IMP_FINREPORTS_SG
HZ_IMP_FINNUMBERS_SG
HZ_IMP_RELSHIPS_SG
HZ_IMP_CONTACTS_SG
HZ_IMP_CONTACTROLES_SG
HZ_IMP_ADDRESSUSES_SG
AR_IREC_CUSTOM_CUST_GT
AR_REVENUE_ASSIGNMENTS_GT
AR_STATEMENT_FINCHRG_GT
AR_TRX_ERRORS_GT
AR_BPA_PRINT_REQUESTS
HZ_GEOGRAPHY_TYPES_B
HZ_GEO_NAME_REFERENCE_LOG
HZ_IMP_FINREPORTS_INT
HZ_IMP_FINNUMBERS_INT
HZ_GEO_NAME_REFERENCES
HZ_IMP_CLASSIFICS_INT
HZ_GEO_STRUCT_MAP
HZ_IMP_RELSHIPS_INT
HZ_GEO_STRUCT_MAP_DTL
HZ_IMP_CONTACTROLES_INT
HZ_IMP_CONTACTS_INT
HZ_GEO_STRUCTURE_LEVELS
HZ_SRCH_CONTACTS
HZ_IMP_ADDRESSUSES_INT
HZ_IMP_ERRORS
HZ_IMP_TMP_ERRORS
HZ_SRCH_CPTS
HZ_IMP_OSR_CHANGE
HZ_IMP_TMP_REL_END_DATE
HZ_SRCH_PARTIES
HZ_ORIG_SYS_MAPPING
HZ_ORIG_SYS_REFERENCES
HZ_ADAPTER_LOGS
AR_TRX_HEADER_GT
AR_TRX_DIST_GT
AR_TRX_LINES_GT
AR_TRX_SALESCREDITS_GT
HZ_DUP_WORKER_CHUNK_GT
HZ_INT_DUP_RESULTS_GT
AR_TAX_EXTR_SUB_AP_EXT
AR_TAX_EXTR_SUB_AR_EXT
AR_TAX_EXTR_SUB_COM_EXT
AR_CCID_CORRECTIONS_ALL
HZ_IMP_WORK_UNITS
HZ_EMAIL_DOMAINS
AR_BPA_PAGE_SETUPS_B
HZ_IMP_PARTIES_INT
HZ_GEOGRAPHIES
HZ_IMP_ADDRESSES_INT
AR_BPA_PAGE_SETUPS_TL
HZ_GEOGRAPHY_IDENTIFIERS
HZ_IMP_CONTACTPTS_INT
AR_BPA_TEMPLATE_FILES
HZ_GEOGRAPHY_RANGES
AR_BPA_TEMPLATE_FIELDS
HZ_GEOGRAPHY_TYPES_TL
HZ_IMP_CREDITRTNGS_INT
HZ_IMP_ADAPTERS
HZ_IMP_BATCH_DETAILS
HZ_IMP_BATCH_SUMMARY
HZ_LOCATION_PROFILES
HZ_ADAPTERS
HZ_ADAPTER_TERRITORIES
CTX_OUTPUT
CTX_ADM
DR$HZ_CUST_ACCT_SITES_ALL_T1$I
DR$HZ_CUST_ACCT_SITES_ALL_T1$K
DR$HZ_CUST_ACCT_SITES_ALL_T1$R
DR$HZ_CUST_ACCT_SITES_ALL_T1$N
AQ$_AR_REV_REC_QT_S
AR_REV_REC_QT
AQ$_AR_REV_REC_QT_H
AQ$_AR_REV_REC_QT_I
AQ$_AR_REV_REC_QT_T
AQ$AR_REV_REC_QT
AQ$AR_REV_REC_QT_S
AQ$AR_REV_REC_QT_R
CTX_QUERY
CTX_DDL
CTX_PREFERENCES
AD_CTX_DDL

Tables In AP

2008-01-09T08:37:00.000-08:00

AP_1096_DATA_ALL
AP_1099_TAPE_DATA_ALL
AP_ACCOUNTING_EVENTS_ALL
AP_AE_HEADERS_ALL
AP_AE_LINES_ALL
AP_AGING_PERIODS
AP_AGING_PERIOD_LINES
AP_APPROVERS_LIST_GT
AP_AUD_AUDITORS
AP_AUD_AUDIT_REASONS
AP_AUD_AUTO_AUDITS
AP_AUD_QUEUES
AP_AUD_RULE_ASSIGNMENTS_ALL
AP_AUD_RULE_SETS
AP_AUD_WORKLOADS
AP_AWT_BUCKETS_ALL
AP_AWT_GROUPS
AP_AWT_GROUP_TAXES_ALL
AP_AWT_TAX_RATES_ALL
AP_AWT_TEMP_DISTRIBUTIONS_ALL
AP_BANK_ACCOUNTS_ALL
AP_BANK_ACCOUNT_USES_ALL
AP_BANK_BRANCHES
AP_BANK_CHARGES
AP_BANK_CHARGE_LINES
AP_BANK_TRANSMISSIONS
AP_BATCHES_ALL
AP_CARDS_ALL
AP_CARD_CODES_ALL
AP_CARD_CODE_SETS_ALL
AP_CARD_CURRENCIES
AP_CARD_GL_ACCTS_ALL
AP_CARD_GL_SETS_ALL
AP_CARD_PROFILES_ALL
AP_CARD_PROFILE_LIMITS_ALL
AP_CARD_PROGRAMS_ALL
AP_CARD_REQUESTS_ALL
AP_CARD_SUPPLIERS_ALL
AP_CHECKRUN_CONC_PROCESSES_ALL
AP_CHECKRUN_CONFIRMATIONS_ALL
AP_CHECKS_ALL
AP_CHECK_FORMATS
AP_CHECK_INTEGERS
AP_CHECK_STOCKS_ALL
AP_CHECK_TRANSMISSIONS
AP_CHRG_ALLOCATIONS_ALL
AP_CHRG_ALLOCATIONS_ALL_EFC
AP_CREDIT_CARD_TRXNS_ALL
AP_DBI_LOG
AP_DISTRIBUTION_SETS_ALL
AP_DISTRIBUTION_SET_LINES_ALL
AP_DOC_SEQUENCE_AUDIT
AP_DUPLICATE_VENDORS_ALL
AP_ENCUMBRANCE_LINES_ALL
AP_ENCUMBRANCE_LINES_ALL_EFC
AP_EXPENSE_FEED_DISTS_ALL
AP_EXPENSE_FEED_LINES_ALL
AP_EXPENSE_REPORTS_ALL
AP_EXPENSE_REPORTS_OLD
AP_EXPENSE_REPORT_HEADERS_ALL
AP_EXPENSE_REPORT_LINES_ALL
AP_EXPENSE_REPORT_PARAMS_ALL
AP_FLEX_SEGMENT_MAPPINGS_ALL
AP_HISTORY_CHECKS_ALL
AP_HISTORY_INVOICES_ALL
AP_HISTORY_INV_PAYMENTS_ALL
AP_HOLDS_ALL
AP_HOLD_CODES
AP_INCOME_TAX_REGIONS
AP_INCOME_TAX_TYPES
AP_INTEREST_PERIODS
AP_INTERFACE_CONTROLS
AP_INTERFACE_REJECTIONS
AP_INVOICES_ALL
AP_INVOICES_INTERFACE
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICE_KEY_IND_ALL
AP_INVOICE_KEY_IND_OLD
AP_INVOICE_LINES_INTERFACE
AP_INVOICE_PAYMENTS_ALL
AP_INVOICE_PREPAYS_ALL
AP_INVOICE_RELATIONSHIPS
AP_INVOICE_TRANSMISSIONS
AP_INV_APRVL_HIST_ALL
AP_INV_SELECTION_CRITERIA_ALL
AP_LIABILITY_BALANCE
AP_LOOKUP_CODES_OLD
AP_LOOKUP_TYPES_OLD
AP_MATCHED_RECT_ADJ_ALL
AP_MC_CHECKS
AP_MC_INVOICES
AP_MC_INVOICE_DISTS
AP_MC_INVOICE_PAYMENTS
AP_MC_PAYMENT_DISTS_ALL
AP_MC_PAYMENT_HISTORY
AP_MC_RECON_DISTS_ALL
AP_MC_TRIAL_BALANCE
AP_MRC_ACCOUNTING
AP_MRC_AE_LINES_ALL
AP_MRC_INQ_INVOICE_CONVERSIONS
AP_MRC_INQ_INVOICE_DISTS
AP_MRC_INQ_PAYMENT_CONVERSIONS
AP_MRC_INQ_PAYMENT_INVOICES
AP_ORG_TEMP
AP_OTHER_PERIODS
AP_OTHER_PERIOD_TYPES
AP_PAYMENT_DISTRIBUTIONS_ALL
AP_PAYMENT_HISTORY_ALL
AP_PAYMENT_KEY_IND_ALL
AP_PAYMENT_KEY_IND_OLD
AP_PAYMENT_PROGRAMS
AP_PAYMENT_REP_ITF
AP_PAYMENT_SCHEDULES_ALL
AP_PBATCH_SETS_ALL
AP_PBATCH_SET_LINES_ALL
AP_POL_CAT_OPTIONS_ALL
AP_POL_CONTEXT
AP_POL_EXRATE_OPTIONS_ALL
AP_POL_EXRATE_TOLERANCES
AP_POL_HEADERS
AP_POL_ITEMIZATIONS
AP_POL_LINES
AP_POL_LINES_HISTORY
AP_POL_LOCATIONS_B
AP_POL_LOCATIONS_TL
AP_POL_SCHEDULE_OPTIONS
AP_POL_SCHEDULE_PERIODS
AP_POL_VIOLATIONS_ALL
AP_POL_VIOLATIONS_GT
AP_PURGE_INVOICE_LIST
AP_R115_UPGRADE
AP_RECON_CHECK_RESULTS
AP_RECON_DETAILS
AP_RECON_DISTRIBUTIONS_ALL
AP_RECON_ERROR_CHK_GROUPS
AP_RECON_ERROR_CHK_GROUP_LINES
AP_RECON_LOCKS
AP_RECON_RECORD_CODES
AP_RECON_RECORD_SPECS
AP_RECON_SUMMARIES
AP_RECON_TRANSACTION_CODES
AP_RECURRING_PAYMENTS_ALL
AP_REPORTING_ENTITIES_ALL
AP_REPORTING_ENTITY_LINES_ALL
AP_SELECTED_INVOICES_ALL
AP_SELECTED_INVOICE_CHECKS_ALL
AP_SUPPLIER_BALANCE_ITF
AP_SYSTEM_PARAMETERS_ALL
AP_TAX_CODES_ALL
AP_TAX_DERIVATIONS
AP_TAX_RECVRY_RATES_ALL
AP_TAX_RECVRY_RULES_ALL
AP_TEMP_APPROVAL_ALL
AP_TEMP_TRIAL_BALANCE
AP_TERMS_LINES
AP_TERMS_TL
AP_TOLERANCES_ALL
AP_TRANSMISSIONS_SETUP
AP_TRIAL_BAL
AP_TRIAL_BALANCE
AP_VENDOR_AUDIT_TMP
AP_VENDOR_KEY_IND_ALL
AP_VENDOR_KEY_IND_OLD
AP_WEB_DISC_HEADERS_GT
AP_WEB_DISC_LINES_GT
AP_WEB_EMPLOYEE_INFO_ALL
AP_WEB_MANAGEMENT_REPORTS_GT
AP_WEB_PREFERENCES
AP_WEB_SIGNING_LIMITS_ALL
AP_WEB_TEMP_ATTR_GT
AP_WEB_VAT_SETUP_ALL
AP_WHT_ITF
FINANCIALS_PURGES
FINANCIALS_SYSTEM_PARAMS_ALL
JE_CH_EFT_BANKS_R107
JE_CH_PAYMENT_REF
JE_CH_SAD_SEQUENCES
JE_CZ_CONT_ALLOC_ALL
JE_CZ_EFT_CONTRACTS_ALL
JE_CZ_EFT_DATA_TMP
JE_DE_AP_BATCHES
JE_DE_CHECKRUN_RESULTS
JE_DE_DECLARATION_HEADERS_R106
JE_DE_DECLARATION_LINES_R106
JE_DE_EFT_PARAMETERS_R106
JE_DE_EFT_TERRITORIES_R106
JE_DK_EDI_TMP
JE_DK_PAY_CATEGORIES
JE_FI_NUMBER_VALIDATION
JE_FR_DAS_010
JE_FR_DAS_010_NEW
JE_FR_DAS_020
JE_FR_DAS_020_NEW
JE_FR_DAS_210
JE_FR_DAS_210_NEW
JE_FR_DAS_300
JE_FR_DAS_300_NEW
JE_FR_DAS_310
JE_FR_DAS_310_NEW
JE_IT_EXEMPT_LETTERS
JE_IT_EXEMPT_LETTERS_BKP
JE_IT_EXLET_SEQS
JE_IT_VAT_REGISTERS_B
JE_IT_VAT_REGISTERS_BKP
JE_IT_VAT_REGISTERS_TL
JE_IT_VAT_REG_DOCS
JE_IT_YEAR_EX_LIMIT
JE_NL_EFT_BATCHES
JE_NL_EFT_CONTENTS
JE_NL_EFT_MEDIA
JE_NL_EFT_SPECS
JE_NO_BANK_AVSTEM_TEMP
JE_NO_BBS
JE_NO_BBS_MESSAGE
JE_NO_BBS_POSTS
JE_NO_DATADIALOG
JE_NO_DATADIALOG_COMPLETE
JE_NO_INVEST_LINES
JE_NO_INVEST_SETUP_B
JE_NO_INVEST_SETUP_BKP
JE_NO_INVEST_SETUP_TL
JE_NO_TELEPAY
JE_NO_TELEPAY_RETUR1
JE_SE_EFT
JG_ZZ_AP_BALANCES
JG_ZZ_AP_IR_REP_ITF
JG_ZZ_AP_TMP_ACCOUNT
JG_ZZ_AP_TMP_BAL
JG_ZZ_AP_TMP_DETAIL
JG_ZZ_INVOICE_INFO
JG_ZZ_JGZZVSLP_MESSAGES
JG_ZZ_PAY_FORMAT_INFO
JG_ZZ_PAY_SCHED_INFO
JG_ZZ_SYS_FORMATS_ALL_B
JG_ZZ_SYS_FORMATS_ALL_BKP
JG_ZZ_SYS_FORMATS_ALL_TL
JG_ZZ_VEND_SITE_INFO
AP_TOLERANCE_TEMPLATES
AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_NOTES
AP_SUP_SITE_CONTACT_INT
AP_MAP_TYPES_TL
AP_MAP_CODES
AP_CARD_PARAMETERS
AP_MAP_TYPES_B
AP_EXPENSE_PARAMS_ALL
AP_CACHE_OFFSET_ACCOUNT_TBL
AP_CCARD_ESC_NEXT_GT
AP_CARD_EMP_CANDIDATES
AP_CARD_DETAILS
AP_EXP_LOCATIONS
AP_NO_MATCH_TRXNS
AP_TEMP_APPROVAL_GT
AP_RETRO_REJECTIONS_GT
AP_TRIAL_BAL_GT