Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - AZ Tables and Views

TABLE - AZ.AZ_APIS

TABLE - AZ.AZ_API_ATTRIBUTES

TABLE - AZ.AZ_API_DEPENDENCIES

TABLE - AZ.AZ_API_DEPENDENCY_ATTRIBUTES

TABLE - AZ.AZ_API_PREFERENCES_B

TABLE - AZ.AZ_API_PREFERENCES_TL

TABLE - AZ.AZ_API_PREFERENCE_SOURCES_B

TABLE - AZ.AZ_API_PREFERENCE_SOURCES_TL

TABLE - AZ.AZ_API_PREF_SRC_ATTRIBUTES_B

TABLE - AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL

TABLE - AZ.AZ_ARCHIVE

TABLE - AZ.AZ_ARCHIVE_STEPS

TABLE - AZ.AZ_CONTEXTS_SQL

TABLE - AZ.AZ_DIFF_RESULTS

TABLE - AZ.AZ_FILES

TABLE - AZ.AZ_GROUPS

TABLE - AZ.AZ_INSTANCES

TABLE - AZ.AZ_MORG_TRIGGERS

TABLE - AZ.AZ_PROCESSES

TABLE - AZ.AZ_PRODUCT_FLOWS

TABLE - AZ.AZ_PRODUCT_PHASES

TABLE - AZ.AZ_REPORTER_DATA

TABLE - AZ.AZ_REQUESTS

TABLE - AZ.AZ_SELECTION_SETS_B

TABLE - AZ.AZ_SELECTION_SETS_TL

TABLE - AZ.AZ_SELECTION_SET_APIS

TABLE - AZ.AZ_SELECTION_SET_ENTITIES_B

TABLE - AZ.AZ_SELECTION_SET_ENTITIES_TL

TABLE - AZ.AZ_SELECTION_SET_TAXONOMIES

TABLE - AZ.AZ_STRUCTURES_B

TABLE - AZ.AZ_STRUCTURES_TL

TABLE - AZ.AZ_STRUCTURE_APIS_B

TABLE - AZ.AZ_STRUCTURE_APIS_TL

TABLE - AZ.AZ_TAXONOMIES_B

TABLE - AZ.AZ_TAXONOMIES_TL

TABLE - AZ.AZ_TEMPLATES

VIEW - APPS.AZ_FLOW_PHASES_V

VIEW - APPS.AZ_GROUPS_V

VIEW - APPS.AZ_PROCESSES_ALL_V

VIEW - APPS.AZ_PROCESSES_V

VIEW - APPS.AZ_PROCESS_ACTIVITIES_V

VIEW - APPS.AZ_PRODUCT_PHASES_V

VIEW - APPS.AZ_SELECTION_SETS_VL

VIEW - APPS.AZ_SELECTION_SET_ENTITIES_VL

VIEW - APPS.AZ_STRUCTURES_VL

VIEW - APPS.AZ_STRUCTURE_APIS_VL

VIEW - APPS.AZ_TASKS_V

Table: AZ_APIS

Primary Key: AZ_APIS_PK

1. API_CODE

Comments

This table stores api definitions for iSetups.

Indexes

Columns

[top of page]

AZ.AZ_APIS does not reference any database object

AZ.AZ_APIS is referenced by following:

APPS

SYNONYM - AZ_APIS

[top of page]

Table: AZ_API_ATTRIBUTES

Primary Key: AZ_API_ATTRIBUTES_PK

1. API_CODE
2. ATTRIBUTE_TAG

Comments

This table stores api attribute definitions for iSetups.

Indexes

Columns

[top of page]

AZ.AZ_API_ATTRIBUTES does not reference any database object

AZ.AZ_API_ATTRIBUTES is referenced by following:

APPS

SYNONYM - AZ_API_ATTRIBUTES

[top of page]

Table: AZ_API_DEPENDENCIES

Primary Key: AZ_API_DEPENDENCIES_PK

1. DEPENDANT_API_CODE
2. REQUIRED_API_CODE

Comments

This table stores dependencies between apis.

Indexes

Columns

[top of page]

AZ.AZ_API_DEPENDENCIES does not reference any database object

AZ.AZ_API_DEPENDENCIES is referenced by following:

APPS

SYNONYM - AZ_API_DEPENDENCIES

