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 - AK Tables and Views

TABLE - AK.AK_AM_PARAMETER_REGISTRY

TABLE - AK.AK_ATTRIBUTES

TABLE - AK.AK_ATTRIBUTES_TL

TABLE - AK.AK_CATEGORY_USAGES

TABLE - AK.AK_CRITERIA

TABLE - AK.AK_CUSTOMIZATIONS

TABLE - AK.AK_CUSTOMIZATIONS_TL

TABLE - AK.AK_CUSTOM_REGIONS

TABLE - AK.AK_CUSTOM_REGIONS_TL

TABLE - AK.AK_CUSTOM_REGION_ITEMS

TABLE - AK.AK_CUSTOM_REGION_ITEMS_TL

TABLE - AK.AK_CUSTOM_REGISTRY

TABLE - AK.AK_EXCLUDED_ITEMS

TABLE - AK.AK_FLOWS

TABLE - AK.AK_FLOWS_TL

TABLE - AK.AK_FLOW_PAGES

TABLE - AK.AK_FLOW_PAGES_TL

TABLE - AK.AK_FLOW_PAGE_REGIONS

TABLE - AK.AK_FLOW_PAGE_REGION_ITEMS

TABLE - AK.AK_FLOW_REGION_RELATIONS

TABLE - AK.AK_FOREIGN_KEYS

TABLE - AK.AK_FOREIGN_KEYS_TL

TABLE - AK.AK_FOREIGN_KEY_COLUMNS

TABLE - AK.AK_INST_ATTRIBUTE_VALUES

TABLE - AK.AK_LOADER_TEMP

TABLE - AK.AK_LOOKUP_CODES

TABLE - AK.AK_MULTIORG_VALIDATION_TEMP

TABLE - AK.AK_OBJECTS

TABLE - AK.AK_OBJECTS_TL

TABLE - AK.AK_OBJECT_ATTRIBUTES

TABLE - AK.AK_OBJECT_ATTRIBUTES_TL

TABLE - AK.AK_OBJECT_ATTRIBUTE_NAVIGATION

TABLE - AK.AK_OBJECT_VALUES_TEMP

TABLE - AK.AK_QUERY_OBJECTS

TABLE - AK.AK_QUERY_OBJECT_LINES

TABLE - AK.AK_REGIONS

TABLE - AK.AK_REGIONS_TL

TABLE - AK.AK_REGION_ITEMS

TABLE - AK.AK_REGION_ITEMS_TL

TABLE - AK.AK_REGION_LOV_RELATIONS

TABLE - AK.AK_RESP_SECURITY_ATTRIBUTES

TABLE - AK.AK_RESP_SECURITY_ATTR_VALUES

TABLE - AK.AK_UNIQUE_KEYS

TABLE - AK.AK_UNIQUE_KEY_COLUMNS

TABLE - AK.AK_WEB_USER_SEC_ATTR_VALUES

TABLE - AK.FWK_TBX_ADDRESSES

TABLE - AK.FWK_TBX_EMPLOYEES

TABLE - AK.FWK_TBX_ITEMS

TABLE - AK.FWK_TBX_ITEM_CCIDS

TABLE - AK.FWK_TBX_LOOKUP_CODES_B

TABLE - AK.FWK_TBX_LOOKUP_CODES_TL

TABLE - AK.FWK_TBX_LOOKUP_TYPES_TL

TABLE - AK.FWK_TBX_PO_HEADERS

TABLE - AK.FWK_TBX_PO_LINES

TABLE - AK.FWK_TBX_PO_SHIPMENTS

TABLE - AK.FWK_TBX_PROJECT_DETAILS

TABLE - AK.FWK_TBX_PROJECT_HEADERS

TABLE - AK.FWK_TBX_SUPPLIERS

TABLE - AK.FWK_TBX_SUPPLIER_SITES

VIEW - APPS.AK_AM_PARAMETER_REGISTRY_V

VIEW - APPS.AK_ATTRIBUTES_VL

VIEW - APPS.AK_CATEGORY_USAGES_V

VIEW - APPS.AK_CRITERIA_V

VIEW - APPS.AK_CUSTOMIZATIONS_VL

VIEW - APPS.AK_CUSTOM_REGIONS_VL