[top of page]

Table: AZ_API_DEPENDENCY_ATTRIBUTES

Primary Key: AZ_API_DEP_ATTRIBUTES_PK

1. DEPENDANT_API_CODE
2. REQUIRED_API_CODE
3. DEPENDANT_API_ATTRIBUTE
4. REQUIRED_API_ATTRIBUTE

Comments

This table stores API Dependency Attributes.

Indexes

Columns

[top of page]

AZ.AZ_API_DEPENDENCY_ATTRIBUTES does not reference any database object

AZ.AZ_API_DEPENDENCY_ATTRIBUTES is referenced by following:

APPS

SYNONYM - AZ_API_DEPENDENCY_ATTRIBUTES

[top of page]

Table: AZ_API_PREFERENCES_B

Comments

Indexes

Columns

[top of page]

AZ.AZ_API_PREFERENCES_B does not reference any database object

AZ.AZ_API_PREFERENCES_B is referenced by following:

APPS

SYNONYM - AZ_API_PREFERENCES_B

[top of page]

Table: AZ_API_PREFERENCES_TL

Comments

Indexes

Columns

[top of page]

AZ.AZ_API_PREFERENCES_TL does not reference any database object

AZ.AZ_API_PREFERENCES_TL is referenced by following:

APPS

SYNONYM - AZ_API_PREFERENCES_TL

[top of page]

Table: AZ_API_PREFERENCE_SOURCES_B

Comments

Indexes

Columns

[top of page]

AZ.AZ_API_PREFERENCE_SOURCES_B does not reference any database object

AZ.AZ_API_PREFERENCE_SOURCES_B is referenced by following:

APPS

SYNONYM - AZ_API_PREFERENCE_SOURCES_B

[top of page]

Table: AZ_API_PREFERENCE_SOURCES_TL

Comments

Indexes

Columns

[top of page]

AZ.AZ_API_PREFERENCE_SOURCES_TL does not reference any database object

AZ.AZ_API_PREFERENCE_SOURCES_TL is referenced by following:

APPS

SYNONYM - AZ_API_PREFERENCE_SOURCES_TL

[top of page]

Table: AZ_API_PREF_SRC_ATTRIBUTES_B

Comments

Indexes

Columns

[top of page]

AZ.AZ_API_PREF_SRC_ATTRIBUTES_B does not reference any database object

AZ.AZ_API_PREF_SRC_ATTRIBUTES_B is referenced by following:

APPS

SYNONYM - AZ_API_PREF_SRC_ATTRIBUTES_B

[top of page]

Table: AZ_API_PREF_SRC_ATTRIBUTES_TL

Comments

Indexes

Columns

[top of page]

AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL does not reference any database object

AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL is referenced by following:

APPS

SYNONYM - AZ_API_PREF_SRC_ATTRIBUTES_TL

[top of page]

Table: AZ_ARCHIVE

Primary Key: AZ_ARCHIVE_PK

1. NODE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AZ_ARCHIVE stores Wizard data pertaining to groups, processes, and tasks. Each row in the table includes the node ID, the node type that indicates whether it is a group, process, or task, the node name that is the label for the process or group, the context type for the process, the context name for the process, the context ID for the process, the status code indicating if it is active or complete, the item key to identify the task, the assigned user for the task role, and comments for the process.

Indexes

Columns

[top of page]

AZ.AZ_ARCHIVE does not reference any database object

AZ.AZ_ARCHIVE is referenced by following:

APPS

SYNONYM - AZ_ARCHIVE

[top of page]

Table: AZ_ARCHIVE_STEPS

Primary Key: AZ_ARCHIVE_STEPS_PK

1. ITEM_KEY
2. ACTIVITY_TYPE
3. STEP
4. BEGIN_DATE

Foreign Keys from this table:

Comments

AZ_ARCHIVE_STEPS stores Wizard data regarding tasks and all their steps. Each row has information regarding each step of the task, its status, the assigned user, the form name associated with the step, and the begin date for the the task step.

Indexes

Columns

[top of page]

AZ.AZ_ARCHIVE_STEPS does not reference any database object

AZ.AZ_ARCHIVE_STEPS is referenced by following:

APPS

SYNONYM - AZ_ARCHIVE_STEPS

[top of page]

Table: AZ_CONTEXTS_SQL

Primary Key: AZ_CONTEXTS_SQL_PK

1. CONTEXT
2. PURPOSE

Comments

Used for storing sql statements that are dynamically executed. The sql statements are used for populating, validating, deleting contexts

Indexes

Columns

[top of page]

AZ.AZ_CONTEXTS_SQL does not reference any database object

AZ.AZ_CONTEXTS_SQL is referenced by following:

APPS

SYNONYM - AZ_CONTEXTS_SQL

[top of page]

Table: AZ_DIFF_RESULTS

Comments

Indexes

Columns

[top of page]

SYS

PACKAGE - STANDARD

TYPE - XMLTYPE

XDB

XML SCHEMA - XDJijXhYlJbEDgQBSQycRVqw==

APPS

SYNONYM - AZ_DIFF_RESULTS

[top of page]

Table: AZ_FILES

Primary Key: AZ_FILES_PK

1. CONFIG_HDR_ID
2. CONFIG_REV_NBR

Comments

This table stores runtime files for iSetups.

Indexes

Columns

[top of page]

AZ.AZ_FILES does not reference any database object

AZ.AZ_FILES is referenced by following:

APPS

SYNONYM - AZ_FILES

[top of page]

Table: AZ_GROUPS

Primary Key: AZ_GROUPS_PK

1. GROUP_ID
2. PROCESS_TYPE

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AZ_GROUPS stores information about the process groups used in the Implementation Wizard form. Each record contains the unique identifier of the group, the parent process group that is associated with the group, as well as the display order, color code, complete flag, and the application or lookup code that the process group is associated with. Additionally, to enable differents types of implementation of the Wizard, there is also a process type for each group indicating its implementation type.

Indexes

Columns

[top of page]

AZ.AZ_GROUPS does not reference any database object

AZ.AZ_GROUPS is referenced by following:

APPS

SYNONYM - AZ_GROUPS

[top of page]

Table: AZ_INSTANCES

Primary Key: AZ_INSTANCES_PK

1. INSTANCE_NAME
2. USER_ID

Comments

This table stores connection info for each DB that iSetup Migrator uses.

Indexes

Columns

[top of page]

AZ.AZ_INSTANCES does not reference any database object

AZ.AZ_INSTANCES is referenced by following:

APPS

SYNONYM - AZ_INSTANCES

[top of page]

Table: AZ_MORG_TRIGGERS

Primary Key: AZ_MORG_TRIGGERS_PK

1. TRIGGER_NAME

Comments

This table stores triggers that are disabled by the
iSetups convert-to-multiorg concurrent program.

Columns

[top of page]

AZ.AZ_MORG_TRIGGERS does not reference any database object

AZ.AZ_MORG_TRIGGERS is referenced by following:

APPS

SYNONYM - AZ_MORG_TRIGGERS

[top of page]

Table: AZ_PROCESSES

Primary Key: AZ_PROCESSES_PK

1. ITEM_TYPE
2. PROCESS_NAME
3. CONTEXT_ID

Foreign Keys from this table:

Comments

AZ_PROCESSES stores information about the runnable workflow
processes with different context names and context types. Each record
contains the item type, process name, context ID, context name, and
context type, as well as the complete flag, the parent process group
that it is associated with, the display order in the hierarchy tree,
and the user entered comments for the process from the Implementation
Wizard form.

Indexes

Columns

[top of page]

AZ.AZ_PROCESSES does not reference any database object

AZ.AZ_PROCESSES is referenced by following:

APPS

SYNONYM - AZ_PROCESSES

[top of page]

Table: AZ_PRODUCT_FLOWS

Primary Key: AZ_PRODUCT_FLOWS_PK

1. APPLICATION_ID
2. ITEM_TYPE
3. PROCESS_NAME

Foreign Keys from this table:

Comments

AZ_PRODUCT_FLOWS stores information about the runnable workflow
processes for each application. Each record contains the unique
identifier of the application, the item type, process name, and context
type, as well as the parent process group that it is associated with
and its display order in the hierarchy tree.

Indexes

Columns

[top of page]

AZ.AZ_PRODUCT_FLOWS does not reference any database object

AZ.AZ_PRODUCT_FLOWS is referenced by following:

APPS

SYNONYM - AZ_PRODUCT_FLOWS

[top of page]

Table: AZ_PRODUCT_PHASES

Primary Key: AZ_PRODUCT_PHASES_PK

1. APPLICATION_ID

Comments

AZ_PRODUCT_PHASES stores information about the phase for each
installed product. Each record contains the unique identifier of
the application and its corresponding phase.

Indexes

Columns

[top of page]

AZ.AZ_PRODUCT_PHASES does not reference any database object

AZ.AZ_PRODUCT_PHASES is referenced by following:

APPS

SYNONYM - AZ_PRODUCT_PHASES

[top of page]

Table: AZ_REPORTER_DATA

Comments

Indexes

Columns

[top of page]

SYS

PACKAGE - STANDARD

TYPE - XMLTYPE

XDB

XML SCHEMA - XDJijXdOCzl9rgQBSQycRVmA==

APPS

SYNONYM - AZ_REPORTER_DATA

[top of page]

Table: AZ_REQUESTS

Primary Key: AZ_REQUESTS_PK

1. JOB_NAME
2. REQUEST_TYPE
3. USER_ID

Comments

Indexes

Columns

[top of page]

SYS

PACKAGE - STANDARD

TYPE - XMLTYPE

XDB

XML SCHEMA - XDJijXQJjMyTzgQBSQycRVhw==

APPS

SYNONYM - AZ_REQUESTS

[top of page]

Table: AZ_SELECTION_SETS_B

Primary Key: AZ_SELECTION_SETS_B_PK

1. SELECTION_SET_CODE
2. USER_ID

Comments

This table stores selection sets.

Indexes

Columns

[top of page]

AZ.AZ_SELECTION_SETS_B does not reference any database object

AZ.AZ_SELECTION_SETS_B is referenced by following:

APPS

SYNONYM - AZ_SELECTION_SETS_B

[top of page]

Table: AZ_SELECTION_SETS_TL

Primary Key: AZ_SELECTION_SETS_TL_PK

1. SELECTION_SET_CODE
2. USER_ID
3. LANGUAGE

Comments

This table stores multi-lingual info for az_selection_sets.

Indexes

Columns

[top of page]

AZ.AZ_SELECTION_SETS_TL does not reference any database object

AZ.AZ_SELECTION_SETS_TL is referenced by following:

APPS

SYNONYM - AZ_SELECTION_SETS_TL

[top of page]

Table: AZ_SELECTION_SET_APIS

Primary Key: AZ_SELECTION_SET_APIS_PK

1. JOB_NAME
2. ENTITY_OCCURANCE_CODE
3. SUBMITTED_BY

Comments

This table stores what APIs are included in each selection set for iSetup Migrator.

Indexes

Columns

[top of page]

AZ.AZ_SELECTION_SET_APIS does not reference any database object

AZ.AZ_SELECTION_SET_APIS is referenced by following:

APPS

SYNONYM - AZ_SELECTION_SET_APIS

[top of page]

Table: AZ_SELECTION_SET_ENTITIES_B

Primary Key: AZ_SELECTION_SET_ENTITIES_B_PK

1. SELECTION_SET_CODE
2. USER_ID
3. ENTITY_OCCURANCE_CODE

Comments

Indexes

Columns

[top of page]

AZ.AZ_SELECTION_SET_ENTITIES_B does not reference any database object

AZ.AZ_SELECTION_SET_ENTITIES_B is referenced by following:

APPS

SYNONYM - AZ_SELECTION_SET_ENTITIES_B

[top of page]

Table: AZ_SELECTION_SET_ENTITIES_TL

Primary Key: AZ_SEL_SET_ENTITIES_TL_PK

1. SELECTION_SET_CODE
2. USER_ID
3. ENTITY_OCCURANCE_CODE
4. LANGUAGE

Comments

This table stores multi-lingual info for az_selection_set_entities.

Indexes

Columns

[top of page]

AZ.AZ_SELECTION_SET_ENTITIES_TL does not reference any database object

AZ.AZ_SELECTION_SET_ENTITIES_TL is referenced by following:

APPS

SYNONYM - AZ_SELECTION_SET_ENTITIES_TL

[top of page]

Table: AZ_SELECTION_SET_TAXONOMIES

Comments