VIEW - APPS.AK_CUSTOM_REGION_ITEMS_VL

VIEW - APPS.AK_FLOWS_VL

VIEW - APPS.AK_FLOW_PAGES_VL

VIEW - APPS.AK_FLOW_PAGE_REGIONS_V

VIEW - APPS.AK_FLOW_PAGE_REGION_ITEMS_V

VIEW - APPS.AK_FLOW_REGION_RELATIONS_V

VIEW - APPS.AK_FOREIGN_KEYS_VL

VIEW - APPS.AK_FOREIGN_KEY_COLUMNS_V

VIEW - APPS.AK_FOREIGN_KEY_MAPPING_V

VIEW - APPS.AK_LOOKUP_CODES_VL

VIEW - APPS.AK_OBJECTS_VL

VIEW - APPS.AK_OBJECT_ATTRIBUTES_VL

VIEW - APPS.AK_OBJECT_ATTRIBUTE_NAVIGATI_V

VIEW - APPS.AK_QUERY_OBJECTS_V

VIEW - APPS.AK_QUERY_OBJECT_LINES_V

VIEW - APPS.AK_REGIONS_VL

VIEW - APPS.AK_REGION_ITEMS_VL

VIEW - APPS.AK_REGION_LOV_RELATIONS_V

VIEW - APPS.AK_UNIQUE_KEYS_V

VIEW - APPS.AK_UNIQUE_KEY_COLUMNS_V

Table: AK_AM_PARAMETER_REGISTRY

Primary Key: AK_AM_PARAMETER_REGISTRY_PK

1. APPLICATIONMODULE_DEFN_NAME
2. PARAM_NAME
3. PARAM_SOURCE

Comments

This table is used for storing the parameters and parameters sources for an Application module, that need to be passed to the initializePageValues().

Indexes

Columns

[top of page]

AK.AK_AM_PARAMETER_REGISTRY does not reference any database object

AK.AK_AM_PARAMETER_REGISTRY is referenced by following:

APPS

SYNONYM - AK_AM_PARAMETER_REGISTRY

[top of page]

Table: AK_ATTRIBUTES

Primary Key: AK_ATTRIBUTES_PK

1. ATTRIBUTE_CODE
2. ATTRIBUTE_APPLICATION_ID

Foreign Keys to this table:

Comments

AK_ATTRIBUTES contains information about the attributes you define.
You need one row for each attribute.
Each attribute has a name, an application that owns the attribute,
formatting properties, a default value, a prompt, and a data type
(i.e., Number, Varchar2, Date, etc.).

Indexes

Columns

[top of page]

AK.AK_ATTRIBUTES does not reference any database object

AK.AK_ATTRIBUTES is referenced by following:

APPS

SYNONYM - AK_ATTRIBUTES

[top of page]

Table: AK_ATTRIBUTES_TL

Primary Key: AK_ATTRIBUTES_TL_PK

1. ATTRIBUTE_CODE
2. ATTRIBUTE_APPLICATION_ID
3. LANGUAGE

Foreign Keys from this table:

Comments

AK_ATTRIBUTES_TL stores translated information about the attributes
in AK_ATTRIBUTES. Each row includes the language the row is
translated to, the name, description, and label of the attribute, and
the attribute identifier which uniquely identifies the attribute. You
need one row for each attribute in each of the installed languages.
Each row includes a language and SOURCE_LANG column which can be used
to determine if a value has been translated or defaulted.

Indexes

Columns

[top of page]

AK.AK_ATTRIBUTES_TL does not reference any database object

AK.AK_ATTRIBUTES_TL is referenced by following:

APPS

SYNONYM - AK_ATTRIBUTES_TL

[top of page]

Table: AK_CATEGORY_USAGES

Primary Key: AK_CATEGORY_USAGES_PK

1. REGION_CODE
2. REGION_APPLICATION_ID
3. ATTRIBUTE_CODE
4. ATTRIBUTE_APPLICATION_ID
5. CATEGORY_NAME

Foreign Keys from this table:

Comments

Defines relationship between attachment region item and categories

Indexes

Columns

[top of page]

AK.AK_CATEGORY_USAGES does not reference any database object

AK.AK_CATEGORY_USAGES is referenced by following:

APPS

SYNONYM - AK_CATEGORY_USAGES