Indexes

Columns

[top of page]

AZ.AZ_SELECTION_SET_TAXONOMIES does not reference any database object

AZ.AZ_SELECTION_SET_TAXONOMIES is referenced by following:

APPS

SYNONYM - AZ_SELECTION_SET_TAXONOMIES

[top of page]

Table: AZ_STRUCTURES_B

Primary Key: AZ_STRUCTURES_B_PK

1. STRUCTURE_CODE

Comments

This table stores api structures.

Indexes

Columns

[top of page]

AZ.AZ_STRUCTURES_B does not reference any database object

AZ.AZ_STRUCTURES_B is referenced by following:

APPS

SYNONYM - AZ_STRUCTURES_B

[top of page]

Table: AZ_STRUCTURES_TL

Primary Key: AZ_STRUCTURES_TL_PK

1. STRUCTURE_CODE
2. LANGUAGE

Comments

This table stores multilingual info for structures_b.

Indexes

Columns

[top of page]

AZ.AZ_STRUCTURES_TL does not reference any database object

AZ.AZ_STRUCTURES_TL is referenced by following:

APPS

SYNONYM - AZ_STRUCTURES_TL

[top of page]

Table: AZ_STRUCTURE_APIS_B

Primary Key: AZ_STRUCTURE_APIS_PK

1. STRUCTURE_CODE
2. ENTITY_CODE

Comments

Indexes

Columns

[top of page]

AZ.AZ_STRUCTURE_APIS_B does not reference any database object

AZ.AZ_STRUCTURE_APIS_B is referenced by following:

APPS

SYNONYM - AZ_STRUCTURE_APIS_B

[top of page]

Table: AZ_STRUCTURE_APIS_TL

Primary Key: AZ_STRUCTURE_APIS_TL_PK

1. STRUCTURE_CODE
2. ENTITY_CODE
3. LANGUAGE

Comments

Indexes

Columns

[top of page]

AZ.AZ_STRUCTURE_APIS_TL does not reference any database object

AZ.AZ_STRUCTURE_APIS_TL is referenced by following:

APPS

SYNONYM - AZ_STRUCTURE_APIS_TL

[top of page]

Table: AZ_TAXONOMIES_B

Comments

Indexes

Columns

[top of page]

AZ.AZ_TAXONOMIES_B does not reference any database object

AZ.AZ_TAXONOMIES_B is referenced by following:

APPS

SYNONYM - AZ_TAXONOMIES_B

[top of page]

Table: AZ_TAXONOMIES_TL

Comments

Indexes

Columns

[top of page]

AZ.AZ_TAXONOMIES_TL does not reference any database object

AZ.AZ_TAXONOMIES_TL is referenced by following:

APPS

SYNONYM - AZ_TAXONOMIES_TL

[top of page]

Table: AZ_TEMPLATES

Primary Key: AZ_TEMPLATES_PK

1. NAME

Comments

This table stores template files for iSetups

Indexes

Columns

[top of page]

AZ.AZ_TEMPLATES does not reference any database object

AZ.AZ_TEMPLATES is referenced by following:

APPS

SYNONYM - AZ_TEMPLATES

[top of page]

View: AZ_FLOW_PHASES_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_FLOW_PHASES_V is a view that stores information about the workflow
processes and their corresponding phase(s). Each row includes the
item type, process name and its associated phase. This view is
primarily used for backend processing.

Columns

[top of page]

APPS

SYNONYM - AZ_PRODUCT_FLOWS

SYNONYM - AZ_PRODUCT_PHASES

APPS

PACKAGE BODY - AZW_HIER

PACKAGE BODY - AZW_REPORT

[top of page]

View: AZ_GROUPS_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_GROUPS_V is a view that joins AZ_GROUPS, FND_APPLICATION_VL, and FND_LOOKUPS to provide quick access to the display name of each group.

Columns

[top of page]

APPS

SYNONYM - AZ_GROUPS

VIEW - FND_APPLICATION_VL

PACKAGE - FND_GLOBAL

VIEW - FND_LOOKUPS

APPS

PACKAGE BODY - AZW_ARCHIVE

PACKAGE BODY - AZW_REPORT

[top of page]

View: AZ_PROCESSES_ALL_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_PROCESSES_V is a view based on ap_processes regardless of the process_type. It also provides quick access to the display name and the context type name of the processes.