[top of page]

Table: AK_CRITERIA

Primary Key: AK_CRITERIA_PK

1. ATTRIBUTE_APPLICATION_ID
2. CUSTOMIZATION_APPLICATION_ID
3. REGION_APPLICATION_ID
4. SEQUENCE_NUMBER
5. REGION_CODE
6. CUSTOMIZATION_CODE
7. ATTRIBUTE_CODE

Comments

This table is used for storing the criteria for each customization.

Indexes

Columns

[top of page]

AK.AK_CRITERIA does not reference any database object

AK.AK_CRITERIA is referenced by following:

APPS

SYNONYM - AK_CRITERIA

[top of page]

Table: AK_CUSTOMIZATIONS

Primary Key: AK_CUSTOMIZATIONS_PK

1. CUSTOMIZATION_APPLICATION_ID
2. CUSTOMIZATION_CODE
3. REGION_APPLICATION_ID
4. REGION_CODE

Comments

This table is used for storing the customizations of regions at different levels.

Indexes

Columns

[top of page]

AK.AK_CUSTOMIZATIONS does not reference any database object

AK.AK_CUSTOMIZATIONS is referenced by following:

APPS

SYNONYM - AK_CUSTOMIZATIONS

[top of page]

Table: AK_CUSTOMIZATIONS_TL

Primary Key: AK_CUSTOMIZATIONS_TL_PK

1. CUSTOMIZATION_APPLICATION_ID
2. REGION_CODE
3. CUSTOMIZATION_CODE
4. LANGUAGE
5. REGION_APPLICATION_ID

Comments

The TL table corresponding to AK_CUSTOMIZATIONS.

Indexes

Columns

[top of page]

AK.AK_CUSTOMIZATIONS_TL does not reference any database object

AK.AK_CUSTOMIZATIONS_TL is referenced by following:

APPS

SYNONYM - AK_CUSTOMIZATIONS_TL

[top of page]

Table: AK_CUSTOM_REGIONS

Primary Key: AK_CUSTOM_REGIONS_PK

1. CUSTOMIZATION_APPLICATION_ID
2. CUSTOMIZATION_CODE
3. PROPERTY_NAME
4. REGION_APPLICATION_ID
5. REGION_CODE

Comments

This table is used for storing the customizations of a region's properties for a specific region and customization.

Indexes

Columns

[top of page]

AK.AK_CUSTOM_REGIONS does not reference any database object

AK.AK_CUSTOM_REGIONS is referenced by following:

APPS

SYNONYM - AK_CUSTOM_REGIONS

[top of page]

Table: AK_CUSTOM_REGIONS_TL

Primary Key: AK_CUSTOM_REGIONS_TL_PK

1. CUSTOMIZATION_APPLICATION_ID
2. CUSTOMIZATION_CODE
3. LANGUAGE
4. PROPERTY_NAME
5. REGION_APPLICATION_ID
6. REGION_CODE

Comments

The TL table corresponding to AK_CUSTOM_REGIONS.

Indexes

Columns

[top of page]

AK.AK_CUSTOM_REGIONS_TL does not reference any database object

AK.AK_CUSTOM_REGIONS_TL is referenced by following:

APPS

SYNONYM - AK_CUSTOM_REGIONS_TL

[top of page]

Table: AK_CUSTOM_REGION_ITEMS

Primary Key: AK_CUSTOM_REGION_ITEMS_PK

1. ATTRIBUTE_APPLICATION_ID
2. CUSTOMIZATION_CODE
3. ATTRIBUTE_CODE
4. CUSTOMIZATION_APPLICATION_ID
5. PROPERTY_NAME
6. REGION_CODE
7. REGION_APPLICATION_ID

Comments

This table is used for storing the customizations of region item properties for a specific region and customization.

Indexes

Columns

[top of page]

AK.AK_CUSTOM_REGION_ITEMS does not reference any database object

AK.AK_CUSTOM_REGION_ITEMS is referenced by following:

APPS

SYNONYM - AK_CUSTOM_REGION_ITEMS

[top of page]

Table: AK_CUSTOM_REGION_ITEMS_TL

Primary Key: AK_CUSTOM_REGION_ITEMS_TL_PK

1. CUSTOMIZATION_APPLICATION_ID
2. CUSTOMIZATION_CODE
3. REGION_APPLICATION_ID
4. REGION_CODE
5. ATTRIBUTE_APPLICATION_ID
6. ATTRIBUTE_CODE
7. PROPERTY_NAME
8. LANGUAGE

Comments

The TL table corresponding to AK_CUSTOM_REGION_ITEMS.

Indexes

Columns

[top of page]

AK.AK_CUSTOM_REGION_ITEMS_TL does not reference any database object

AK.AK_CUSTOM_REGION_ITEMS_TL is referenced by following:

APPS

SYNONYM - AK_CUSTOM_REGION_ITEMS_TL

[top of page]

Table: AK_CUSTOM_REGISTRY

Primary Key: AK_CUSTOM_REGISTRY_PK

1. CUSTOM_LEVEL
2. PROPERTY_NAME

Comments

Registry table for customizations. Stores if a property is transalatable or not.

Indexes

Columns

[top of page]

AK.AK_CUSTOM_REGISTRY does not reference any database object

AK.AK_CUSTOM_REGISTRY is referenced by following:

APPS

SYNONYM - AK_CUSTOM_REGISTRY

[top of page]

Table: AK_EXCLUDED_ITEMS

Primary Key: AK_EXCLUDED_ITEMS_PK

1. RESPONSIBILITY_ID
2. ATTRIBUTE_CODE
3. ATTRIBUTE_APPLICATION_ID

Foreign Keys from this table:

Comments

AK_EXCLUDED_ITEMS contains attributes which should be hidden from
users based on their responsibility ID. You need one row for each
attribute that you want hidden for a specific responsibility.
AK_QUERY_PKG currently makes use of this table and it returns the
attribute and attribute's value. AK_QUERY_PKG also sets a flag
(SECURED_COLUMN=Y) to inform the developer that this attribute (or
column) should be secured (hidden) from the current user.

Indexes

Columns

[top of page]

AK.AK_EXCLUDED_ITEMS does not reference any database object

AK.AK_EXCLUDED_ITEMS is referenced by following:

APPS

SYNONYM - AK_EXCLUDED_ITEMS

[top of page]

Table: AK_FLOWS

Primary Key: AK_FLOWS_PK

1. FLOW_CODE
2. FLOW_APPLICATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AK_FLOWS contains flows and their primary page. A flow represents a
series of pages that are returned by AK_QUERY_PKG. You need to
create one row for each flow.
Each row must include a primary page code which indicates the starting
page for the flow.

Indexes

Columns

[top of page]

AK.AK_FLOWS does not reference any database object

AK.AK_FLOWS is referenced by following:

APPS

SYNONYM - AK_FLOWS

[top of page]

Table: AK_FLOWS_TL

Primary Key: AK_FLOWS_TL_PK

1. FLOW_CODE
2. FLOW_APPLICATION_ID
3. LANGUAGE

Foreign Keys from this table:

Comments

AK_FLOWS_TL stores translated information about the flows in AK_FLOWS.
Each row includes the language the row is translated to, the
translated attributes of the flow, and the flow identifier which
uniquely identifies the flow. You need one row for each flow in each
of the installed languages. Each row includes a language and
SOURCE_LANG column which can be used to determine if a value has been
translated or defaulted.

Indexes

Columns

[top of page]

AK.AK_FLOWS_TL does not reference any database object

AK.AK_FLOWS_TL is referenced by following:

APPS

SYNONYM - AK_FLOWS_TL

[top of page]

Table: AK_FLOW_PAGES

Primary Key: AK_FLOW_PAGES_PK

1. FLOW_CODE
2. FLOW_APPLICATION_ID
3. PAGE_CODE
4. PAGE_APPLICATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AK_FLOW_PAGES defines the pages for a flow. A page represents a
series of regions that are returned by AK_QUERY_PKG. You will need one
row for each page you want to assign to a flow.
Each page must contain a primary region which indicates the starting
region for that page.

Indexes

Columns

[top of page]

AK.AK_FLOW_PAGES does not reference any database object

AK.AK_FLOW_PAGES is referenced by following:

APPS

SYNONYM - AK_FLOW_PAGES

[top of page]

Table: AK_FLOW_PAGES_TL