Columns

[top of page]

APPS

SYNONYM - AZ_PROCESSES

PACKAGE - FND_GLOBAL

VIEW - FND_LOOKUPS

VIEW - WF_ACTIVITIES_VL

APPS

PACKAGE BODY - AZW_ARCHIVE

PACKAGE BODY - AZW_REPORT

[top of page]

View: AZ_PROCESSES_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

A view based on az_processes table. It provides a view of az_processes filtering processes by their
process type. The view contains wizard processes having process type equal to the current implementation mode which is a profile option.

Columns

[top of page]

APPS

SYNONYM - AZ_PROCESSES

PACKAGE - FND_PROFILE

APPS.AZ_PROCESSES_V is not referenced by any database object

[top of page]

View: AZ_PROCESS_ACTIVITIES_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_PROCESS_ACTIVITIES_V is a view that stores the definition of a
process. Each row includes the item type, process name, context id as
well as the complete flag, description and user entered comments of a
process. This view is mainly used by the Implementation Wizard form.

Columns

[top of page]

APPS

SYNONYM - AZ_PROCESSES

VIEW - WF_ACTIVITIES_VL

APPS.AZ_PROCESS_ACTIVITIES_V is not referenced by any database object

[top of page]

View: AZ_PRODUCT_PHASES_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_PRODUCT_PHASES_V is a view that stores information about the phase
for each installed product defined in AZ_GROUPS. Each row includes
the unique identifier and name of an application as well as its
corresponding phase. This view is mainly used by the Define Phase
form.

Columns

[top of page]

APPS

SYNONYM - AZ_GROUPS

SYNONYM - AZ_PRODUCT_PHASES

VIEW - FND_APPLICATION_VL

SYNONYM - FND_PRODUCT_INSTALLATIONS

APPS

PACKAGE BODY - AZW_REPORT

[top of page]

View: AZ_SELECTION_SETS_VL

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_SELECTION_SETS_VL

Columns

[top of page]

APPS

SYNONYM - AZ_SELECTION_SETS_B

SYNONYM - AZ_SELECTION_SETS_TL

APPS.AZ_SELECTION_SETS_VL is not referenced by any database object

[top of page]

View: AZ_SELECTION_SET_ENTITIES_VL

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_SELECTION_SET_ENTITIES_VL

Columns

[top of page]

APPS

SYNONYM - AZ_SELECTION_SET_ENTITIES_B

SYNONYM - AZ_SELECTION_SET_ENTITIES_TL

APPS.AZ_SELECTION_SET_ENTITIES_VL is not referenced by any database object

[top of page]

View: AZ_STRUCTURES_VL

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_STRUCTURES_VL

Columns

[top of page]

APPS

SYNONYM - AZ_STRUCTURES_B

SYNONYM - AZ_STRUCTURES_TL

APPS.AZ_STRUCTURES_VL is not referenced by any database object

[top of page]

View: AZ_STRUCTURE_APIS_VL

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_STRUCTURE_APIS_VL

Columns

[top of page]

APPS

SYNONYM - AZ_STRUCTURE_APIS_B

SYNONYM - AZ_STRUCTURE_APIS_TL

APPS.AZ_STRUCTURE_APIS_VL is not referenced by any database object

[top of page]

View: AZ_TASKS_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

AZ_TASKS_V is a view containing all the tasks, or items in Workflow terminology, belong to AZ. Each row includes item key, item type, process name, activity instance id, begin date, end date, assigned user, status, and duration. It is built upon WF_ITEMS, WF_ITEM_ATTRIBUTE_STATUSES, WF_ITEM_ATTRIBUTE_VALUES, and WF_PROCESS_ACTIVITIES.

Columns

[top of page]

APPS

SYNONYM - AZ_PROCESSES

SYNONYM - WF_ITEMS

SYNONYM - WF_ITEM_ACTIVITY_STATUSES

SYNONYM - WF_ITEM_ATTRIBUTE_VALUES

SYNONYM - WF_PROCESS_ACTIVITIES

APPS

PACKAGE BODY - AZW_ARCHIVE

PACKAGE BODY - AZW_PROC

PACKAGE BODY - AZW_REPORT

[top of page]