Primary Key: AK_FLOW_PAGES_TL_PK

1. FLOW_CODE
2. FLOW_APPLICATION_ID
3. PAGE_CODE
4. PAGE_APPLICATION_ID
5. LANGUAGE

Foreign Keys from this table:

Comments

AK_FLOW_PAGES_TL stores translated information about the flow pages in
AK_FLOW_PAGES. Each row includes the language the row is translated
to, the translated attributes of the flow page, and the flow page
identifier which uniquely identifies the flow page. You need one row
for each flow page in each of the installed languages. Each row
includes a language and SOURCE_LANG column which can be used to
determine if a value has been translated or defaulted.

Indexes

Columns

[top of page]

AK.AK_FLOW_PAGES_TL does not reference any database object

AK.AK_FLOW_PAGES_TL is referenced by following:

APPS

SYNONYM - AK_FLOW_PAGES_TL

[top of page]

Table: AK_FLOW_PAGE_REGIONS

Primary Key: AK_FLOW_PAGE_REGIONS_PK

1. FLOW_APPLICATION_ID
2. PAGE_CODE
3. PAGE_APPLICATION_ID
4. REGION_CODE
5. FLOW_CODE
6. REGION_APPLICATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AK_FLOW_PAGE_REGIONS contains regions that belong on a page. You will
need one row for each region that you want to assign to a page.
You can further specify the sequence that a region will appear on a
page, the region's style and the region's parent region.

Indexes

Columns

[top of page]

AK.AK_FLOW_PAGE_REGIONS does not reference any database object

AK.AK_FLOW_PAGE_REGIONS is referenced by following:

APPS

SYNONYM - AK_FLOW_PAGE_REGIONS

[top of page]

Table: AK_FLOW_PAGE_REGION_ITEMS

Primary Key: AK_FLOW_PAGE_REGION_ITEMS_PK

1. FLOW_CODE
2. FLOW_APPLICATION_ID
3. PAGE_CODE
4. PAGE_APPLICATION_ID
5. REGION_CODE
6. REGION_APPLICATION_ID
7. ATTRIBUTE_CODE
8. ATTRIBUTE_APPLICATION_ID

Foreign Keys from this table:

Comments

AK_FLOW_PAGE_REGION_ITEMS contains flow page region items that
links to another page or to a URL. You need one row for each link that
you want as part of your flow.

Indexes

Columns

[top of page]

AK.AK_FLOW_PAGE_REGION_ITEMS does not reference any database object

AK.AK_FLOW_PAGE_REGION_ITEMS is referenced by following:

APPS

SYNONYM - AK_FLOW_PAGE_REGION_ITEMS

[top of page]

Table: AK_FLOW_REGION_RELATIONS

Primary Key: AK_FLOW_REGION_RELATIONS_PK

1. FLOW_CODE
2. FLOW_APPLICATION_ID
3. FOREIGN_KEY_NAME
4. FROM_PAGE_CODE
5. FROM_PAGE_APPL_ID
6. FROM_REGION_CODE
7. FROM_REGION_APPL_ID
8. TO_PAGE_CODE
9. TO_PAGE_APPL_ID
10. TO_REGION_CODE
11. TO_REGION_APPL_ID

Foreign Keys from this table:

Comments

AK_FLOW_REGION_RELATIONS defines the foreign key relationship
between two flow page regions. You will need one row for each
relationship that you want to create.
Each relationship must specify the flow, the "From" (parent) page
region, the "To" (child) page region and the foreign key that links
the "From" (parent) page region to the "To" (child) page region.

Indexes

Columns

[top of page]

AK.AK_FLOW_REGION_RELATIONS does not reference any database object

AK.AK_FLOW_REGION_RELATIONS is referenced by following:

APPS

SYNONYM - AK_FLOW_REGION_RELATIONS

[top of page]

Table: AK_FOREIGN_KEYS

Primary Key: AK_FOREIGN_KEYS_PK

1. FOREIGN_KEY_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AK_FOREIGN_KEYS defines the foreign keys that belong to an object. You
must create one row for each foreign key you wish to associate to an
object.
For each foreign key, you must specify the database object name,
unique (primary) key name and the application owner of the foreign
key.

Indexes

Columns

[top of page]

AK.AK_FOREIGN_KEYS does not reference any database object

AK.AK_FOREIGN_KEYS is referenced by following:

APPS

SYNONYM - AK_FOREIGN_KEYS

[top of page]

Table: AK_FOREIGN_KEYS_TL

Primary Key: AK_FOREIGN_KEYS_TL_PK

1. FOREIGN_KEY_NAME
2. LANGUAGE

Foreign Keys from this table:

Comments

AK_FOREIGN_KEYS_TL stores translated information about the foreign
keys in AK_FOREIGN_KEYS. Each row includes the language the row is
translated to, the attributes for the foreign key and the foreign key
identifier which uniquely identifies the foreign key. You need one row
for each foreign key in the installed languages. Each row includes a
language and SOURCE_LANG column which can be used to determine if a
value has been translated or defaulted.

Indexes

Columns

[top of page]

AK.AK_FOREIGN_KEYS_TL does not reference any database object

AK.AK_FOREIGN_KEYS_TL is referenced by following:

APPS

SYNONYM - AK_FOREIGN_KEYS_TL

[top of page]

Table: AK_FOREIGN_KEY_COLUMNS

Primary Key: AK_FOREIGN_KEY_COLUMNS_PK

1. FOREIGN_KEY_NAME
2. ATTRIBUTE_CODE
3. ATTRIBUTE_APPLICATION_ID

Foreign Keys from this table:

Comments

AK_FOREIGN_KEY_COLUMNS defines the columns (attributes) that belong
to the foreign key. You will need one row for each column that makes
up the foreign key.

Indexes

Columns

[top of page]

AK.AK_FOREIGN_KEY_COLUMNS does not reference any database object

AK.AK_FOREIGN_KEY_COLUMNS is referenced by following:

APPS

SYNONYM - AK_FOREIGN_KEY_COLUMNS

[top of page]

Table: AK_INST_ATTRIBUTE_VALUES

Primary Key: AK_INST_ATTRIBUTE_VALUES_PK

1. DATABASE_OBJECT_NAME
2. KEY_VALUE1
3. KEY_VALUE2
4. KEY_VALUE3
5. KEY_VALUE4
6. KEY_VALUE5
7. KEY_VALUE6
8. KEY_VALUE7
9. KEY_VALUE8
10. KEY_VALUE9
11. KEY_VALUE10
12. ATTRIBUTE_CODE
13. ATTRIBUTE_APPLICATION_ID

Comments

AK_INST_ATTRIBUTE_VALUES is used by the Configurator (CZ) team and is
used to store items.

Indexes

Columns

[top of page]

AK.AK_INST_ATTRIBUTE_VALUES does not reference any database object

AK.AK_INST_ATTRIBUTE_VALUES is referenced by following:

APPS

SYNONYM - AK_INST_ATTRIBUTE_VALUES

[top of page]

Table: AK_LOADER_TEMP

Comments

Unique Key: SYS_C00169268

1. SESSION_ID
2. TBL_INDEX

Indexes

Columns

[top of page]

AK.AK_LOADER_TEMP does not reference any database object

AK.AK_LOADER_TEMP is referenced by following:

APPS

SYNONYM - AK_LOADER_TEMP

[top of page]

Table: AK_LOOKUP_CODES

Primary Key: AK_LOOKUP_CODES_PK

1. LOOKUP_CODE
2. LOOKUP_TYPE
3. LANGUAGE

Comments

AK_LOOKUP_CODES contains lookup code, lookup type and description of
each lookup codes. It also contains translation information for the
description of lookup code. You need one row for each lookup code/type
that you want.

Indexes

Columns

[top of page]

AK.AK_LOOKUP_CODES does not reference any database object

AK.AK_LOOKUP_CODES is referenced by following:

APPS

SYNONYM - AK_LOOKUP_CODES

[top of page]

Table: AK_MULTIORG_VALIDATION_TEMP

Comments

AK_MULTIORG_VALIDATION_TEMP is a temporary validation table used by the Multi-Org Validation
Report.

Columns

[top of page]

AK.AK_MULTIORG_VALIDATION_TEMP does not reference any database object

AK.AK_MULTIORG_VALIDATION_TEMP is referenced by following:

APPS

SYNONYM - AK_MULTIORG_VALIDATION_TEMP

[top of page]

Table: AK_OBJECTS

Primary Key: AK_OBJECTS_PK

1. DATABASE_OBJECT_NAME

Foreign Keys to this table:

Comments

AK_OBJECTS contains database object name and the owner (application
id) of the database object name. You need one row for each object
that you want to define.
An object is a logical representation of a database view. The database
object name is the name of a view in the database. Thus, there can
only be one AK_OBJECTS per view. This view must exist in FND_VIEW or
ALL_VIEWS.
You must specify a unique key name for each database object name.

Indexes

Columns

[top of page]

AK.AK_OBJECTS does not reference any database object

AK.AK_OBJECTS is referenced by following:

APPS

SYNONYM - AK_OBJECTS

[top of page]

Table: AK_OBJECTS_TL

Primary Key: AK_OBJECTS_TL_PK

1. DATABASE_OBJECT_NAME
2. LANGUAGE

Foreign Keys from this table:

Comments

AK_OBJECTS_TL stores translated information about the objects in
AK_OBJECTS. Each row includes the language the row is translated to,
the translated attributes of the object, and the object identifier
which uniquely identifies the object. You need one row for each object
in each of the installed languages. Each row includes a language and
SOURCE_LANG column which can be used to determine if a value has been
translated or defaulted.

Indexes

Columns

[top of page]

AK.AK_OBJECTS_TL does not reference any database object

AK.AK_OBJECTS_TL is referenced by following:

APPS

SYNONYM - AK_OBJECTS_TL

[top of page]

Table: AK_OBJECT_ATTRIBUTES

Primary Key: AK_OBJECT_ATTRIBUTES_PK

1. DATABASE_OBJECT_NAME
2. ATTRIBUTE_CODE
3. ATTRIBUTE_APPLICATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AK_OBJECT_ATTRIBUTES defines the attributes on an object. You will
need one row for each attribute you want to assign to an object.
You must define formatting properties (i.e., ATTRIBUTE_LABEL_LENGTH,
BOLD, ITALIC, VERTICAL_ALIGNMENT, etc.) for each attribute.

Indexes

Columns

[top of page]

AK.AK_OBJECT_ATTRIBUTES does not reference any database object

AK.AK_OBJECT_ATTRIBUTES is referenced by following:

APPS

SYNONYM - AK_OBJECT_ATTRIBUTES

[top of page]

Table: AK_OBJECT_ATTRIBUTES_TL

Primary Key: AK_OBJECT_ATTRIBUTES_TL_PK

1. DATABASE_OBJECT_NAME
2. ATTRIBUTE_CODE
3. ATTRIBUTE_APPLICATION_ID
4. LANGUAGE

Foreign Keys from this table:

Comments

AK_OBJECT_ATTRIBUTES_TL stores translated information about the object
attribute in AK_OBJECT_ATTRIBUTES. Each row includes the language the
row is translated to, the translated attributes of the object
attribute, and the object attribute identifier which uniquely
identifies the object attribute. You need one row for each object
attribute in each of the installed languages. Each row includes a
language and SOURCE_LANG column which can be used to determine if a
value has been translated or defaulted.

Indexes

Columns

[top of page]

AK.AK_OBJECT_ATTRIBUTES_TL does not reference any database object

AK.AK_OBJECT_ATTRIBUTES_TL is referenced by following:

APPS

SYNONYM - AK_OBJECT_ATTRIBUTES_TL

[top of page]

Table: AK_OBJECT_ATTRIBUTE_NAVIGATION

Primary Key: AK_OBJECT_ATTRIBUTE_NAVIGAT_PK

1. DATABASE_OBJECT_NAME
2. ATTRIBUTE_CODE
3. ATTRIBUTE_APPLICATION_ID
4. VALUE_VARCHAR2
5. VALUE_DATE
6. VALUE_NUMBER

Foreign Keys from this table:

Comments

AK_OBJECT_ATTRIBUTE_NAVIGATION is used only by Configurator
(CZ). This table provides navigation to a region by attribute value.
You need to create one row for each object attribute value that will
allow navigation to a region.
You must specify a target "To" region for each object attribute value.
If at run time, the object attributes value entered by the user
matches a row in this table, the user will have access to the target
region associated with this object attribute value.

Indexes

Columns

[top of page]

AK.AK_OBJECT_ATTRIBUTE_NAVIGATION does not reference any database object

AK.AK_OBJECT_ATTRIBUTE_NAVIGATION is referenced by following:

APPS

SYNONYM - AK_OBJECT_ATTRIBUTE_NAVIGATION

[top of page]

Table: AK_OBJECT_VALUES_TEMP

Comments

AK_OBJECT_VALUES_TEMP is used to create the LOV for the Value
field on the Run Flows form. The lov for the Value field calls a
package called AK_RUN_FLOW_PKG which uses this table to store the
results from running AK_QUERY_PKG.EXEC_QUERY.
This table should never be populated by any user.

Indexes

Columns

[top of page]

AK.AK_OBJECT_VALUES_TEMP does not reference any database object

AK.AK_OBJECT_VALUES_TEMP is referenced by following:

APPS

SYNONYM - AK_OBJECT_VALUES_TEMP

[top of page]

Table: AK_QUERY_OBJECTS

Primary Key: AK_QUERY_OBJECT_PK1

1. QUERY_CODE

Comments

AK_QUERY_OBJECTS table contains query object identifier and the application id of the owner of the query object

Indexes

Columns

[top of page]

AK.AK_QUERY_OBJECTS does not reference any database object

AK.AK_QUERY_OBJECTS is referenced by following:

APPS

SYNONYM - AK_QUERY_OBJECTS

[top of page]

Table: AK_QUERY_OBJECT_LINES

Primary Key: AK_QUERY_OBJECT_LINES_PK1

1. QUERY_CODE
2. SEQ_NUM

Comments

AK_QUERY_OBJECT_LINES contains children of a query object, each of them is a query object line. A query object line usually is a sql statement, it's ordered by seq_num column and its typed is identified by TYPE column.

Indexes

Columns

[top of page]

AK.AK_QUERY_OBJECT_LINES does not reference any database object

AK.AK_QUERY_OBJECT_LINES is referenced by following:

APPS

SYNONYM - AK_QUERY_OBJECT_LINES

[top of page]

Table: AK_REGIONS

Primary Key: AK_REGIONS_PK

1. REGION_CODE
2. REGION_APPLICATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AK_REGIONS contains regions and the application owner of the
region. A region contains a set of items that may be returned by
AK_QUERY_PKG. You need to one row for each region.
Each row must include a database object name and a region style. You
can also specify the number of columns that are to be displayed on the
region as well as an URL for the region.

Indexes

Columns

[top of page]

AK.AK_REGIONS does not reference any database object

AK.AK_REGIONS is referenced by following:

APPS

SYNONYM - AK_REGIONS

[top of page]

Table: AK_REGIONS_TL

Primary Key: AK_REGIONS_TL_PK

1. REGION_CODE
2. REGION_APPLICATION_ID
3. LANGUAGE

Foreign Keys from this table:

Comments

AK_REGIONS_TL stores translated information about the regions in
AK_REGIONS. Each row includes the language the row is translated to,
the translated attributes of the region, and the region identifier
which uniquely identifies the region. You need one row for each region
in each of the installed languages. Each row includes a language and
SOURCE_LANG column which can be used to determine if a value has been
translated or defaulted.

Indexes

Columns

[top of page]

AK.AK_REGIONS_TL does not reference any database object

AK.AK_REGIONS_TL is referenced by following:

APPS

SYNONYM - AK_REGIONS_TL

[top of page]

Table: AK_REGION_ITEMS

Primary Key: AK_REGION_ITEMS_PK

1. REGION_CODE
2. REGION_APPLICATION_ID
3. ATTRIBUTE_CODE
4. ATTRIBUTE_APPLICATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AK_REGION_ITEMS defines the item (attribute or object attribute) on a
region. An item is a single attribute or object attribute that exists
on a region. You will need one row for each item you want to assign to
a region.
You must define formatting properties (i.e., ATTRIBUTE_LABEL_LENGTH,
BOLD, ITALIC, VERTICAL_ALIGNMENT, etc.) for each item. You must
also specify if the item is an attribute or object attribute with the
OBJECT_ATTRIBUTE_FLAG. This table also allows you to specify other
properties for the item.

Indexes

Columns