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.
Description: | Stores Application module parameter names and values. |
---|
This table is used for storing the parameters and parameters sources for an Application module, that need to be passed to the initializePageValues().
Index | Type | Tablespace | Column |
---|---|---|---|
AK_AM_PARAMETER_REGISTRY_U1 | UNIQUE | APPS_TS_TX_IDX |
APPLICATIONMODULE_DEFN_NAME
PARAM_NAME PARAM_SOURCE ZD_EDITION_NAME |
AK_AM_PARAMETER_REGISTRY_N1 | NONUNIQUE | APPS_TS_TX_IDX | APPLICATIONMODULE_DEFN_NAME |
AK_AM_PARAMETER_REGISTRY_N2 | NONUNIQUE | APPS_TS_TX_IDX | APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATIONMODULE_DEFN_NAME | VARCHAR2 | (240) | Y | Application Module full definition name. |
PARAM_NAME | VARCHAR2 | (80) | Y | Parameter Name of the parameter that needs to be passed to initializePageValues(). |
PARAM_SOURCE | VARCHAR2 | (30) | Y | Parameter source of the parameter that needs to be passed to initializePageValues(). The possible values for this are request and session. |
APPLICATION_ID | NUMBER | (15) | Y | Application that owns the AM Parameter Registry. |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_AM_PARAMETER_REGISTRY does not reference any database object
AK.AK_AM_PARAMETER_REGISTRY is referenced by following:
Description: | Attribute name, properties and the application ID which define an attribute |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_ATTRIBUTES_TL.ATTRIBUTE_CODE
AK_ATTRIBUTES_TL.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
AK_EXCLUDED_ITEMS.ATTRIBUTE_CODE
AK_EXCLUDED_ITEMS.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
AK_OBJECT_ATTRIBUTES.ATTRIBUTE_CODE
AK_OBJECT_ATTRIBUTES.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
AK_REGION_ITEMS.ATTRIBUTE_CODE
AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
AK_RESP_SECURITY_ATTRIBUTES.ATTRIBUTE_CODE
AK_RESP_SECURITY_ATTRIBUTES.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
AK_WEB_USER_SEC_ATTR_VALUES.ATTRIBUTE_CODE
AK_WEB_USER_SEC_ATTR_VALUES.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
HZ_STYLE_FMT_LAYOUTS_B.ATTRIBUTE_CODE
HZ_STYLE_FMT_LAYOUTS_B.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
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.).
Index | Type | Tablespace | Column |
---|---|---|---|
AK_ATTRIBUTES_U1 | UNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
AK_ATTRIBUTES_N1 | NONUNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the attribute belongs to |
ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | Number of characters to be displayed for the attribute label | |
ATTRIBUTE_VALUE_LENGTH | NUMBER | (15) | Number of characters to be displayed for the attribute value | |
BOLD | VARCHAR2 | (1) | Y | Bold flag ('Y' - Bold the attribute value, 'N' - Do not bold the attribute value) |
ITALIC | VARCHAR2 | (1) | Y | Italic flag ('Y' - Italicize the attribute value, 'N' - Do not italicize the attribute value) |
VERTICAL_ALIGNMENT | VARCHAR2 | (30) | Y | Vertical Alignment for attribute |
HORIZONTAL_ALIGNMENT | VARCHAR2 | (30) | Y | Horizontal alignment for attribute |
DATA_TYPE | VARCHAR2 | (30) | Y | Data type of attribute |
UPPER_CASE_FLAG | VARCHAR2 | (1) | Flag to indicate whether the attribute should be in upper case ('Y' - upper case, 'N' - not upper case) | |
DEFAULT_VALUE_VARCHAR2 | VARCHAR2 | (240) | Default value of attribute when the data type of the attribute is VARCHAR | |
DEFAULT_VALUE_NUMBER | NUMBER | (15) | Default value of attribute when the data type of the attribute is NUMBER | |
DEFAULT_VALUE_DATE | DATE | Default value of attribute when the data type of the attribute is DATE or DATETIME | ||
LOV_REGION_CODE | VARCHAR2 | (30) | LOV Region identifier | |
LOV_REGION_APPLICATION_ID | NUMBER | (15) | Product team's application ID which the LOV Region belongs to | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ITEM_STYLE | VARCHAR2 | (30) | Y | Type of HTML User Interface object that will be use to represent this data. |
DISPLAY_HEIGHT | NUMBER | If this item is a text area then this property defines the vertical number of lines for that text. | ||
CSS_CLASS_NAME | VARCHAR2 | (80) | The cascading style sheet class name to apply to the label of a data item or the static text that will be displayed on a page. | |
POPLIST_VIEWOBJECT | VARCHAR2 | (240) | If this attribute is of item style poplist then this property defines the view object source for the list of possible values for the poplist. | |
POPLIST_DISPLAY_ATTRIBUTE | VARCHAR2 | (80) | If this attribute is of item style poplist then this property defines the view object source for the list of possible display values for the poplist that user can choose from. | |
POPLIST_VALUE_ATTRIBUTE | VARCHAR2 | (80) | If this attribute is of item style poplist then this property defines the view object source for the list of possible returned values for the poplist that user can choose from. | |
CSS_LABEL_CLASS_NAME | VARCHAR2 | (80) | The cascading style sheet label class name to apply to the value of a data item that will be displayed on a page. | |
EXPANSION | NUMBER | (15) | EXPANSION | |
ALS_MAX_LENGTH | NUMBER | (15) | Maximum length of Short Label | |
PRECISION | NUMBER | (15) | precision of data column when the data type is a number. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_ATTRIBUTES does not reference any database object
AK.AK_ATTRIBUTES is referenced by following:
Description: | Translations for AK_ATTRIBUTES |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_ATTRIBUTES_TL.ATTRIBUTE_CODE
AK_ATTRIBUTES_TL.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_ATTRIBUTES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID LANGUAGE ZD_EDITION_NAME |
AK_ATTRIBUTES_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_LABEL_LONG |
AK_ATTRIBUTES_TL_N2 | NONUNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_LABEL_SHORT |
AK_ATTRIBUTES_TL_N3 | NONUNIQUE | APPS_TS_TX_IDX | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the attribute belongs to |
LANGUAGE | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
NAME | VARCHAR2 | (80) | Y | Name of the attribute |
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | Label/Prompt of attribute | |
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (40) | A short label/prompt of attribute (this column is obsolete, do not use) | |
DESCRIPTION | VARCHAR2 | (2000) | Description of attribute | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language code of the language which the values of the translatable columns were originally entered |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_ATTRIBUTES_TL does not reference any database object
AK.AK_ATTRIBUTES_TL is referenced by following:
Description: | Defines relationship between attachment region item and categories |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_CATEGORY_USAGES.REGION_CODE
AK_CATEGORY_USAGES.REGION_APPLICATION_ID AK_CATEGORY_USAGES.ATTRIBUTE_CODE AK_CATEGORY_USAGES.ATTRIBUTE_APPLICATION_ID |
AK_REGION_ITEMS |
Defines relationship between attachment region item and categories
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CATEGORY_USAGES_U1 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID CATEGORY_NAME ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGION_CODE | VARCHAR2 | (30) | Y | region code |
REGION_APPLICATION_ID | NUMBER | (15) | Y | region application id |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Code of attribute |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the attribute belong to |
CATEGORY_NAME | VARCHAR2 | (30) | Y | Name of category in FND_DOCUMENT_CATEGORIES table that's assigned to the region. |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
CATEGORY_ID | NUMBER | (15) | Reference to category | |
APPLICATION_ID | NUMBER | (15) | Application id | |
SHOW_ALL | VARCHAR2 | (1) | Flag indicates whether all attachments of all categories will be shown for this region. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_CATEGORY_USAGES does not reference any database object
AK.AK_CATEGORY_USAGES is referenced by following:
Description: | Stores criteria for customization. |
---|
This table is used for storing the criteria for each customization.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CRITERIA_U1 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID CUSTOMIZATION_CODE CUSTOMIZATION_APPLICATION_ID ATTRIBUTE_APPLICATION_ID ATTRIBUTE_CODE SEQUENCE_NUMBER ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the region will be used |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code for a given region. |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the attribute will be used |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute Code of the given attribute |
SEQUENCE_NUMBER | NUMBER | (15) | Y | Sequence Number of the criteria within a given customization |
OPERATION | VARCHAR2 | (30) | Y | Operation used for the given criteria. Values come in from the lookup ICX_CONDITIONS. |
VALUE_VARCHAR2 | VARCHAR2 | (240) | Value of the criteria if the datatype is varchar2. | |
VALUE_NUMBER | NUMBER | (15) | Value of the criteria if the datatype is number. | |
VALUE_DATE | DATE | Value of the criteria if the datatype is date | ||
CREATED_BY | NUMBER | (15) | Y | WHO Column |
CREATION_DATE | DATE | Y | WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | WHO Column |
LAST_UPDATE_DATE | DATE | Y | WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | WHO Column |
START_DATE_ACTIVE | DATE | Y | WHO Column | |
END_DATE_ACTIVE | DATE | WHO Column | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_CRITERIA does not reference any database object
AK.AK_CRITERIA is referenced by following:
Description: | Stores region customizations |
---|
This table is used for storing the customizations of regions at different levels.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CUSTOMIZATIONS_U2 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID CUSTOMIZATION_CODE CUSTOMIZATION_APPLICATION_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the region will be used |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code for a given region. |
VERTICALIZATION_ID | VARCHAR2 | (150) | Verticalization Id. Populated for a verticalization customization. | |
LOCALIZATION_CODE | VARCHAR2 | (150) | Localization Code. Populated for a localization level customization. | |
ORG_ID | NUMBER | (15) | Org Id. Populated for an org level customization. | |
SITE_ID | NUMBER | (15) | Site Id. Populated for a site level customization. | |
RESPONSIBILITY_ID | NUMBER | (15) | Responsibility Id. Populated for a responsibility level customization. | |
WEB_USER_ID | NUMBER | (15) | User Id. Populated for user level customization. | |
DEFAULT_CUSTOMIZATION_FLAG | VARCHAR2 | (1) | Default Customization. Populated for user level customization. | |
CUSTOMIZATION_LEVEL_ID | NUMBER | (15) | Y | Level Id to indicate the level of customization. |
CREATED_BY | NUMBER | (15) | Y | WHO Column |
CREATION_DATE | DATE | Y | WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | WHO Column |
LAST_UPDATE_DATE | DATE | Y | WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | WHO Column |
START_DATE_ACTIVE | DATE | Y | WHO Column | |
END_DATE_ACTIVE | DATE | WHO Column | ||
REFERENCE_PATH | VARCHAR2 | (100) | Reference path for the specific portlet. This columnwill be populated with the reference path for portlet customizations. | |
FUNCTION_NAME | VARCHAR2 | (30) | Function Name. Populated for function level customization. | |
DEVELOPER_MODE | VARCHAR2 | (1) | This specifies whether a specific customization is created by a developer or not. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_CUSTOMIZATIONS does not reference any database object
AK.AK_CUSTOMIZATIONS is referenced by following:
Description: | The TL table corresponding to AK_CUSTOMIZATIONS. |
---|
The TL table corresponding to AK_CUSTOMIZATIONS.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CUSTOMIZATIONS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
CUSTOMIZATION_APPLICATION_ID
REGION_CODE CUSTOMIZATION_CODE LANGUAGE REGION_APPLICATION_ID ZD_EDITION_NAME |
AK_CUSTOMIZATIONS_TL_N2 | NONUNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID CUSTOMIZATION_CODE CUSTOMIZATION_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the region will be used |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code for a given region. |
NAME | VARCHAR2 | (80) | Y | Customization Name. |
DESCRIPTION | VARCHAR2 | (2000) | Customization Description. | |
LANGUAGE | VARCHAR2 | (4) | Y | Language. |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source Language. |
CREATED_BY | NUMBER | (15) | Y | WHO Column |
CREATION_DATE | DATE | Y | WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | WHO Column |
LAST_UPDATE_DATE | DATE | Y | WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | WHO Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_CUSTOMIZATIONS_TL does not reference any database object
AK.AK_CUSTOMIZATIONS_TL is referenced by following:
Description: | Stores region property customizations. |
---|
This table is used for storing the customizations of a region's properties for a specific region and customization.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CUSTOM_REGIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID CUSTOMIZATION_CODE CUSTOMIZATION_APPLICATION_ID PROPERTY_NAME ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the region will be used |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code for a given region. |
PROPERTY_NAME | VARCHAR2 | (30) | Y | Name of the property that can be customized. |
PROPERTY_VARCHAR2_VALUE | VARCHAR2 | (2000) | Value of the property if the datatype is varchar2. | |
PROPERTY_NUMBER_VALUE | NUMBER | Value of the property if the datatype is number. | ||
CRITERIA_JOIN_CONDITION | VARCHAR2 | (3) | Join condition used, if the customization has a criteria associated with it. Possible values that it can take are "AND" and "OR". | |
CREATED_BY | NUMBER | (15) | Y | WHO Column |
CREATION_DATE | DATE | Y | WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | WHO Column |
LAST_UPDATE_DATE | DATE | Y | WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | WHO Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_CUSTOM_REGIONS does not reference any database object
AK.AK_CUSTOM_REGIONS is referenced by following:
Description: | The TL table corresponding to AK_CUSTOM_REGIONS. |
---|
The TL table corresponding to AK_CUSTOM_REGIONS.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CUSTOM_REGIONS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
CUSTOMIZATION_APPLICATION_ID
CUSTOMIZATION_CODE LANGUAGE PROPERTY_NAME REGION_APPLICATION_ID REGION_CODE ZD_EDITION_NAME |
AK_CUSTOM_REGIONS_TL_N2 | NONUNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID CUSTOMIZATION_CODE CUSTOMIZATION_APPLICATION_ID PROPERTY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the region will be used |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code for a given region. |
PROPERTY_NAME | VARCHAR2 | (30) | Y | Name of the property that can be customized. |
PROPERTY_VARCHAR2_VALUE | VARCHAR2 | (2000) | Transalated Value of the property if the datatype is varchar2. | |
LANGUAGE | VARCHAR2 | (4) | Y | Language. |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source Language. |
CREATED_BY | NUMBER | (15) | Y | WHO Column |
CREATION_DATE | DATE | Y | WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | WHO Column |
LAST_UPDATE_DATE | DATE | Y | WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | WHO Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_CUSTOM_REGIONS_TL does not reference any database object
AK.AK_CUSTOM_REGIONS_TL is referenced by following:
Description: | Stores region item properties customizations. |
---|
This table is used for storing the customizations of region item properties for a specific region and customization.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CUSTOM_REGION_ITEMS_U1 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID CUSTOMIZATION_CODE CUSTOMIZATION_APPLICATION_ID ATTRIBUTE_APPLICATION_ID ATTRIBUTE_CODE PROPERTY_NAME ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the region will be used |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code for a given region. |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the attribute will be used |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute Code of the given attribute |
PROPERTY_NAME | VARCHAR2 | (30) | Y | Name of the property that can be customized. |
PROPERTY_VARCHAR2_VALUE | VARCHAR2 | (4000) | Value of the property if the datatype is varchar2. | |
PROPERTY_NUMBER_VALUE | NUMBER | Value of the property if the datatype is number. | ||
PROPERTY_DATE_VALUE | DATE | Value of the property if the datatype is a date. | ||
CREATED_BY | NUMBER | (15) | Y | WHO Column |
CREATION_DATE | DATE | Y | WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | WHO Column |
LAST_UPDATE_DATE | DATE | Y | WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | WHO Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_CUSTOM_REGION_ITEMS does not reference any database object
AK.AK_CUSTOM_REGION_ITEMS is referenced by following:
Description: | The TL table corresponding to AK_CUSTOM_REGION_ITEMS. |
---|
The TL table corresponding to AK_CUSTOM_REGION_ITEMS.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CUSTOM_REGION_ITEMS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
CUSTOMIZATION_APPLICATION_ID
CUSTOMIZATION_CODE REGION_APPLICATION_ID REGION_CODE ATTRIBUTE_APPLICATION_ID ATTRIBUTE_CODE PROPERTY_NAME LANGUAGE ZD_EDITION_NAME |
AK_CUSTOM_REGION_ITEMS_TL_N3 | NONUNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID CUSTOMIZATION_CODE CUSTOMIZATION_APPLICATION_ID ATTRIBUTE_APPLICATION_ID ATTRIBUTE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the region will be used |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code for a given region. |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the attribute will be used |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute Code of the given attribute |
PROPERTY_NAME | VARCHAR2 | (30) | Y | Name of the property that can be customized. |
PROPERTY_VARCHAR2_VALUE | VARCHAR2 | (4000) | Transalated Value of the property if the datatype is varchar2. | |
LANGUAGE | VARCHAR2 | (4) | Y | Language. |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source Language. |
CREATED_BY | NUMBER | (15) | Y | WHO Column |
CREATION_DATE | DATE | Y | WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | WHO Column |
LAST_UPDATE_DATE | DATE | Y | WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | WHO Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_CUSTOM_REGION_ITEMS_TL does not reference any database object
AK.AK_CUSTOM_REGION_ITEMS_TL is referenced by following:
Description: | Registry table for customizations. |
---|
Registry table for customizations. Stores if a property is transalatable or not.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_CUSTOM_REGISTRY_U1 | UNIQUE | APPS_TS_TX_IDX |
CUSTOM_LEVEL
PROPERTY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_LEVEL_ID | NUMBER | (15) | Y | Level Id to indicate the level of customization. |
CUSTOM_LEVEL | VARCHAR2 | (30) | Y | Can take in two values "REGION" or "REGION_ITEM" |
PROPERTY_NAME | VARCHAR2 | (30) | Y | Name of the property that can be customized. |
TRANSLATABLE | VARCHAR2 | (1) | Y | Flag to indicate if a property is transalatable or not. |
CREATED_BY | NUMBER | (15) | Y | WHO Column |
CREATION_DATE | DATE | Y | WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | WHO Column |
LAST_UPDATE_DATE | DATE | Y | WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | WHO Column |
AK.AK_CUSTOM_REGISTRY does not reference any database object
AK.AK_CUSTOM_REGISTRY is referenced by following:
Description: | List of secured attributes that should be hidden from a user based on their responsibility id |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_EXCLUDED_ITEMS.ATTRIBUTE_APPLICATION_ID
AK_EXCLUDED_ITEMS.RESPONSIBILITY_ID |
FND_RESPONSIBILITY |
AK_EXCLUDED_ITEMS.ATTRIBUTE_CODE
AK_EXCLUDED_ITEMS.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_EXCLUDED_ITEMS_U1 | UNIQUE | APPS_TS_TX_IDX |
RESPONSIBILITY_ID
RESP_APPLICATION_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESPONSIBILITY_ID | NUMBER | (15) | Y | Responsibility ID of the application user |
RESP_APPLICATION_ID | NUMBER | Y | Product team's application ID which the responsibility ID belong to | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Identifier of attribute which the user with the responsibility ID cannot access |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the attribute belongs to |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_EXCLUDED_ITEMS does not reference any database object
AK.AK_EXCLUDED_ITEMS is referenced by following:
Description: | Defines a flow and associates a primary page to a flow |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FLOWS.FLOW_CODE
AK_FLOWS.FLOW_APPLICATION_ID AK_FLOWS.PRIMARY_PAGE_CODE AK_FLOWS.PRIMARY_PAGE_APPL_ID |
AK_FLOW_PAGES |
Foreign Key Column | Foreign Table |
---|---|
AK_FLOWS_TL.FLOW_CODE
AK_FLOWS_TL.FLOW_APPLICATION_ID |
AK_FLOWS |
AK_FLOW_PAGES.FLOW_CODE
AK_FLOW_PAGES.FLOW_APPLICATION_ID |
AK_FLOWS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FLOWS_U1 | UNIQUE | APPS_TS_TX_IDX |
FLOW_CODE
FLOW_APPLICATION_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLOW_CODE | VARCHAR2 | (30) | Y | Flow unique identifier |
FLOW_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow belong to |
PRIMARY_PAGE_CODE | VARCHAR2 | (30) | Y | Identifier of primary page of the flow |
PRIMARY_PAGE_APPL_ID | NUMBER | (15) | Y | Product team's application ID which the primary flow page belong to |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FLOWS does not reference any database object
AK.AK_FLOWS is referenced by following:
Description: | Translations for AK_FLOWS |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FLOWS_TL.FLOW_CODE
AK_FLOWS_TL.FLOW_APPLICATION_ID |
AK_FLOWS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FLOWS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
FLOW_CODE
FLOW_APPLICATION_ID LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLOW_CODE | VARCHAR2 | (30) | Y | Flow unique identifier |
FLOW_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow belong to |
LANGUAGE | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
NAME | VARCHAR2 | (30) | Y | Name of flow |
DESCRIPTION | VARCHAR2 | (2000) | Description of flow | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language code of the language which the values of the translatable columns were originally entered |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FLOWS_TL does not reference any database object
AK.AK_FLOWS_TL is referenced by following:
Description: | Links a page to a flow and defines the primary region for each page |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FLOW_PAGES.FLOW_CODE
AK_FLOW_PAGES.FLOW_APPLICATION_ID |
AK_FLOWS |
AK_FLOW_PAGES.FLOW_APPLICATION_ID
AK_FLOW_PAGES.PAGE_CODE AK_FLOW_PAGES.PAGE_APPLICATION_ID AK_FLOW_PAGES.PRIMARY_REGION_CODE AK_FLOW_PAGES.FLOW_CODE AK_FLOW_PAGES.PRIMARY_REGION_APPL_ID |
AK_FLOW_PAGE_REGIONS |
Foreign Key Column | Foreign Table |
---|---|
AK_FLOWS.FLOW_CODE
AK_FLOWS.FLOW_APPLICATION_ID AK_FLOWS.PRIMARY_PAGE_CODE AK_FLOWS.PRIMARY_PAGE_APPL_ID |
AK_FLOW_PAGES |
AK_FLOW_PAGES_TL.FLOW_CODE
AK_FLOW_PAGES_TL.FLOW_APPLICATION_ID AK_FLOW_PAGES_TL.PAGE_CODE AK_FLOW_PAGES_TL.PAGE_APPLICATION_ID |
AK_FLOW_PAGES |
AK_FLOW_PAGE_REGIONS.FLOW_CODE
AK_FLOW_PAGE_REGIONS.FLOW_APPLICATION_ID AK_FLOW_PAGE_REGIONS.PAGE_CODE AK_FLOW_PAGE_REGIONS.PAGE_APPLICATION_ID |
AK_FLOW_PAGES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FLOW_PAGES_U1 | UNIQUE | APPS_TS_TX_IDX |
PAGE_APPLICATION_ID
PAGE_CODE FLOW_APPLICATION_ID FLOW_CODE ZD_EDITION_NAME |
AK_FLOW_PAGES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
FLOW_APPLICATION_ID
FLOW_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLOW_CODE | VARCHAR2 | (30) | Y | Flow unique identifier |
FLOW_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow belong to |
PAGE_CODE | VARCHAR2 | (30) | Y | Flow page identifier |
PAGE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow page belong to |
PRIMARY_REGION_CODE | VARCHAR2 | (30) | Y | Identifier of primary region for the page |
PRIMARY_REGION_APPL_ID | NUMBER | (15) | Y | Product team's application ID which the primary flow page region belong to |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FLOW_PAGES does not reference any database object
AK.AK_FLOW_PAGES is referenced by following:
Description: | Translations for AK_FLOW_PAGES |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FLOW_PAGES_TL.FLOW_CODE
AK_FLOW_PAGES_TL.FLOW_APPLICATION_ID AK_FLOW_PAGES_TL.PAGE_CODE AK_FLOW_PAGES_TL.PAGE_APPLICATION_ID |
AK_FLOW_PAGES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FLOW_PAGES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
FLOW_CODE
FLOW_APPLICATION_ID PAGE_CODE PAGE_APPLICATION_ID LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLOW_CODE | VARCHAR2 | (30) | Y | Flow unique identifier |
FLOW_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow belong to |
PAGE_CODE | VARCHAR2 | (30) | Y | Flow page identifier |
PAGE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow page belong to |
LANGUAGE | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
NAME | VARCHAR2 | (80) | Y | Name of flow page |
DESCRIPTION | VARCHAR2 | (2000) | Description of flow page | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language code of the language which the values of the translatable columns were originally entered |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FLOW_PAGES_TL does not reference any database object
AK.AK_FLOW_PAGES_TL is referenced by following:
Description: | Links a region to a page |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FLOW_PAGE_REGIONS.FLOW_CODE
AK_FLOW_PAGE_REGIONS.FLOW_APPLICATION_ID AK_FLOW_PAGE_REGIONS.PAGE_CODE AK_FLOW_PAGE_REGIONS.PAGE_APPLICATION_ID |
AK_FLOW_PAGES |
AK_FLOW_PAGE_REGIONS.REGION_CODE
AK_FLOW_PAGE_REGIONS.REGION_APPLICATION_ID |
AK_REGIONS |
AK_FLOW_PAGE_REGIONS.FLOW_APPLICATION_ID
AK_FLOW_PAGE_REGIONS.PAGE_CODE AK_FLOW_PAGE_REGIONS.PAGE_APPLICATION_ID AK_FLOW_PAGE_REGIONS.PARENT_REGION_CODE AK_FLOW_PAGE_REGIONS.FLOW_CODE AK_FLOW_PAGE_REGIONS.PARENT_REGION_APPLICATION_ID |
AK_FLOW_PAGE_REGIONS |
Foreign Key Column | Foreign Table |
---|---|
AK_FLOW_PAGES.FLOW_APPLICATION_ID
AK_FLOW_PAGES.PAGE_CODE AK_FLOW_PAGES.PAGE_APPLICATION_ID AK_FLOW_PAGES.PRIMARY_REGION_CODE AK_FLOW_PAGES.FLOW_CODE AK_FLOW_PAGES.PRIMARY_REGION_APPL_ID |
AK_FLOW_PAGE_REGIONS |
AK_FLOW_PAGE_REGIONS.FLOW_APPLICATION_ID
AK_FLOW_PAGE_REGIONS.PAGE_CODE AK_FLOW_PAGE_REGIONS.PAGE_APPLICATION_ID AK_FLOW_PAGE_REGIONS.PARENT_REGION_CODE AK_FLOW_PAGE_REGIONS.FLOW_CODE AK_FLOW_PAGE_REGIONS.PARENT_REGION_APPLICATION_ID |
AK_FLOW_PAGE_REGIONS |
AK_FLOW_PAGE_REGION_ITEMS.FLOW_APPLICATION_ID
AK_FLOW_PAGE_REGION_ITEMS.PAGE_CODE AK_FLOW_PAGE_REGION_ITEMS.PAGE_APPLICATION_ID AK_FLOW_PAGE_REGION_ITEMS.REGION_CODE AK_FLOW_PAGE_REGION_ITEMS.FLOW_CODE AK_FLOW_PAGE_REGION_ITEMS.REGION_APPLICATION_ID |
AK_FLOW_PAGE_REGIONS |
AK_FLOW_REGION_RELATIONS.FLOW_APPLICATION_ID
AK_FLOW_REGION_RELATIONS.FROM_PAGE_CODE AK_FLOW_REGION_RELATIONS.FROM_PAGE_APPL_ID AK_FLOW_REGION_RELATIONS.FROM_REGION_CODE AK_FLOW_REGION_RELATIONS.FLOW_CODE AK_FLOW_REGION_RELATIONS.FROM_REGION_APPL_ID |
AK_FLOW_PAGE_REGIONS |
AK_FLOW_REGION_RELATIONS.FLOW_APPLICATION_ID
AK_FLOW_REGION_RELATIONS.TO_PAGE_CODE AK_FLOW_REGION_RELATIONS.TO_PAGE_APPL_ID AK_FLOW_REGION_RELATIONS.TO_REGION_CODE AK_FLOW_REGION_RELATIONS.FLOW_CODE AK_FLOW_REGION_RELATIONS.TO_REGION_APPL_ID |
AK_FLOW_PAGE_REGIONS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FLOW_PAGE_REGIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
FLOW_CODE
FLOW_APPLICATION_ID PAGE_CODE PAGE_APPLICATION_ID REGION_CODE REGION_APPLICATION_ID ZD_EDITION_NAME |
AK_FLOW_PAGE_REGIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID |
AK_FLOW_PAGE_REGIONS_U2 | NONUNIQUE | APPS_TS_TX_IDX |
FLOW_CODE
FLOW_APPLICATION_ID PAGE_CODE PAGE_APPLICATION_ID DISPLAY_SEQUENCE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLOW_CODE | VARCHAR2 | (30) | Y | Flow unique identifier |
FLOW_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow belong to |
PAGE_CODE | VARCHAR2 | (30) | Y | Flow page identifier |
PAGE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow page belong to |
REGION_CODE | VARCHAR2 | (30) | Y | Flow page region unique identifier |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow page region belong to |
DISPLAY_SEQUENCE | NUMBER | (15) | The sequence number of displaying flow page region | |
REGION_STYLE | VARCHAR2 | (30) | Y | Defines the style for the region |
NUM_COLUMNS | NUMBER | (15) | Number of columns for this flow page region | |
PARENT_REGION_CODE | VARCHAR2 | (30) | Parent region for this flow page region | |
PARENT_REGION_APPLICATION_ID | NUMBER | (15) | Product team's application id which the parent region belong to | |
ICX_CUSTOM_CALL | VARCHAR2 | (80) | Link to a URL which the application can access | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FLOW_PAGE_REGIONS does not reference any database object
AK.AK_FLOW_PAGE_REGIONS is referenced by following:
Description: | Links a region item to a region |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FLOW_PAGE_REGION_ITEMS.FLOW_APPLICATION_ID
AK_FLOW_PAGE_REGION_ITEMS.PAGE_CODE AK_FLOW_PAGE_REGION_ITEMS.PAGE_APPLICATION_ID AK_FLOW_PAGE_REGION_ITEMS.REGION_CODE AK_FLOW_PAGE_REGION_ITEMS.FLOW_CODE AK_FLOW_PAGE_REGION_ITEMS.REGION_APPLICATION_ID |
AK_FLOW_PAGE_REGIONS |
AK_FLOW_PAGE_REGION_ITEMS.REGION_CODE
AK_FLOW_PAGE_REGION_ITEMS.REGION_APPLICATION_ID AK_FLOW_PAGE_REGION_ITEMS.ATTRIBUTE_CODE AK_FLOW_PAGE_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID |
AK_REGION_ITEMS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FLOW_PAGE_REGION_ITEMS_U1 | UNIQUE | APPS_TS_TX_IDX |
FLOW_CODE
FLOW_APPLICATION_ID PAGE_CODE PAGE_APPLICATION_ID REGION_CODE REGION_APPLICATION_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
AK_FLOW_PAGE_REGION_ITEMS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID |
AK_FLOW_PAGE_REGION_ITEMS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID |
AK_FLOW_PAGE_REGION_ITEMS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
TO_URL_ATTRIBUTE_CODE
TO_URL_ATTRIBUTE_APPL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLOW_CODE | VARCHAR2 | (30) | Y | Flow unique identifier |
FLOW_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow belong to |
PAGE_CODE | VARCHAR2 | (30) | Y | Flow page identifier |
PAGE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow page belong to |
REGION_CODE | VARCHAR2 | (30) | Y | Flow page region identifier |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow page region belong to |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Identifier of flow page region item which is usually the same as the attribute identifier in AK_ATTRIBUTES |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow page region item belong to |
TO_PAGE_CODE | VARCHAR2 | (30) | Target page identifier for this flow. If this has been specified, then TO_URL_ATTRIBUTE_CODE and TO_URL_ATTRIBUTE_APPL_ID must be null | |
TO_PAGE_APPL_ID | NUMBER | (15) | Product team's application id which the target page belong to. If this has been specified, then TO_URL_ATTRIBUTE_CODE and TO_URL_ATTRIBUTE_APPL_ID must be null | |
TO_URL_ATTRIBUTE_CODE | VARCHAR2 | (30) | Target URL attribute itentifier, this value must exist in AK_ATTRIBUTES with DATA_TYPE = 'URL'. TO_PAGE_CODE and TO_PAGE_APPL_ID must be null in order to use this field | |
TO_URL_ATTRIBUTE_APPL_ID | NUMBER | (15) | Product team's application ID which the target URL attribute belong to. To use this field, TO_PAGE_CODE and TO_PAGE_APPL_ID must be null | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FLOW_PAGE_REGION_ITEMS does not reference any database object
AK.AK_FLOW_PAGE_REGION_ITEMS is referenced by following:
Description: | Links two page regions together by a foreign key |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FLOW_REGION_RELATIONS.FLOW_APPLICATION_ID
AK_FLOW_REGION_RELATIONS.FROM_PAGE_CODE AK_FLOW_REGION_RELATIONS.FROM_PAGE_APPL_ID AK_FLOW_REGION_RELATIONS.FROM_REGION_CODE AK_FLOW_REGION_RELATIONS.FLOW_CODE AK_FLOW_REGION_RELATIONS.FROM_REGION_APPL_ID |
AK_FLOW_PAGE_REGIONS |
AK_FLOW_REGION_RELATIONS.FLOW_APPLICATION_ID
AK_FLOW_REGION_RELATIONS.TO_PAGE_CODE AK_FLOW_REGION_RELATIONS.TO_PAGE_APPL_ID AK_FLOW_REGION_RELATIONS.TO_REGION_CODE AK_FLOW_REGION_RELATIONS.FLOW_CODE AK_FLOW_REGION_RELATIONS.TO_REGION_APPL_ID |
AK_FLOW_PAGE_REGIONS |
AK_FLOW_REGION_RELATIONS.FOREIGN_KEY_NAME | AK_FOREIGN_KEYS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FLOW_REGION_RELATIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
FLOW_CODE
FLOW_APPLICATION_ID FOREIGN_KEY_NAME FROM_PAGE_CODE FROM_PAGE_APPL_ID FROM_REGION_CODE FROM_REGION_APPL_ID TO_PAGE_CODE TO_PAGE_APPL_ID TO_REGION_CODE TO_REGION_APPL_ID ZD_EDITION_NAME |
AK_FLOW_REGION_RELATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | FOREIGN_KEY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLOW_CODE | VARCHAR2 | (30) | Y | Flow unique identifier |
FLOW_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the flow belong to |
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Y | Name of foreign key relationship between the from flow page region and the to flow page region |
FROM_PAGE_CODE | VARCHAR2 | (30) | Y | From flow page identifier |
FROM_PAGE_APPL_ID | NUMBER | (15) | Y | Product team's application ID which the from flow page belong to |
FROM_REGION_CODE | VARCHAR2 | (30) | Y | From flow page region identifier |
FROM_REGION_APPL_ID | NUMBER | (15) | Y | Product team's application ID which the from flow page region belong to |
TO_PAGE_CODE | VARCHAR2 | (30) | Y | Destination flow page identifier |
TO_PAGE_APPL_ID | NUMBER | (15) | Y | Product team's application ID which the destination flow page belong to |
TO_REGION_CODE | VARCHAR2 | (30) | Y | Destination flow page region identifier |
TO_REGION_APPL_ID | NUMBER | (15) | Y | Product team's application ID which the destination flow page region belong to |
APPLICATION_ID | NUMBER | (15) | Y | Application ID of product team who defined this flow page region relation |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FLOW_REGION_RELATIONS does not reference any database object
AK.AK_FLOW_REGION_RELATIONS is referenced by following:
Description: | Foreign keys for an object |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FOREIGN_KEYS.DATABASE_OBJECT_NAME | AK_OBJECTS |
AK_FOREIGN_KEYS.UNIQUE_KEY_NAME | AK_UNIQUE_KEYS |
Foreign Key Column | Foreign Table |
---|---|
AK_FLOW_REGION_RELATIONS.FOREIGN_KEY_NAME | AK_FOREIGN_KEYS |
AK_FOREIGN_KEYS_TL.FOREIGN_KEY_NAME | AK_FOREIGN_KEYS |
AK_FOREIGN_KEY_COLUMNS.FOREIGN_KEY_NAME | AK_FOREIGN_KEYS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FOREIGN_KEYS_U1 | UNIQUE | APPS_TS_TX_IDX |
FOREIGN_KEY_NAME
ZD_EDITION_NAME |
AK_FOREIGN_KEYS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
UNIQUE_KEY_NAME
DATABASE_OBJECT_NAME |
AK_FOREIGN_KEYS_N2 | NONUNIQUE | APPS_TS_TX_IDX | DATABASE_OBJECT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Y | Unique identifier for a foreign key relationship. |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Identifier of database object which contains the foreign key. |
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Y | Identifier of primary key of the database object that has been specified in DATABASE_OBJECT_NAME. |
APPLICATION_ID | NUMBER | (15) | Y | Application Id of product team who defined this foreign key relationship. |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FOREIGN_KEYS does not reference any database object
AK.AK_FOREIGN_KEYS is referenced by following:
Description: | Translations for AK_FOREIGN_KEYS |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FOREIGN_KEYS_TL.FOREIGN_KEY_NAME | AK_FOREIGN_KEYS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FOREIGN_KEYS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
FOREIGN_KEY_NAME
LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Y | Unique identifier for this foreign key relationship |
LANGUAGE | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
FROM_TO_NAME | VARCHAR2 | (45) | A user friendly name for the foreign key relationship | |
FROM_TO_DESCRIPTION | VARCHAR2 | (1500) | Description of the foreign key relationship | |
TO_FROM_NAME | VARCHAR2 | (45) | A user friendly name of the reverse foreign key relationship | |
TO_FROM_DESCRIPTION | VARCHAR2 | (1500) | Description of the reverse foreign key relationship | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language code of the language which the values of the translatable columns were originally entered |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FOREIGN_KEYS_TL does not reference any database object
AK.AK_FOREIGN_KEYS_TL is referenced by following:
Description: | Links an attribute to a foreign key |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FOREIGN_KEY_COLUMNS.FOREIGN_KEY_NAME | AK_FOREIGN_KEYS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_FOREIGN_KEY_COLUMNS_U1 | UNIQUE | APPS_TS_TX_IDX |
FOREIGN_KEY_NAME
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
AK_FOREIGN_KEY_COLUMNS_U2 | UNIQUE | APPS_TS_TX_IDX |
FOREIGN_KEY_NAME
FOREIGN_KEY_SEQUENCE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Y | Unique identifier of the foreign key relationship |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier of the foreign key column |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application Id which the attribute belong to |
FOREIGN_KEY_SEQUENCE | NUMBER | (15) | Y | Sequence number of foreign key column |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_FOREIGN_KEY_COLUMNS does not reference any database object
AK.AK_FOREIGN_KEY_COLUMNS is referenced by following:
Description: | This table is used by the Configurator (CZ) team and is used to store items |
---|
AK_INST_ATTRIBUTE_VALUES is used by the Configurator (CZ) team and is
used to store items.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_INST_ATTRIBUTE_VALUES_U1 | UNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
KEY_VALUE1 KEY_VALUE2 KEY_VALUE3 KEY_VALUE4 KEY_VALUE5 KEY_VALUE6 KEY_VALUE7 KEY_VALUE8 KEY_VALUE9 KEY_VALUE10 ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
AK_INST_ATTRIBUTE_VALUES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
KEY_VALUE1 KEY_VALUE2 KEY_VALUE3 |
AK_INST_ATTRIBUTE_VALUES_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID DATABASE_OBJECT_NAME |
AK_INST_ATTRIBUTE_VALUES_N3 | NONUNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
KEY_VALUE1 KEY_VALUE2 ATTRIBUTE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Database object identifier |
KEY_VALUE1 | VARCHAR2 | (100) | Y | First key value of database object |
KEY_VALUE2 | VARCHAR2 | (100) | Second key value of database object | |
KEY_VALUE3 | VARCHAR2 | (100) | Third key value of database object | |
KEY_VALUE4 | VARCHAR2 | (100) | Fourth key value of database object | |
KEY_VALUE5 | VARCHAR2 | (100) | Fifth key value of database object | |
KEY_VALUE6 | VARCHAR2 | (100) | Sixth key value of database object | |
KEY_VALUE7 | VARCHAR2 | (100) | Seventh key value of database object | |
KEY_VALUE8 | VARCHAR2 | (100) | Eigth key value of database object | |
KEY_VALUE9 | VARCHAR2 | (100) | Ninth key value of database object | |
KEY_VALUE10 | VARCHAR2 | (100) | Tenth key value of database object | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application Id which the attribute belong to |
VALUE_VARCHAR2 | VARCHAR2 | (240) | Value of attribute if the attribute is a varchar | |
VALUE_DATE | DATE | Value of attribute if the attribute is a date | ||
VALUE_NUMBER | NUMBER | (15) | Value of attribute if the attribute is a number | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_INST_ATTRIBUTE_VALUES does not reference any database object
AK.AK_INST_ATTRIBUTE_VALUES is referenced by following:
Description: | A temporary table that is used by the AK loaders |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
SYS_C00169268 | UNIQUE |
SESSION_ID
TBL_INDEX |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TBL_INDEX | NUMBER | (15) | Y | |
LINE_CONTENT | VARCHAR2 | (2000) | ||
SESSION_ID | NUMBER |
AK.AK_LOADER_TEMP does not reference any database object
AK.AK_LOADER_TEMP is referenced by following:
Description: | Defines the lookup codes, type and description that are used within the AK system |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_LOOKUP_CODES_U1 | UNIQUE | APPS_TS_TX_IDX |
LOOKUP_TYPE
LOOKUP_CODE LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_CODE | VARCHAR2 | (25) | Y | Name of the lookup code |
LOOKUP_TYPE | VARCHAR2 | (30) | Y | Defines the type of lookup code |
DESCRIPTION | VARCHAR2 | (80) | A user friendly description of the lookup type | |
LANGUAGE | VARCHAR2 | (4) | The language code of the language which the translatable fields are translated to | |
SOURCE_LANG | VARCHAR2 | (4) | Language code of the language which the values of the translatable columns were originally entered | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_LOOKUP_CODES does not reference any database object
AK.AK_LOOKUP_CODES is referenced by following:
Description: | Temporary validation table used by the Multi-Org Validation Report. |
---|
AK_MULTIORG_VALIDATION_TEMP is a temporary validation table used by the Multi-Org Validation
Report.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CODE | VARCHAR2 | (5) | Validation entity identifier | |
ORGANIZATION_ID | NUMBER | (22) | Identifier of the organization for which the report is being run. | |
OPERATING_UNIT | VARCHAR2 | (240) | operating unit identifier | |
APPLICATION_ID | NUMBER | (22) | Application identifier for this validation | |
RESPONSIBILITY_ID | NUMBER | (22) | Responsibility identifier for this validation | |
RESPONSIBILITY | VARCHAR2 | (100) | Responsibility name for this validation | |
USER_PROFILE_OPTION_NAME | VARCHAR2 | (240) | User profile name for this validation | |
PROFILE_LEVEL | VARCHAR2 | (80) | Profile level forthis validation | |
PROFILE_OPTION_VALUE | VARCHAR2 | (240) | Profile value for this validation |
AK.AK_MULTIORG_VALIDATION_TEMP does not reference any database object
AK.AK_MULTIORG_VALIDATION_TEMP is referenced by following:
Description: | Defines an object and the application id of the owner of the object |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_FOREIGN_KEYS.DATABASE_OBJECT_NAME | AK_OBJECTS |
AK_OBJECTS_TL.DATABASE_OBJECT_NAME | AK_OBJECTS |
AK_OBJECT_ATTRIBUTES.DATABASE_OBJECT_NAME | AK_OBJECTS |
AK_REGIONS.DATABASE_OBJECT_NAME | AK_OBJECTS |
AK_UNIQUE_KEYS.DATABASE_OBJECT_NAME | AK_OBJECTS |
ASO_APR_OBJ_APPROVALS.AK_OBJECT | AK_OBJECTS |
ASO_APR_RULES_B.AK_OBJECT | AK_OBJECTS |
ASO_APR_RULE_GROUPS_B.AK_OBJECT | AK_OBJECTS |
HZ_STYLES_B.DATABASE_OBJECT_NAME | AK_OBJECTS |
OE_AK_OBJECTS_EXT.DATABASE_OBJECT_NAME | AK_OBJECTS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_OBJECTS_U1 | UNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
ZD_EDITION_NAME |
AK_OBJECTS_N1 | NONUNIQUE | APPS_TS_TX_IDX | APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Unique identifier of a database object |
PRIMARY_KEY_NAME | VARCHAR2 | (30) | Primary key of the database object | |
DEFAULTING_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains code used to populate default values to the attributes for this object | |
DEFAULTING_API_PROC | VARCHAR2 | (30) | Procedure name in the PL/SQL package which is used to populate default values for the attributes on the object | |
VALIDATION_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains code used to validate the attributes for this object | |
VALIDATION_API_PROC | VARCHAR2 | (30) | Procedure name in the PL/SQL package which is used to validate the attributes for this object | |
APPLICATION_ID | NUMBER | (15) | Y | Product team's application id which the database object belong to |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_OBJECTS does not reference any database object
AK.AK_OBJECTS is referenced by following:
Description: | Translations for AK_OBJECTS |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_OBJECTS_TL.DATABASE_OBJECT_NAME | AK_OBJECTS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_OBJECTS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
LANGUAGE ZD_EDITION_NAME |
AK_OBJECTS_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Unique identifier of database object |
LANGUAGE | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
NAME | VARCHAR2 | (30) | User friendly name of database object | |
DESCRIPTION | VARCHAR2 | (2000) | Description of database object | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language code of the language which the values of the translatable columns were originally entered |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_OBJECTS_TL does not reference any database object
AK.AK_OBJECTS_TL is referenced by following:
Description: | Links an attribute to an object |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_OBJECT_ATTRIBUTES.DATABASE_OBJECT_NAME | AK_OBJECTS |
AK_OBJECT_ATTRIBUTES.ATTRIBUTE_CODE
AK_OBJECT_ATTRIBUTES.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
Foreign Key Column | Foreign Table |
---|---|
AK_OBJECT_ATTRIBUTES_TL.DATABASE_OBJECT_NAME
AK_OBJECT_ATTRIBUTES_TL.ATTRIBUTE_CODE AK_OBJECT_ATTRIBUTES_TL.ATTRIBUTE_APPLICATION_ID |
AK_OBJECT_ATTRIBUTES |
AK_OBJECT_ATTRIBUTE_NAVIGATION.DATABASE_OBJECT_NAME
AK_OBJECT_ATTRIBUTE_NAVIGATION.ATTRIBUTE_CODE AK_OBJECT_ATTRIBUTE_NAVIGATION.ATTRIBUTE_APPLICATION_ID |
AK_OBJECT_ATTRIBUTES |
ASO_APR_RULE_STEPS_B.LHS_AK_OBJECT
ASO_APR_RULE_STEPS_B.LHS_AK_ATTRIBUTE_CODE ASO_APR_RULE_STEPS_B.LHS_AK_ATTR_APPLIC_ID |
AK_OBJECT_ATTRIBUTES |
ASO_APR_RULE_STEPS_B.RHS_AK_OBJECT
ASO_APR_RULE_STEPS_B.RHS_AK_ATTRIBUTE_CODE ASO_APR_RULE_STEPS_B.RHS_AK_ATTR_APPLIC_ID |
AK_OBJECT_ATTRIBUTES |
OE_AK_OBJ_ATTR_EXT.DATABASE_OBJECT_NAME
OE_AK_OBJ_ATTR_EXT.ATTRIBUTE_CODE OE_AK_OBJ_ATTR_EXT.ATTRIBUTE_APPLICATION_ID |
AK_OBJECT_ATTRIBUTES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_OBJECT_ATTRIBUTES_U1 | UNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
AK_OBJECT_ATTRIBUTES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID |
AK_OBJECT_ATTRIBUTES_N2 | NONUNIQUE | APPS_TS_TX_IDX | LOV_FOREIGN_KEY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Database object identifier |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier of a database object |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application id which the object attribute belong to |
COLUMN_NAME | VARCHAR2 | (30) | User friendly name of object attribute | |
ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | Y | Length of the attribute's prompt/label |
BOLD | VARCHAR2 | (1) | Y | Bold flag ('Y' - Bold the object attribute value, 'N' - Do not bold the object attribute value) |
ITALIC | VARCHAR2 | (1) | Y | Italic flag ('Y' - Italicize the object attribute value, 'N' - Do not italicize the object attribute value) |
VERTICAL_ALIGNMENT | VARCHAR2 | (30) | Y | Vertical Alignment for the object attribute |
HORIZONTAL_ALIGNMENT | VARCHAR2 | (30) | Y | Horizontal alignment for object attribute |
DATA_SOURCE_TYPE | VARCHAR2 | (30) | Y | Data soure type specifies where the object attribute comes from |
DATA_STORAGE_TYPE | VARCHAR2 | (30) | Data source type specifies where the object attribute is stored | |
TABLE_NAME | VARCHAR2 | (30) | User friendly name of database object | |
BASE_TABLE_COLUMN_NAME | VARCHAR2 | (30) | Base table column name | |
REQUIRED_FLAG | VARCHAR2 | (1) | Y | Flag to indicate whether the object attribute should be required ('Y' - required, 'N' - not required) |
DISPLAY_VALUE_LENGTH | NUMBER | (15) | Y | Number of characters of object attribute to be displayed |
LOV_REGION_CODE | VARCHAR2 | (30) | LOV Region identifier | |
LOV_REGION_APPLICATION_ID | NUMBER | (15) | Product team's application ID which the LOV region is belonged to | |
LOV_FOREIGN_KEY_NAME | VARCHAR2 | (30) | Lov foreign key relationship identifier | |
LOV_ATTRIBUTE_CODE | VARCHAR2 | (30) | LOV attribute identifier | |
LOV_ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Product team's application id which the lov attribute belong to | |
DEFAULTING_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains the stored procedure to populate default values into this object attribute | |
DEFAULTING_API_PROC | VARCHAR2 | (30) | Procedure name in PL/SQL package which populates default values into this object attribute | |
VALIDATION_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains the procedure to validate the object attribute's value | |
VALIDATION_API_PROC | VARCHAR2 | (30) | Procedure name in PL/SQL package which contains the procedure to validate the object attribute's value | |
DEFAULT_VALUE_VARCHAR2 | VARCHAR2 | (240) | Default value of object attribute when the data type of the object attribute is VARCHAR | |
DEFAULT_VALUE_NUMBER | NUMBER | (15) | Default value of object attribute when the data type of the object attribute is NUMBER | |
DEFAULT_VALUE_DATE | DATE | Default value of object attribute when the data type of the object attribute is DATE | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
TRANSLATION_FLAG | VARCHAR2 | (1) | Flag which indicates whether the mapping database column is translatable, valid values are 'Y' and 'N'. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_OBJECT_ATTRIBUTES does not reference any database object
AK.AK_OBJECT_ATTRIBUTES is referenced by following:
Description: | Translations for AK_OBJECT_ATTRIBUTES |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_OBJECT_ATTRIBUTES_TL.DATABASE_OBJECT_NAME
AK_OBJECT_ATTRIBUTES_TL.ATTRIBUTE_CODE AK_OBJECT_ATTRIBUTES_TL.ATTRIBUTE_APPLICATION_ID |
AK_OBJECT_ATTRIBUTES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_OBJECT_ATTRIBUTES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID LANGUAGE ZD_EDITION_NAME |
AK_OBJECT_ATTRIBUTES_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Database object identifier |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier of a database object |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application id which the object attribute belong to |
LANGUAGE | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | Label/Prompt of object attribute | |
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (30) | A short label/prompt of object attribute (this column is obsolete, do not use) | |
SOURCE_LANG | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_OBJECT_ATTRIBUTES_TL does not reference any database object
AK.AK_OBJECT_ATTRIBUTES_TL is referenced by following:
Description: | Defines a specific object attribute value which allows access to a region |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_OBJECT_ATTRIBUTE_NAVIGATION.DATABASE_OBJECT_NAME
AK_OBJECT_ATTRIBUTE_NAVIGATION.ATTRIBUTE_CODE AK_OBJECT_ATTRIBUTE_NAVIGATION.ATTRIBUTE_APPLICATION_ID |
AK_OBJECT_ATTRIBUTES |
AK_OBJECT_ATTRIBUTE_NAVIGATION.TO_REGION_CODE
AK_OBJECT_ATTRIBUTE_NAVIGATION.TO_REGION_APPL_ID |
AK_REGIONS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_OBJECT_ATTRIBUTE_NAVIGAT_U1 | UNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID VALUE_VARCHAR2 VALUE_DATE VALUE_NUMBER ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Database object identifier |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier of a database object |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application id which the object attribute belong to |
VALUE_VARCHAR2 | VARCHAR2 | (240) | Value of object attribute if attribute is a VARCHAR | |
VALUE_DATE | DATE | Value of object attribute if attribute is a DATE | ||
VALUE_NUMBER | NUMBER | (15) | Value of object attribute if attribute is a NUMBER | |
TO_REGION_CODE | VARCHAR2 | (30) | Y | Target region identifier |
TO_REGION_APPL_ID | NUMBER | (15) | Y | Product team's application id that the target region belong to |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_OBJECT_ATTRIBUTE_NAVIGATION does not reference any database object
AK.AK_OBJECT_ATTRIBUTE_NAVIGATION is referenced by following:
Description: | Temporary table for building the LOV of attribute values in the AKDPICKF form |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_OBJECT_VALUES_TEMP_N1 | NONUNIQUE | APPS_TS_INTERFACE |
REGION_CODE
REGION_APPLICATION_ID TRACE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRACE_NUM | NUMBER | (15) | Y | Trace number |
REGION_APPLICATION_ID | NUMBER | (15) | Product team's application id that this region belong to | |
REGION_CODE | VARCHAR2 | (30) | Region identifier | |
DISPLAY_VALUE | VARCHAR2 | (510) | Display value | |
KEY_VALUE1 | VARCHAR2 | (240) | First key value of the database object which the region is based on | |
KEY_VALUE2 | VARCHAR2 | (240) | Second key value of the database object which the region is based on | |
KEY_VALUE3 | VARCHAR2 | (240) | Third key value of the database object which the region is based on | |
KEY_VALUE4 | VARCHAR2 | (240) | Fourth key value of the database object which the region is based on | |
KEY_VALUE5 | VARCHAR2 | (240) | Fifth key value of the database object which the region is based on | |
KEY_VALUE6 | VARCHAR2 | (240) | Sixth key value of the database object which the region is based on | |
KEY_VALUE7 | VARCHAR2 | (240) | Seventh key value of the database object which the region is based on | |
KEY_VALUE8 | VARCHAR2 | (240) | Eighth key value of the database object which the region is based on | |
KEY_VALUE9 | VARCHAR2 | (240) | Ninth key value of the database object which the region is based on | |
KEY_VALUE10 | VARCHAR2 | (240) | Tenth key value of the database object which the region is based on |
AK.AK_OBJECT_VALUES_TEMP does not reference any database object
AK.AK_OBJECT_VALUES_TEMP is referenced by following:
Description: | Defines a query object and the application id of the owner of the query object |
---|
AK_QUERY_OBJECTS table contains query object identifier and the application id of the owner of the query object
Index | Type | Tablespace | Column |
---|---|---|---|
AK_QUERY_OBJECTS_U1 | UNIQUE | APPS_TS_TX_IDX |
QUERY_CODE
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_CODE | VARCHAR2 | (30) | Y | Unique identifier of a query object |
APPLICATION_ID | NUMBER | Y | Application ID of query object owner | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_QUERY_OBJECTS does not reference any database object
AK.AK_QUERY_OBJECTS is referenced by following:
Description: | Links a line to a query object |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_QUERY_OBJECT_LINES_U1 | UNIQUE | APPS_TS_TX_IDX |
QUERY_CODE
SEQ_NUM ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_CODE | VARCHAR2 | (30) | Y | Identifier of query object |
SEQ_NUM | NUMBER | Y | Sequence number of query object line | |
QUERY_LINE_TYPE | VARCHAR2 | (30) | Type of the query object line which indicates what kind of sql clause this is. | |
QUERY_LINE | VARCHAR2 | (4000) | content of query object line, which is usually a sql statement | |
LINKED_PARAMETER | VARCHAR2 | (30) | Not being used, created for future development | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_QUERY_OBJECT_LINES does not reference any database object
AK.AK_QUERY_OBJECT_LINES is referenced by following:
Description: | Defines a region |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_REGIONS.DATABASE_OBJECT_NAME | AK_OBJECTS |
Foreign Key Column | Foreign Table |
---|---|
AK_FLOW_PAGE_REGIONS.REGION_CODE
AK_FLOW_PAGE_REGIONS.REGION_APPLICATION_ID |
AK_REGIONS |
AK_OBJECT_ATTRIBUTE_NAVIGATION.TO_REGION_CODE
AK_OBJECT_ATTRIBUTE_NAVIGATION.TO_REGION_APPL_ID |
AK_REGIONS |
AK_REGIONS_TL.REGION_CODE
AK_REGIONS_TL.REGION_APPLICATION_ID |
AK_REGIONS |
AK_REGION_ITEMS.REGION_CODE
AK_REGION_ITEMS.REGION_APPLICATION_ID |
AK_REGIONS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_REGIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID ZD_EDITION_NAME |
AK_REGIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | REGION_APPLICATION_ID |
AK_REGIONS_N2 | NONUNIQUE | APPS_TS_TX_IDX | DATABASE_OBJECT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGION_CODE | VARCHAR2 | (30) | Y | Region identifier |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Product team's application id which the region belong to |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Database object identifier |
REGION_STYLE | VARCHAR2 | (30) | Y | Region style of the region to be displayed |
NUM_COLUMNS | NUMBER | (15) | Number of columns of region to be displayed | |
REGION_DEFAULTING_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains the stored procedure to populate default values of regions | |
REGION_DEFAULTING_API_PROC | VARCHAR2 | (30) | Procedure name in PL/SQL package which populates default values of regions | |
REGION_VALIDATION_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains the procedure to validate default values of regions | |
REGION_VALIDATION_API_PROC | VARCHAR2 | (30) | Procedure name in PL/SQL package which contains the procedure to validate default values of regions | |
ICX_CUSTOM_CALL | VARCHAR2 | (80) | A URL to launch an html file | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
APPLICATIONMODULE_OBJECT_TYPE | VARCHAR2 | (240) | The application module that has been created for the view objects that are utilized in this region. | |
NUM_ROWS_DISPLAY | NUMBER | If this region is a table region style then the display rows attribute determines how many rows to show in that region. | ||
REGION_OBJECT_TYPE | VARCHAR2 | (240) | Type of HTML User Interface component that will be used to organize this data into a logical unit. | |
IMAGE_FILE_NAME | VARCHAR2 | (80) | column for putting icon file name when displaying region title | |
ISFORM_FLAG | VARCHAR2 | (1) | Y | column to indicate whether this region is a form |
HELP_TARGET | VARCHAR2 | (240) | stores location of product team's specific help file | |
STYLE_SHEET_FILENAME | VARCHAR2 | (240) | file name of style sheet that applies to the region | |
VERSION | VARCHAR2 | (30) | OAFramework version number | |
APPLICATIONMODULE_USAGE_NAME | VARCHAR2 | (80) | Application Module Usage name | |
ADD_INDEXED_CHILDREN | VARCHAR2 | (1) | Flag to indicate whether the region items of the region would be added as indexed children by OAFramework | |
STATEFUL_FLAG | VARCHAR2 | (1) | Flag which indicates whether a page is stateful or stateless | |
FUNCTION_NAME | VARCHAR2 | (30) | Assign region to a function | |
CHILDREN_VIEW_USAGE_NAME | VARCHAR2 | (80) | binds the children of any container to a view object | |
SEARCH_PANEL | VARCHAR2 | (1) | Applicable for region style Query only: Indicates if the query region has a simple search panel or not. | |
ADVANCED_SEARCH_PANEL | VARCHAR2 | (1) | Applicable for region style Query only: Indicates if the query region has an advanced search panel or not. | |
CUSTOMIZE_PANEL | VARCHAR2 | (1) | Applicable for region style Query only: Indicates if the query region has a customize panel or not. | |
DEFAULT_SEARCH_PANEL | VARCHAR2 | (30) | Applicable for region style Query only: Indicates which panel should be used as default when rendering the query region. Possible choices are: Search Panel, Advanced Search Panel, Customize Panel. | |
RESULTS_BASED_SEARCH | VARCHAR2 | (1) | Applicable for region style Query only; Indicates that the query bean needs to build the search panels based on the results region's queryable attributes. | |
DISPLAY_GRAPH_TABLE | VARCHAR2 | (1) | graph table is displayed when this column = Y, only possible when region_style = 'GRAPH_DATA' | |
PREF_REGION_APPLICATION_ID | NUMBER | (15) | Region Application Id for pointing to Preference region. This is valid only when region style = 'PAGE LAYOUT' | |
PREF_REGION_CODE | VARCHAR2 | (30) | Region Code for pointing to Preference region. This is valid only when region style = 'PAGE LAYOUT'. | |
DISABLE_HEADER | VARCHAR2 | (1) | This allows developers to remove the header title for Default Single/Double Column Layout | |
STANDALONE | VARCHAR2 | (1) | Y | This column indicates whether a region can be rendered standalone or not. |
AUTO_CUSTOMIZATION_CRITERIA | VARCHAR2 | (1) | Associated for regions of style QUERY. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_REGIONS does not reference any database object
AK.AK_REGIONS is referenced by following:
Description: | Translations for AK_REGIONS |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_REGIONS_TL.REGION_CODE
AK_REGIONS_TL.REGION_APPLICATION_ID |
AK_REGIONS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_REGIONS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID LANGUAGE ZD_EDITION_NAME |
AK_REGIONS_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGION_CODE | VARCHAR2 | (30) | Y | Region identifier |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Product team's application id which the region belong to |
LANGUAGE | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
NAME | VARCHAR2 | (80) | Y | Friendly user name of region |
DESCRIPTION | VARCHAR2 | (2000) | Description of region | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language code of the language which the values of the translatable columns were originally entered |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_REGIONS_TL does not reference any database object
AK.AK_REGIONS_TL is referenced by following:
Description: | Links an item to a region |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_REGION_ITEMS.REGION_CODE
AK_REGION_ITEMS.REGION_APPLICATION_ID |
AK_REGIONS |
AK_REGION_ITEMS.ATTRIBUTE_CODE
AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
AK_REGION_ITEMS.MENU_NAME | FND_MENUS |
Foreign Key Column | Foreign Table |
---|---|
AK_CATEGORY_USAGES.REGION_CODE
AK_CATEGORY_USAGES.REGION_APPLICATION_ID AK_CATEGORY_USAGES.ATTRIBUTE_CODE AK_CATEGORY_USAGES.ATTRIBUTE_APPLICATION_ID |
AK_REGION_ITEMS |
AK_FLOW_PAGE_REGION_ITEMS.REGION_CODE
AK_FLOW_PAGE_REGION_ITEMS.REGION_APPLICATION_ID AK_FLOW_PAGE_REGION_ITEMS.ATTRIBUTE_CODE AK_FLOW_PAGE_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID |
AK_REGION_ITEMS |
AK_REGION_ITEMS_TL.REGION_CODE
AK_REGION_ITEMS_TL.REGION_APPLICATION_ID AK_REGION_ITEMS_TL.ATTRIBUTE_CODE AK_REGION_ITEMS_TL.ATTRIBUTE_APPLICATION_ID |
AK_REGION_ITEMS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_REGION_ITEMS_U1 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
AK_REGION_ITEMS_U2 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID DISPLAY_SEQUENCE ZD_EDITION_NAME |
AK_REGION_ITEMS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
REGION_APPLICATION_ID
REGION_CODE |
AK_REGION_ITEMS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
VIEW_USAGE_NAME
VIEW_ATTRIBUTE_NAME |
AK_REGION_ITEMS_N4 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID |
AK_REGION_ITEMS_N5 | NONUNIQUE | APPS_TS_TX_IDX | LOV_FOREIGN_KEY_NAME |
AK_REGION_ITEMS_N6 | NONUNIQUE | APPS_TS_TX_IDX |
LOV_REGION_CODE
LOV_REGION_APPLICATION_ID |
AK_REGION_ITEMS_N7 | NONUNIQUE | APPS_TS_TX_IDX |
NESTED_REGION_CODE
NESTED_REGION_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGION_CODE | VARCHAR2 | (30) | Y | Region identifier |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Product team's application id which the region belong to |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the attribute belong to |
DISPLAY_SEQUENCE | NUMBER | (15) | Y | Sequence number for displaying region items. Each sequence number should be unique within the same region |
NODE_DISPLAY_FLAG | VARCHAR2 | (1) | Y | Node display flag ('Y' - Display this region item in a node, 'N' - Do not display this region item in a node) |
NODE_QUERY_FLAG | VARCHAR2 | (1) | Y | This flag indicates whether the value of this region item can be queried (NODE_QUERY_FLAG = 'Y') or not (NODE_QUERY_FLAG='N') |
ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | Y | Prompt/label length for this item |
BOLD | VARCHAR2 | (1) | Y | Bold flag ('Y' - Bold the region item, 'N' - Do not bold the region item) |
ITALIC | VARCHAR2 | (1) | Y | Italic flag ('Y' - Italicize the region item, 'N' - Do not italicize the region item) |
VERTICAL_ALIGNMENT | VARCHAR2 | (30) | Y | Vertical Alignment for the region item |
HORIZONTAL_ALIGNMENT | VARCHAR2 | (30) | Y | Horizontal alignment for the region item |
ITEM_STYLE | VARCHAR2 | (30) | Y | Style of region item |
OBJECT_ATTRIBUTE_FLAG | VARCHAR2 | (1) | Y | Flag indicates if this item is an attribute (OBJECT_ATTRIBUTE_FLAG = 'N') or an object attribute (OBJECT_ATTRIBUTE_FLAG = 'Y') |
UPDATE_FLAG | VARCHAR2 | (1) | Y | Flag indicates whether this attribute is updatable (UPDATE_FLAG = 'Y') or not (UPDATE_FLAG = 'N') |
REQUIRED_FLAG | VARCHAR2 | (1) | Y | Flag indicates whether this attribute is input required for the region (REQUIRED_FLAG = 'Y') or not (REQUIRED_FLAG = 'N') |
DISPLAY_VALUE_LENGTH | NUMBER | (15) | Y | Length of region item to be displayed |
SECURITY_CODE | VARCHAR2 | (30) | Security Code | |
LOV_REGION_CODE | VARCHAR2 | (30) | LOV region identifier | |
LOV_REGION_APPLICATION_ID | NUMBER | (15) | Product team's application id which the LOV region belong to | |
LOV_FOREIGN_KEY_NAME | VARCHAR2 | (30) | Lov foreign key relationship identifier | |
LOV_ATTRIBUTE_CODE | VARCHAR2 | (30) | LOV attribute identifier | |
LOV_ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Product team's application id which the lov attribute belong to | |
LOV_DEFAULT_FLAG | VARCHAR2 | (1) | LOV default flag | |
REGION_DEFAULTING_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains the stored procedure to populate default values into this region item | |
REGION_DEFAULTING_API_PROC | VARCHAR2 | (30) | Procedure name in PL/SQL package which populates default values into this region item | |
REGION_VALIDATION_API_PKG | VARCHAR2 | (30) | PL/SQL package name which contains the procedure to validate the region item's value | |
REGION_VALIDATION_API_PROC | VARCHAR2 | (30) | Procedure name in PL/SQL package which contains the procedure to validate the region item's value | |
ORDER_SEQUENCE | NUMBER | (15) | Order Sequence | |
ORDER_DIRECTION | VARCHAR2 | (30) | Direction of sorting values of region items | |
DEFAULT_VALUE_VARCHAR2 | VARCHAR2 | (240) | Default value of region item when the data type of the region item is VARCHAR | |
DEFAULT_VALUE_NUMBER | NUMBER | (15) | Default value of region item when the data type of the region item is NUMBER | |
DEFAULT_VALUE_DATE | DATE | Default value of region item when the data type of the region item is DATE | ||
ICX_CUSTOM_CALL | VARCHAR2 | (80) | A URL to launch an html file | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
DISPLAY_HEIGHT | NUMBER | If this item is a text area then this property defines the vertical number of lines for that text. | ||
SUBMIT | VARCHAR2 | (1) | Y | Obsolete |
ENCRYPT | VARCHAR2 | (1) | Y | Flag that indicates if an item is encrypted or not. |
NESTED_REGION_CODE | VARCHAR2 | (30) | Code of the region to be referenced from this item. | |
NESTED_REGION_APPLICATION_ID | NUMBER | Application of the region to be referenced from this item. | ||
VIEW_USAGE_NAME | VARCHAR2 | (80) | View object data source name for the data item to be displayed/updated/created. | |
VIEW_ATTRIBUTE_NAME | VARCHAR2 | (80) | View object attribute name data source for the data item to be displayed/updated/created. | |
CSS_CLASS_NAME | VARCHAR2 | (80) | The cascading style sheet class name to be applied to the value of a data item that will be displayed on the page. | |
POPLIST_VIEWOBJECT | VARCHAR2 | (240) | If this attribute is of item style poplist then this property defines the view object source for the list of possible values for the poplist. | |
IMAGE_FILE_NAME | VARCHAR2 | (80) | The name of the image that will be displayed on the page. | |
URL | VARCHAR2 | (2000) | The URL properly applies to many item styles within a region. It can be defined for button, button submit, label, text and image. | |
POPLIST_DISPLAY_ATTRIBUTE | VARCHAR2 | (80) | If this attribute is of item style poplist then this property defines the view object attribute source for the list of possible display values for the poplist that the user can choose from. | |
POPLIST_VALUE_ATTRIBUTE | VARCHAR2 | (80) | If this attribute is of item style poplist then this property defines the view object attribute source for the list of possible returned values for the poplist that the user can choose from. | |
ITEM_NAME | VARCHAR2 | (30) | Single reference name for the usage of an attribute with the region. | |
CSS_LABEL_CLASS_NAME | VARCHAR2 | (80) | The cascading style sheet class name that will be applied to the label of a data item or the static text that will be displayied on the page. | |
MENU_ID | NUMBER | Id of the menu to use for Global Menu and Application menu item style to represent the menu hierarchy that will be used to create the tab bar, submenu and bin. | ||
MENU_NAME | VARCHAR2 | (30) | menu_name references menu_name in FND_MENUS table | |
FLEXFIELD_NAME | VARCHAR2 | (40) | FND Flexfield name | |
FLEXFIELD_APPLICATION_ID | NUMBER | Application ID of Flexfield | ||
TABULAR_FUNCTION_CODE | VARCHAR2 | (30) | Function code to put in this region item if this region item is used as a function | |
TIP_TYPE | VARCHAR2 | (30) | Type of tip message of region item if the region item has a tip | |
TIP_MESSAGE_NAME | VARCHAR2 | (30) | message_name of tip message in FND_NEW_MESSAGES table | |
TIP_MESSAGE_APPLICATION_ID | NUMBER | application ID of tip message name | ||
FLEX_SEGMENT_LIST | VARCHAR2 | (4000) | column for attaching flex fields to a region item | |
ENTITY_ID | VARCHAR2 | (30) | ENTITY_ID references DATA_OBJECT_CODE column in FND_DOCUMENT_ENTITIES | |
TARGET | VARCHAR2 | (1) | this is an old column of ANCHOR, keeping this here for backward compatibility | |
ANCHOR | VARCHAR2 | (1) | For defining same page hyperlink | |
POPLIST_VIEW_USAGE_NAME | VARCHAR2 | (80) | Picklist View Usage Name | |
SORTBY_VIEW_ATTRIBUTE_NAME | VARCHAR2 | (80) | Indicates which view attribute that the table region is sorted by | |
USER_CUSTOMIZABLE | VARCHAR2 | (1) | Flag to indicate if this can be customized by user | |
ADMIN_CUSTOMIZABLE | VARCHAR2 | (1) | Y | especially useful in the defualt rendered regions where we don't want every cell format and row layout to be customizable by an administrator |
INVOKE_FUNCTION_NAME | VARCHAR2 | (30) | This is for constructing generic URL to launch functions from OA Framework. | |
EXPANSION | NUMBER | (15) | % of expansion that's allowed for translation. | |
ALS_MAX_LENGTH | NUMBER | (15) | Maximum length of ATTRIBUTE_LABEL_SHORT column that's allowed for translation. | |
INITIAL_SORT_SEQUENCE | VARCHAR2 | (30) | stores the startup sort sequence of a table. | |
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Customization application id of the extended item (added by customization) | |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Customization code of the extended item (added by customization) | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_REGION_ITEMS does not reference any database object
AK.AK_REGION_ITEMS is referenced by following:
Description: | Translations for AK_REGION_ITEMS |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_REGION_ITEMS_TL.REGION_CODE
AK_REGION_ITEMS_TL.REGION_APPLICATION_ID AK_REGION_ITEMS_TL.ATTRIBUTE_CODE AK_REGION_ITEMS_TL.ATTRIBUTE_APPLICATION_ID |
AK_REGION_ITEMS |
AK_REGION_ITEMS_TL stores translated information about the region
items in AK_REGION_ITEMS. Each row includes the language the row is
translated to, the translated attributes of the region item, the
region identifier which uniquely identifies the region item and the
region items label. You need one row for each region item 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.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_REGION_ITEMS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID LANGUAGE ZD_EDITION_NAME |
AK_REGION_ITEMS_TL_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGION_CODE | VARCHAR2 | (30) | Y | Region identifier |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Product team's application id which the region belong to |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the attribute belong to |
LANGUAGE | VARCHAR2 | (4) | Y | The language code of the language which the translatable fields are translated to |
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | Label/Prompt for this region item | |
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (30) | A short label/prompt for this region item (this column is obsolete, do not use) | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language code of the language which the values of the translatable columns were originally entered |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
DESCRIPTION | VARCHAR2 | (2000) | Description | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_REGION_ITEMS_TL does not reference any database object
AK.AK_REGION_ITEMS_TL is referenced by following:
Description: | Defines relationships between LOV regions and regions |
---|
AK_REGION_LOV_RELATIONS contains the data that defines relationships between LOV regions and regions.
Index | Type | Tablespace | Column |
---|---|---|---|
SYS_C00252039 | UNIQUE | APPS_TS_TX_IDX |
REGION_APPLICATION_ID
REGION_CODE ATTRIBUTE_APPLICATION_ID ATTRIBUTE_CODE LOV_REGION_APPL_ID LOV_REGION_CODE LOV_ATTRIBUTE_APPL_ID LOV_ATTRIBUTE_CODE BASE_REGION_APPL_ID BASE_REGION_CODE BASE_ATTRIBUTE_APPL_ID BASE_ATTRIBUTE_CODE DIRECTION_FLAG ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGION_APPLICATION_ID | NUMBER | Y | Region Application Id of the region item which launches the LOV | |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code of the region item which launches the LOV |
ATTRIBUTE_APPLICATION_ID | NUMBER | Y | Attribute application id of the region item which launches this LOV | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute Code of the region item which launches the LOV |
LOV_REGION_APPL_ID | NUMBER | Y | Region Application ID of LOV Region | |
LOV_REGION_CODE | VARCHAR2 | (30) | Y | Region code of LOV Region |
LOV_ATTRIBUTE_APPL_ID | NUMBER | Y | Attribute Application Id of LOV Region Item | |
LOV_ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute code of LOV Region Item |
BASE_REGION_APPL_ID | NUMBER | Y | Product team's application ID which the Base Region belongs to | |
BASE_REGION_CODE | VARCHAR2 | (30) | Y | Base Region Identifier |
BASE_ATTRIBUTE_APPL_ID | NUMBER | Y | ID of the application of the base attribute. | |
BASE_ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Code that identifies the base attribute. |
DIRECTION_FLAG | VARCHAR2 | (30) | Y | indicates this attribute value is a result returning to the caller or it's a criteria adding to another LOV |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Y | Standard Who Column | |
REQUIRED_FLAG | VARCHAR2 | (1) | Y | valid values of this column are 'Y' and 'N' |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_REGION_LOV_RELATIONS does not reference any database object
AK.AK_REGION_LOV_RELATIONS is referenced by following:
Description: | Specifies attributes that can be accessed based on a users responsibility id |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_RESP_SECURITY_ATTRIBUTES.ATTRIBUTE_APPLICATION_ID
AK_RESP_SECURITY_ATTRIBUTES.RESPONSIBILITY_ID |
FND_RESPONSIBILITY |
AK_RESP_SECURITY_ATTRIBUTES.ATTRIBUTE_CODE
AK_RESP_SECURITY_ATTRIBUTES.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
AK_RESP_SECURITY_ATTRIBUTES contains attributes that are displayed or
hidden from a user based on the user's responsibility ID. You need one
row for each attribute/responsibility ID combination.
AK_QUERY_PKG uses this table in conjunction with the
AK_WEB_USER_SEC_ATTR_VALUES table (please see this description for
more details). Together, both tables defines what attributes a user
may or may not see.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_RESP_SECURITY_ATTRIBUTES_U1 | UNIQUE | APPS_TS_TX_IDX |
RESPONSIBILITY_ID
RESP_APPLICATION_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
AK_RESP_SECURITY_ATTRIBUTES_N1 | NONUNIQUE | APPS_TS_TX_IDX | RESP_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESPONSIBILITY_ID | NUMBER | (15) | Y | Responsibility ID of application user |
RESP_APPLICATION_ID | NUMBER | Y | Product team's application ID which the responsibility ID belong to | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Identifier of attribute which the user with the responsibility ID can access |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application ID which the attribute belongs to |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_RESP_SECURITY_ATTRIBUTES does not reference any database object
AK.AK_RESP_SECURITY_ATTRIBUTES is referenced by following:
Description: | Stores resp level securing attributes' values. |
---|
This table is used for storing values for securing attributes at the responsibility level.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_RESP_SECURITY_ATTR_VALUES_U | UNIQUE | APPS_TS_TX_IDX |
RESPONSIBILITY_ID
RESP_APPLICATION_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID VARCHAR2_VALUE DATE_VALUE NUMBER_VALUE |
AK_RESP_SECURITY_ATTR_VALUES_N | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID RESPONSIBILITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESPONSIBILITY_ID | NUMBER | (15) | Y | FND Responsibility ID |
RESP_APPLICATION_ID | NUMBER | (15) | Y | FND Application ID to which the responsibility belongs. |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | AK Attribute Code |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | FND Application ID to which the attribute belongs. |
VARCHAR2_VALUE | VARCHAR2 | (240) | Securing attribute varchar2 value for the current attribute and responsibility. | |
DATE_VALUE | DATE | Securing attribute date value for the current attribute and responsibility. | ||
NUMBER_VALUE | NUMBER | (15) | Securing attribute number value for the current attribute and responsibility. |
AK.AK_RESP_SECURITY_ATTR_VALUES does not reference any database object
AK.AK_RESP_SECURITY_ATTR_VALUES is referenced by following:
Description: | Unique keys for an object |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_UNIQUE_KEYS.DATABASE_OBJECT_NAME | AK_OBJECTS |
Foreign Key Column | Foreign Table |
---|---|
AK_FOREIGN_KEYS.UNIQUE_KEY_NAME | AK_UNIQUE_KEYS |
AK_UNIQUE_KEY_COLUMNS.UNIQUE_KEY_NAME | AK_UNIQUE_KEYS |
AK_UNIQUE_KEYS defines the unique keys that belong to an object. You
must create one row for each unique key you wish to associate to an
object. Generally the unique key is the primary key of a view, though
some views may have additional unique keys.
For each unique key, you must specify the database object name,
unique key name and the application owner of the unique key.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_UNIQUE_KEYS_U1 | UNIQUE | APPS_TS_TX_IDX |
UNIQUE_KEY_NAME
ZD_EDITION_NAME |
AK_UNIQUE_KEYS_N1 | NONUNIQUE | APPS_TS_TX_IDX | DATABASE_OBJECT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Y | Unique identifier of unique key relationship |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | Identifier of database object which contains the unique key |
APPLICATION_ID | NUMBER | (15) | Y | Application Id of product team who defined this unique key relationship |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_UNIQUE_KEYS does not reference any database object
AK.AK_UNIQUE_KEYS is referenced by following:
Description: | Links an attribute to a unique key |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_UNIQUE_KEY_COLUMNS.UNIQUE_KEY_NAME | AK_UNIQUE_KEYS |
AK_UNIQUE_KEY_COLUMNS defines the columns (attributes) that belong
to the unique key. You will need one row for each column that makes
up the unique key.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_UNIQUE_KEY_COLUMNS_U1 | UNIQUE | APPS_TS_TX_IDX |
UNIQUE_KEY_NAME
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID ZD_EDITION_NAME |
AK_UNIQUE_KEY_COLUMNS_U2 | UNIQUE | APPS_TS_TX_IDX |
UNIQUE_KEY_NAME
UNIQUE_KEY_SEQUENCE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Y | Unique identifier of unique key relationship |
UNIQUE_KEY_SEQUENCE | NUMBER | (15) | Y | Sequence number of the unique key column |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier of the unique key column |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application Id which the attribute belong to |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AK.AK_UNIQUE_KEY_COLUMNS does not reference any database object
AK.AK_UNIQUE_KEY_COLUMNS is referenced by following:
Description: | Web user security attributes value |
---|
Foreign Key Column | Foreign Table |
---|---|
AK_WEB_USER_SEC_ATTR_VALUES.ATTRIBUTE_CODE
AK_WEB_USER_SEC_ATTR_VALUES.ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES |
AK_WEB_USER_SEC_ATTR_VALUES contains user IDs, attributes and
attributes values that define if an attribute is secure for a specific
user. You need one row for each user/attribute/value that you want to
secure.
AK_QUERY_PKG uses this table in conjunction with the
AK_RESP_SECURITY_ATTRIBUTES table. Together, both tables dictates to
AK_QUERY_PKG what rows should be returned.
Index | Type | Tablespace | Column |
---|---|---|---|
AK_WEB_USER_SEC_ATTR_VALUES_U1 | UNIQUE | APPS_TS_TX_IDX |
WEB_USER_ID
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID VARCHAR2_VALUE DATE_VALUE NUMBER_VALUE |
AK_WEB_USER_SEC_ATTR_VALUES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
WEB_USER_ID
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID |
AK_WEB_USER_SEC_ATTR_VALUES_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID VARCHAR2_VALUE |
AK_WEB_USER_SEC_ATTR_VALUES_N3 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID NUMBER_VALUE |
AK_WEB_USER_SEC_ATTR_VALUES_N4 | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID DATE_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WEB_USER_ID | NUMBER | Y | User ID | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute identifier of the secured attribute |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Product team's application Id which the attribute belong to |
VARCHAR2_VALUE | VARCHAR2 | (240) | Varchar value used to determine if the user can view this secured attribute | |
DATE_VALUE | DATE | Date value used to determine if the user can view this secured attribute | ||
NUMBER_VALUE | NUMBER | Number value used to determine if the user can view this secured attribute | ||
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
AK.AK_WEB_USER_SEC_ATTR_VALUES does not reference any database object
AK.AK_WEB_USER_SEC_ATTR_VALUES is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_ADDRESSES_PK | UNIQUE | APPS_TS_TX_IDX | ADDRESS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDRESS_ID | NUMBER | Y | ||
ADDRESS_NAME | VARCHAR2 | (20) | Y | |
ADDRESS_LINE_1 | VARCHAR2 | (60) | ||
ADDRESS_LINE_2 | VARCHAR2 | (60) | ||
ADDRESS_LINE_3 | VARCHAR2 | (60) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
EMAIL_ADDRESS | VARCHAR2 | (240) | ||
COUNTRY | VARCHAR2 | (2) | ||
TOWN_OR_CITY | VARCHAR2 | (30) | ||
POSTAL_CODE | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
TELEPHONE_NUMBER_1 | VARCHAR2 | (60) | ||
TELEPHONE_NUMBER_2 | VARCHAR2 | (60) | ||
TELEPHONE_NUMBER_3 | VARCHAR2 | (60) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
AK.FWK_TBX_ADDRESSES does not reference any database object
AK.FWK_TBX_ADDRESSES is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_EMPLOYEES_PK | UNIQUE | APPS_TS_TX_IDX | EMPLOYEE_ID |
FWK_TBX_EMPLOYEES_N1 | NONUNIQUE | APPS_TS_TX_IDX | FULL_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMPLOYEE_ID | NUMBER | Y | ||
TITLE | VARCHAR2 | (30) | ||
FIRST_NAME | VARCHAR2 | (20) | ||
MIDDLE_NAMES | VARCHAR2 | (60) | ||
LAST_NAME | VARCHAR2 | (40) | ||
FULL_NAME | VARCHAR2 | (240) | ||
EMAIL_ADDRESS | VARCHAR2 | (240) | ||
MANAGER_ID | NUMBER | |||
POSITION_CODE | VARCHAR2 | (30) | ||
SALARY | NUMBER | |||
START_DATE | DATE | |||
END_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
AK.FWK_TBX_EMPLOYEES does not reference any database object
AK.FWK_TBX_EMPLOYEES is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_ITEMS_PK | UNIQUE | APPS_TS_TX_IDX | ITEM_ID |
FWK_TBX_ITEMS_U2 | UNIQUE | APPS_TS_TX_IDX | SEGMENT1 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | Y | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Y | |
FWKITEM_ID | NUMBER | |||
FWKITEM_STRUCTURE_ID | NUMBER | |||
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
SUMMARY_FLAG | VARCHAR2 | (1) | Y | |
ENABLED_FLAG | VARCHAR2 | (1) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
SEGMENT1 | VARCHAR2 | (60) | ||
SEGMENT2 | VARCHAR2 | (60) | ||
SEGMENT3 | VARCHAR2 | (60) | ||
SEGMENT4 | VARCHAR2 | (60) | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
AK.FWK_TBX_ITEMS does not reference any database object
AK.FWK_TBX_ITEMS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_ITEM_CCIDS_PK | UNIQUE | APPS_TS_TX_IDX | FWKITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FWKITEM_ID | NUMBER | Y | ||
FWKITEM_STRUCTURE_ID | NUMBER | Y | ||
SUMMARY_FLAG | VARCHAR2 | (1) | Y | |
ENABLED_FLAG | VARCHAR2 | (1) | Y | |
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
SEGMENT1 | VARCHAR2 | (60) | ||
SEGMENT2 | VARCHAR2 | (60) | ||
SEGMENT3 | VARCHAR2 | (60) | ||
SEGMENT4 | VARCHAR2 | (60) | ||
SEGMENT5 | VARCHAR2 | (60) | ||
SEGMENT6 | VARCHAR2 | (60) | ||
SEGMENT7 | VARCHAR2 | (60) | ||
SEGMENT8 | VARCHAR2 | (60) | ||
SEGMENT9 | VARCHAR2 | (60) | ||
SEGMENT10 | VARCHAR2 | (60) |
AK.FWK_TBX_ITEM_CCIDS does not reference any database object
AK.FWK_TBX_ITEM_CCIDS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_LOOKUP_CODES_B_U1 | UNIQUE | APPS_TS_TX_IDX |
LOOKUP_TYPE
LOOKUP_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Y | |
LOOKUP_CODE | VARCHAR2 | (30) | Y | |
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
AK.FWK_TBX_LOOKUP_CODES_B does not reference any database object
AK.FWK_TBX_LOOKUP_CODES_B is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_LOOKUP_CODES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
LOOKUP_TYPE
LOOKUP_CODE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Y | |
LOOKUP_CODE | VARCHAR2 | (30) | Y | |
MEANING | VARCHAR2 | (80) | Y | |
LANGUAGE | VARCHAR2 | (4) | Y | |
SOURCE_LANG | VARCHAR2 | (4) | Y | |
DESCRIPTION | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
AK.FWK_TBX_LOOKUP_CODES_TL does not reference any database object
AK.FWK_TBX_LOOKUP_CODES_TL is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_LOOKUP_TYPES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
LOOKUP_TYPE
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Y | |
DISPLAY_NAME | VARCHAR2 | (80) | Y | |
LANGUAGE | VARCHAR2 | (4) | Y | |
SOURCE_LANG | VARCHAR2 | (4) | Y | |
DESCRIPTION | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
AK.FWK_TBX_LOOKUP_TYPES_TL does not reference any database object
AK.FWK_TBX_LOOKUP_TYPES_TL is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_PO_HEADERS_PK | UNIQUE | APPS_TS_TX_IDX | HEADER_ID |
FWK_TBX_PO_HEADERS_N1 | NONUNIQUE | APPS_TS_TX_IDX | BUYER_ID |
FWK_TBX_PO_HEADERS_N2 | NONUNIQUE | APPS_TS_TX_IDX | CREATION_DATE |
FWK_TBX_PO_HEADERS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
SUPPLIER_ID
SUPPLIER_SITE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Y | ||
DESCRIPTION | VARCHAR2 | (240) | ||
STATUS_CODE | VARCHAR2 | (30) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (30) | ||
BUYER_ID | NUMBER | |||
PAYMENT_TERMS_CODE | VARCHAR2 | (30) | ||
CARRIER_CODE | VARCHAR2 | (30) | ||
SHIP_TO_ADDRESS_ID | NUMBER | |||
BILL_TO_ADDRESS_ID | NUMBER | |||
RATE | NUMBER | |||
CONFIRM_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
AK.FWK_TBX_PO_HEADERS does not reference any database object
AK.FWK_TBX_PO_HEADERS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_PO_LINES_PK | UNIQUE | APPS_TS_TX_IDX | LINE_ID |
FWK_TBX_PO_LINES_U2 | UNIQUE | APPS_TS_TX_IDX |
HEADER_ID
LINE_NUMBER |
FWK_TBX_PO_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX | ITEM_DESCRIPTION |
FWK_TBX_PO_LINES_N2 | NONUNIQUE | APPS_TS_TX_IDX | ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | Y | ||
HEADER_ID | NUMBER | Y | ||
LINE_NUMBER | NUMBER | Y | ||
ITEM_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
UNIT_OF_MEASURE | VARCHAR2 | (30) | ||
QUANTITY | NUMBER | |||
UNIT_PRICE | NUMBER | |||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
AK.FWK_TBX_PO_LINES does not reference any database object
AK.FWK_TBX_PO_LINES is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_PO_SHIPMENTS_PK | UNIQUE | APPS_TS_TX_IDX | SHIPMENT_ID |
FWK_TBX_PO_SHIPMENTS_U2 | UNIQUE | APPS_TS_TX_IDX |
LINE_ID
SHIPMENT_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIPMENT_ID | NUMBER | Y | ||
LINE_ID | NUMBER | Y | ||
SHIPMENT_NUMBER | NUMBER | Y | ||
NEED_BY_DATE | DATE | |||
PROMISE_DATE | DATE | |||
RECEIPT_QUANTITY | NUMBER | |||
RECEIPT_DATE | DATE | |||
ORDER_QUANTITY | NUMBER | |||
SHIP_TO_ADDRESS_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
AK.FWK_TBX_PO_SHIPMENTS does not reference any database object
AK.FWK_TBX_PO_SHIPMENTS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_PROJECT_DETAILS_PK | UNIQUE | APPS_TS_TX_IDX | TASK_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | Y | ||
TOP_TASK_ID | NUMBER | Y | ||
TASK_ID | NUMBER | Y | ||
TASK_NUMBER | VARCHAR2 | (30) | ||
TASK_NAME | VARCHAR2 | (240) | ||
START_FROM | DATE | |||
END_TO | DATE | |||
TASK_TYPE | VARCHAR2 | (240) | ||
TEXT_RIGHT | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER |
AK.FWK_TBX_PROJECT_DETAILS does not reference any database object
AK.FWK_TBX_PROJECT_DETAILS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_PROJECT_HEADERS_PK | UNIQUE | APPS_TS_TX_IDX | PROJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | Y | ||
NAME | VARCHAR2 | (240) | ||
START_DATE | DATE | |||
COMPLETION_DATE | DATE | |||
START_FROM | DATE | |||
END_TO | DATE | |||
TASK_TYPE | VARCHAR2 | (240) | ||
TEXT_RIGHT | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER |
AK.FWK_TBX_PROJECT_HEADERS does not reference any database object
AK.FWK_TBX_PROJECT_HEADERS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_SUPPLIERS_PK | UNIQUE | APPS_TS_TX_IDX | SUPPLIER_ID |
FWK_TBX_SUPPLIERS_U2 | UNIQUE | APPS_TS_TX_IDX | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLIER_ID | NUMBER | Y | ||
NAME | VARCHAR2 | (80) | ||
ON_HOLD_FLAG | VARCHAR2 | (1) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
AK.FWK_TBX_SUPPLIERS does not reference any database object
AK.FWK_TBX_SUPPLIERS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
FWK_TBX_SUPPLIER_SITES_PK | UNIQUE | APPS_TS_TX_IDX | SUPPLIER_SITE_ID |
FWK_TBX_SUPPLIER_SITES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SUPPLIER_ID
SITE_NAME |
FWK_TBX_SUPPLIER_SITES_N2 | NONUNIQUE | APPS_TS_TX_IDX | SITE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLIER_ID | NUMBER | Y | ||
SUPPLIER_SITE_ID | NUMBER | Y | ||
SITE_NAME | VARCHAR2 | (20) | ||
PAYMENT_TERMS_CODE | VARCHAR2 | (30) | ||
CARRIER_CODE | VARCHAR2 | (30) | ||
PURCHASING_SITE_FLAG | VARCHAR2 | (1) | ||
ADDRESS_ID | NUMBER | |||
START_DATE | DATE | |||
END_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
AK.FWK_TBX_SUPPLIER_SITES does not reference any database object
AK.FWK_TBX_SUPPLIER_SITES is referenced by following:
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ROW ID | |
APPLICATION_ID | NUMBER | (15) | Y | Application that owns the AM Parameter Registry. |
APPL_SHORT_NAME | VARCHAR2 | (50) | Y | Short name of Application. |
APPLICATION_NAME | VARCHAR2 | (240) | Y | application name. |
APPLICATIONMODULE_DEFN_NAME | VARCHAR2 | (240) | Y | Application Module full definition name. |
PARAM_NAME | VARCHAR2 | (80) | Y | Parameter Name of the parameter that needs to be passed to initializePageValues(). |
PARAM_SOURCE | VARCHAR2 | (30) | Y | Parameter source of the parameter that needs to be passed to initializePageValues(). The possible values for this are request and session. |
APPS.AK_AM_PARAMETER_REGISTRY_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View of AK_ATTRIBUTES table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | |
APPLICATION_NAME | VARCHAR2 | (240) | Y | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
NAME | VARCHAR2 | (80) | Y | Name of the attribute |
DESCRIPTION | VARCHAR2 | (2000) | ||
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | ||
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (40) | ||
ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | ||
ATTRIBUTE_VALUE_LENGTH | NUMBER | (15) | ||
BOLD | VARCHAR2 | (1) | Y | |
ITALIC | VARCHAR2 | (1) | Y | |
HORIZONTAL_ALIGNMENT | VARCHAR2 | (30) | Y | |
VERTICAL_ALIGNMENT | VARCHAR2 | (30) | Y | |
DATA_TYPE | VARCHAR2 | (30) | Y | |
UPPER_CASE_FLAG | VARCHAR2 | (1) | ||
DEFAULT_VALUE_VARCHAR2 | VARCHAR2 | (240) | ||
DEFAULT_VALUE_NUMBER | NUMBER | (15) | ||
DEFAULT_VALUE_DATE | DATE | |||
LOV_REGION_CODE | VARCHAR2 | (30) | ||
LOV_REGION_APPLICATION_ID | NUMBER | (15) | ||
LOV_REGION_NAME | VARCHAR2 | (80) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | |
ITEM_STYLE | VARCHAR2 | (30) | Y | |
DISPLAY_HEIGHT | NUMBER | |||
CSS_CLASS_NAME | VARCHAR2 | (80) | ||
POPLIST_VIEWOBJECT | VARCHAR2 | (240) | ||
POPLIST_DISPLAY_ATTRIBUTE | VARCHAR2 | (80) | ||
POPLIST_VALUE_ATTRIBUTE | VARCHAR2 | (80) | ||
CSS_LABEL_CLASS_NAME | VARCHAR2 | (80) | ||
EXPANSION | NUMBER | (15) | ||
ALS_MAX_LENGTH | NUMBER | (15) | ||
PRECISION | NUMBER | (15) |
APPS.AK_ATTRIBUTES_VL is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGION_CODE | VARCHAR2 | (30) | Y | Region code for a given region. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application id where the region will be used. |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute Code of the given attribute |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the attribute will be used |
ITEM_NAME | VARCHAR2 | (30) | Item name. | |
CATEGORY_ID | NUMBER | Y | Reference to category | |
NAME | VARCHAR2 | (30) | Y | Name of Category |
USER_NAME | VARCHAR2 | (255) | Y | User Name |
APPLICATION_ID | NUMBER | Application id | ||
SHOW_ALL | VARCHAR2 | (1) | Flag indicates whether all attachments of all categories will be shown for this region. |
APPS.AK_CATEGORY_USAGES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application id where the region will be used. |
REGION_CODE | VARCHAR2 | (30) | Y | Region code for a given region. |
CUSTOMIZATION_LEVEL_ID | NUMBER | (15) | Y | Level Id to indicate the level of customization. |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the attribute will be used |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute Code of the given attribute |
ITEM_NAME | VARCHAR2 | (30) | Item name. | |
VIEW_USAGE_NAME | VARCHAR2 | (80) | View Usage name. | |
VIEW_ATTRIBUTE_NAME | VARCHAR2 | (80) | View Attribute Name. | |
SEQUENCE_NUMBER | NUMBER | (15) | Y | Sequence Number of the criteria within a given customization |
OPERATION | VARCHAR2 | (30) | Y | Operation used for the given criteria. Values come in from the lookup ICX_CONDITIONS. |
VALUE_VARCHAR2 | VARCHAR2 | (240) | Value of the criteria if the datatype is varchar2. | |
VALUE_NUMBER | NUMBER | (15) | Value of the criteria if the datatype is number. | |
VALUE_DATE | DATE | Value of the criteria if the datatype is date | ||
CRITERIA_JOIN_CONDITION | VARCHAR2 | (3) | Join condition used, if the customization has a criteria associated with it. Possible values that it can take are "AND" and "OR". | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column. |
CREATION_DATE | DATE | Y | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column. |
START_DATE_ACTIVE | DATE | Y | Standard Who Column. | |
END_DATE_ACTIVE | DATE | Standard Who Column. |
APPS.AK_CRITERIA_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID. | |
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
CUSTOMIZATION_APPL_SHORT_NAME | VARCHAR2 | (50) | Y | Application short name |
CUSTOMIZATION_APPL_NAME | VARCHAR2 | (240) | Y | Name of application |
CUSTOMIZATION_NAME | VARCHAR2 | (80) | Y | Customization Name. |
CUSTOMIZATION_DESCRIPTION | VARCHAR2 | (2000) | Customization Description | |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the region will be used |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code for a given region. |
REGION_APPL_SHORT_NAME | VARCHAR2 | (50) | Y | Application short name |
REGION_APPL_NAME | VARCHAR2 | (240) | Y | Name of application. |
REGION_NAME | VARCHAR2 | (80) | Y | Customization Name. |
REGION_DESCRIPTION | VARCHAR2 | (2000) | Customization Description. | |
VERTICALIZATION_ID | VARCHAR2 | (150) | Verticalization Id. Populated for a verticalization customization. | |
LOCALIZATION_CODE | VARCHAR2 | (150) | Localization Code. Populated for a localization level customization. | |
ORG_ID | NUMBER | (15) | Org Id. Populated for an org level customization. | |
SITE_ID | NUMBER | (15) | Site Id. Populated for a site level customization. | |
RESPONSIBILITY_ID | NUMBER | (15) | Responsibility Id. Populated for a responsibility level customization. | |
WEB_USER_ID | NUMBER | (15) | User Id. Populated for user level customization. | |
REFERENCE_PATH | VARCHAR2 | (100) | Reference path for the specific portlet. This column will be populated with the reference path for portlet customizations. | |
DEFAULT_CUSTOMIZATION_FLAG | VARCHAR2 | (1) | Default Customization. Populated for user level customization. | |
CUSTOMIZATION_LEVEL_ID | NUMBER | (15) | Y | Level Id to indicate the level of customization. |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column. |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column. |
START_DATE_ACTIVE | DATE | Y | Standard Who Column. | |
END_DATE_ACTIVE | DATE | Standard Who Column. | ||
FUNCTION_NAME | VARCHAR2 | (30) | Function Name. Populated for function level customization. | |
DEVELOPER_MODE | VARCHAR2 | (1) | This specifies whether a specific customization is created by a developer or not. |
APPS.AK_CUSTOMIZATIONS_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID. | |
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
CUSTOMIZATION_APPL_SHORT_NAME | VARCHAR2 | (50) | Y | Application short name |
CUSTOMIZATION_APPL_NAME | VARCHAR2 | (240) | Y | Name of application |
CUSTOMIZATION_NAME | VARCHAR2 | (80) | Y | Customization Name. |
CUSTOMIZATION_DESCRIPTION | VARCHAR2 | (2000) | Customization Description. | |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application id where the region will be used. |
REGION_CODE | VARCHAR2 | (30) | Y | Region code for a given region. |
REGION_APPL_SHORT_NAME | VARCHAR2 | (50) | Y | Application short name. |
REGION_APPL_NAME | VARCHAR2 | (240) | Y | Name of application. |
REGION_NAME | VARCHAR2 | (80) | Y | Customization Name. |
REGION_DESCRIPTION | VARCHAR2 | (2000) | Customization Description. | |
PROPERTY_NAME | VARCHAR2 | (30) | Y | Name of the property that can be customized. |
PROPERTY_VARCHAR2_VALUE | VARCHAR2 | (2000) | Transalated value of the property if the datatype is varchar2. | |
PROPERTY_NUMBER_VALUE | NUMBER | value of property if the datatype is number. | ||
CRITERIA_JOIN_CONDITION | VARCHAR2 | (3) | Join condition used, if the customization has a criteria associated with it. Possible values that it can take are "AND" and "OR". | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column. |
CREATION_DATE | DATE | Y | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column. |
APPS.AK_CUSTOM_REGIONS_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View for AK_CUSTOM_REGION_ITEMS table. This table is used for storing the customizations of region item properties for a specific region and customization.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID. | |
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Y | Application Id where customization will be used. |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Y | Customization Code of a given customization. |
REGION_APPLICATION_ID | NUMBER | (15) | Y | Application id where the region will be used. |
REGION_CODE | VARCHAR2 | (30) | Y | Region code for a given region. |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | Application Id where the attribute will be used |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute Code of the given attribute |
ATTRIBUTE_APPL_SHORT_NAME | VARCHAR2 | (50) | Y | Application short name. |
ATTRIBUTE_APPL_NAME | VARCHAR2 | (240) | Y | Name of application. |
ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | Attribute Name. |
ATTRIBUTE_DESCRIPTION | VARCHAR2 | (2000) | Attribute description. | |
ITEM_NAME | VARCHAR2 | (30) | Item Name | |
PROPERTY_NAME | VARCHAR2 | (30) | Y | Name of the property that can be customized. |
PROPERTY_VARCHAR2_VALUE | VARCHAR2 | (4000) | Transalated value of the property if the datatype is varchar2. | |
PROPERTY_NUMBER_VALUE | NUMBER | value of property if the datatype is number. | ||
PROPERTY_DATE_VALUE | DATE | Transalated value of the property if the datatype is date. | ||
CREATED_BY | NUMBER | (15) | Y | Standard Who Column. |
CREATION_DATE | DATE | Y | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column. |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column. |
APPS.AK_CUSTOM_REGION_ITEMS_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FLOW_APPLICATION_ID | NUMBER | (15) | Y | |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | |
APPLICATION_NAME | VARCHAR2 | (240) | Y | |
FLOW_CODE | VARCHAR2 | (30) | Y | |
NAME | VARCHAR2 | (30) | Y | |
DESCRIPTION | VARCHAR2 | (2000) | ||
PRIMARY_PAGE_APPL_ID | NUMBER | (15) | Y | |
PRIMARY_PAGE_CODE | VARCHAR2 | (30) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_FLOWS_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FLOW_APPLICATION_ID | NUMBER | (15) | Y | |
FLOW_CODE | VARCHAR2 | (30) | Y | |
PAGE_APPLICATION_ID | NUMBER | (15) | Y | |
PAGE_CODE | VARCHAR2 | (30) | Y | |
PRIMARY_REGION_APPL_ID | NUMBER | (15) | Y | |
PRIMARY_REGION_CODE | VARCHAR2 | (30) | Y | |
PRIMARY_REGION_NAME | VARCHAR2 | (80) | ||
PRIMARY_REGION_DESCRIPTION | VARCHAR2 | (2000) | ||
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | ||
NAME | VARCHAR2 | (80) | Y | |
DESCRIPTION | VARCHAR2 | (2000) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_FLOW_PAGES_VL is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FLOW_APPLICATION_ID | NUMBER | (15) | Y | |
FLOW_CODE | VARCHAR2 | (30) | Y | |
PAGE_APPLICATION_ID | NUMBER | (15) | Y | |
PAGE_CODE | VARCHAR2 | (30) | Y | |
PAGE_NAME | VARCHAR2 | (80) | Y | |
PAGE_DESCRIPTION | VARCHAR2 | (2000) | ||
REGION_APPLICATION_ID | NUMBER | (15) | Y | |
REGION_CODE | VARCHAR2 | (30) | Y | |
REGION_NAME | VARCHAR2 | (80) | Y | |
REGION_DESCRIPTION | VARCHAR2 | (2000) | ||
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
DISPLAY_SEQUENCE | NUMBER | (15) | ||
REGION_STYLE | VARCHAR2 | (30) | Y | |
NUM_COLUMNS | NUMBER | (15) | ||
ICX_CUSTOM_CALL | VARCHAR2 | (80) | ||
PARENT_REGION_APPLICATION_ID | NUMBER | (15) | ||
PARENT_REGION_CODE | VARCHAR2 | (30) | ||
PARENT_REGION_NAME | VARCHAR2 | (80) | ||
PARENT_REGION_DESCRIPTION | VARCHAR2 | (2000) | ||
PARENT_DATABASE_OBJECT_NAME | VARCHAR2 | (30) | ||
FROM_TO_NAME | VARCHAR2 | (45) | ||
FROM_TO_DESCRIPTION | VARCHAR2 | (1500) | ||
FOREIGN_KEY_NAME | VARCHAR2 | (30) | ||
APPLICATION_ID | NUMBER | (15) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_FLOW_PAGE_REGIONS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FLOW_APPLICATION_ID | NUMBER | (15) | Y | |
FLOW_CODE | VARCHAR2 | (30) | Y | |
PAGE_APPLICATION_ID | NUMBER | (15) | Y | |
PAGE_CODE | VARCHAR2 | (30) | Y | |
PAGE_NAME | VARCHAR2 | (80) | Y | |
PAGE_DESCRIPTION | VARCHAR2 | (2000) | ||
REGION_APPLICATION_ID | NUMBER | (15) | Y | |
REGION_CODE | VARCHAR2 | (30) | Y | |
REGION_NAME | VARCHAR2 | (80) | Y | |
REGION_DESCRIPTION | VARCHAR2 | (2000) | ||
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | |
ATTRIBUTE_DESCRIPTION | VARCHAR2 | (2000) | ||
TO_PAGE_APPL_ID | NUMBER | (15) | ||
TO_PAGE_CODE | VARCHAR2 | (30) | ||
TO_PAGE_NAME | VARCHAR2 | (80) | ||
TO_PAGE_DESCRIPTION | VARCHAR2 | (2000) | ||
TO_URL_ATTRIBUTE_APPL_ID | NUMBER | (15) | ||
TO_URL_ATTRIBUTE_CODE | VARCHAR2 | (30) | ||
TO_ATTRIBUTE_NAME | VARCHAR2 | (80) | ||
TO_ATTRIBUTE_DESCRIPTION | VARCHAR2 | (2000) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_FLOW_PAGE_REGION_ITEMS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FLOW_APPLICATION_ID | NUMBER | (15) | Y | |
FLOW_CODE | VARCHAR2 | (30) | Y | |
FROM_TO_NAME | VARCHAR2 | (45) | ||
FROM_TO_DESCRIPTION | VARCHAR2 | (1500) | ||
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Y | |
FROM_PAGE_APPL_ID | NUMBER | (15) | Y | |
FROM_PAGE_CODE | VARCHAR2 | (30) | Y | |
FROM_PAGE_NAME | VARCHAR2 | (80) | Y | |
TO_PAGE_APPL_ID | NUMBER | (15) | Y | |
TO_PAGE_CODE | VARCHAR2 | (30) | Y | |
TO_PAGE_NAME | VARCHAR2 | (80) | Y | |
FROM_REGION_APPL_ID | NUMBER | (15) | Y | |
FROM_REGION_CODE | VARCHAR2 | (30) | Y | |
FROM_REGION_NAME | VARCHAR2 | (80) | Y | |
FROM_DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
FROM_REGION_STYLE | VARCHAR2 | (30) | Y | |
TO_REGION_APPL_ID | NUMBER | (15) | Y | |
TO_REGION_CODE | VARCHAR2 | (30) | Y | |
TO_REGION_NAME | VARCHAR2 | (80) | ||
TO_DATABASE_OBJECT_NAME | VARCHAR2 | (30) | ||
TO_REGION_STYLE | VARCHAR2 | (30) | ||
APPLICATION_ID | NUMBER | (15) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_FLOW_REGION_RELATIONS_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View of AK_FOREIGN_KEYS table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Y | |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
FROM_TO_NAME | VARCHAR2 | (45) | ||
FROM_TO_DESCRIPTION | VARCHAR2 | (1500) | ||
TO_FROM_NAME | VARCHAR2 | (45) | ||
TO_FROM_DESCRIPTION | VARCHAR2 | (1500) | ||
TO_OBJECT_NAME | VARCHAR2 | (30) | ||
TO_OBJECT_DESCRIPTION | VARCHAR2 | (2000) | ||
TO_DATABASE_OBJECT_NAME | VARCHAR2 | (30) | ||
FROM_OBJECT_NAME | VARCHAR2 | (30) | ||
FROM_OBJECT_DESCRIPTION | VARCHAR2 | (2000) | ||
FROM_DATABASE_OBJECT_NAME | VARCHAR2 | (30) | ||
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Y | |
APPLICATION_ID | NUMBER | (15) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_FOREIGN_KEYS_VL is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Y | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | |
APPLICATION_NAME | VARCHAR2 | (240) | Y | |
PRIMARY_KEY_COLUMN_NAME | VARCHAR2 | (30) | Y | |
FOREIGN_KEY_SEQUENCE | NUMBER | (15) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_FOREIGN_KEY_COLUMNS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Y | |
KEY_SEQUENCE | NUMBER | (15) | Y | |
FOREIGN_APPLICATION_ID | NUMBER | (15) | Y | |
FOREIGN_ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
FOREIGN_COLUMN_NAME | VARCHAR2 | (30) | ||
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Y | |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
UNIQUE_APPLICATION_ID | NUMBER | (15) | Y | |
UNIQUE_ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
UNIQUE_COLUMN_NAME | VARCHAR2 | (30) |
APPS.AK_FOREIGN_KEY_MAPPING_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View of AK_LOOKUP_CODES table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
LOOKUP_CODE | VARCHAR2 | (25) | Y | |
LOOKUP_TYPE | VARCHAR2 | (30) | Y | |
DESCRIPTION | VARCHAR2 | (80) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_LOOKUP_CODES_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View of AK_OBJECTS table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
NAME | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (2000) | ||
APPLICATION_NAME | VARCHAR2 | (240) | Y | |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | |
APPLICATION_ID | NUMBER | (15) | Y | |
PRIMARY_KEY_NAME | VARCHAR2 | (30) | ||
DEFAULTING_API_PKG | VARCHAR2 | (30) | ||
DEFAULTING_API_PROC | VARCHAR2 | (30) | ||
VALIDATION_API_PKG | VARCHAR2 | (30) | ||
VALIDATION_API_PROC | VARCHAR2 | (30) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
MultiLingual view (a language resolved view of the data.)
View of AK_OBJECT_ATTRIBUTES table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
OBJECT_NAME | VARCHAR2 | (30) | ||
OBJECT_DESCRIPTION | VARCHAR2 | (2000) | ||
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | |
APPLICATION_NAME | VARCHAR2 | (240) | Y | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
NAME | VARCHAR2 | (80) | Y | |
DATA_TYPE | VARCHAR2 | (30) | Y | |
LOV_REGION_NAME | VARCHAR2 | (80) | ||
LOV_ATTRIBUTE_NAME | VARCHAR2 | (80) | ||
COLUMN_NAME | VARCHAR2 | (30) | ||
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | ||
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (30) | ||
ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | Y | |
BOLD | VARCHAR2 | (1) | Y | |
ITALIC | VARCHAR2 | (1) | Y | |
HORIZONTAL_ALIGNMENT | VARCHAR2 | (30) | Y | |
VERTICAL_ALIGNMENT | VARCHAR2 | (30) | Y | |
DATA_SOURCE_TYPE | VARCHAR2 | (30) | Y | |
DATA_STORAGE_TYPE | VARCHAR2 | (30) | ||
TABLE_NAME | VARCHAR2 | (30) | ||
BASE_TABLE_COLUMN_NAME | VARCHAR2 | (30) | ||
REQUIRED_FLAG | VARCHAR2 | (1) | Y | |
DISPLAY_VALUE_LENGTH | NUMBER | (15) | Y | |
LOV_REGION_APPLICATION_ID | NUMBER | (15) | ||
LOV_REGION_CODE | VARCHAR2 | (30) | ||
LOV_FOREIGN_KEY_NAME | VARCHAR2 | (30) | ||
LOV_ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | ||
LOV_ATTRIBUTE_CODE | VARCHAR2 | (30) | ||
DEFAULTING_API_PKG | VARCHAR2 | (30) | ||
DEFAULTING_API_PROC | VARCHAR2 | (30) | ||
VALIDATION_API_PKG | VARCHAR2 | (30) | ||
VALIDATION_API_PROC | VARCHAR2 | (30) | ||
DEFAULT_VALUE_VARCHAR2 | VARCHAR2 | (240) | ||
DEFAULT_VALUE_NUMBER | NUMBER | (15) | ||
DEFAULT_VALUE_DATE | DATE | |||
TRANSLATION_FLAG | VARCHAR2 | (1) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
OBJECT_NAME | VARCHAR2 | (30) | ||
OBJECT_DESCRIPTION | VARCHAR2 | (2000) | ||
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | |
VALUE_VARCHAR2 | VARCHAR2 | (240) | ||
VALUE_DATE | DATE | |||
VALUE_NUMBER | NUMBER | (15) | ||
TO_REGION_APPL_ID | NUMBER | (15) | Y | |
TO_REGION_CODE | VARCHAR2 | (30) | Y | |
TO_REGION_NAME | VARCHAR2 | (80) | Y | |
TO_REGION_DESCRIPTION | VARCHAR2 | (2000) | ||
DATA_TYPE | VARCHAR2 | (30) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_OBJECT_ATTRIBUTE_NAVIGATI_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
QUERY_CODE | VARCHAR2 | (30) | Y | Identifier of query object |
APPLICATION_ID | NUMBER | Y | Application ID of query object owner | |
APPLICATION_NAME | VARCHAR2 | (240) | Y | Application Name of query object owner |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
APPS.AK_QUERY_OBJECTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
QUERY_CODE | VARCHAR2 | (30) | Y | Identifier of query object |
SEQ_NUM | NUMBER | Y | Sequence number of query object line | |
QUERY_LINE_TYPE | VARCHAR2 | (30) | Type of the query object line which indicates what kind of sql clause this is. | |
QUERY_LINE | VARCHAR2 | (4000) | content of query object line, which is usually a sql statement | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard Who Column |
APPS.AK_QUERY_OBJECT_LINES_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View of AK_REGIONS table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
REGION_APPLICATION_ID | NUMBER | (15) | Y | |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | |
APPLICATION_NAME | VARCHAR2 | (240) | Y | |
REGION_CODE | VARCHAR2 | (30) | Y | |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
OBJECT_NAME | VARCHAR2 | (30) | ||
OBJECT_DESCRIPTION | VARCHAR2 | (2000) | ||
REGION_STYLE | VARCHAR2 | (30) | Y | |
NUM_COLUMNS | NUMBER | (15) | ||
ICX_CUSTOM_CALL | VARCHAR2 | (80) | ||
NAME | VARCHAR2 | (80) | Y | |
DESCRIPTION | VARCHAR2 | (2000) | ||
REGION_DEFAULTING_API_PKG | VARCHAR2 | (30) | ||
REGION_DEFAULTING_API_PROC | VARCHAR2 | (30) | ||
REGION_VALIDATION_API_PKG | VARCHAR2 | (30) | ||
REGION_VALIDATION_API_PROC | VARCHAR2 | (30) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | |
APPLICATIONMODULE_OBJECT_TYPE | VARCHAR2 | (240) | ||
NUM_ROWS_DISPLAY | NUMBER | |||
REGION_OBJECT_TYPE | VARCHAR2 | (240) | ||
IMAGE_FILE_NAME | VARCHAR2 | (80) | column for putting icon file name when displaying region title | |
ISFORM_FLAG | VARCHAR2 | (1) | Y | column to indicate whether this region is a form |
HELP_TARGET | VARCHAR2 | (240) | ||
STYLE_SHEET_FILENAME | VARCHAR2 | (240) | file name of style sheet which applies to the region | |
VERSION | VARCHAR2 | (30) | ||
APPLICATIONMODULE_USAGE_NAME | VARCHAR2 | (80) | ||
ADD_INDEXED_CHILDREN | VARCHAR2 | (1) | ||
STATEFUL_FLAG | VARCHAR2 | (1) | ||
FUNCTION_NAME | VARCHAR2 | (30) | ||
CHILDREN_VIEW_USAGE_NAME | VARCHAR2 | (80) | bind the children of any container to a view object | |
SEARCH_PANEL | VARCHAR2 | (1) | ||
ADVANCED_SEARCH_PANEL | VARCHAR2 | (1) | ||
CUSTOMIZE_PANEL | VARCHAR2 | (1) | ||
DEFAULT_SEARCH_PANEL | VARCHAR2 | (30) | ||
RESULTS_BASED_SEARCH | VARCHAR2 | (1) | ||
DISPLAY_GRAPH_TABLE | VARCHAR2 | (1) | ||
PREF_REGION_APPLICATION_ID | NUMBER | (15) | Region Application Id for pointing to Preference region. This is valid only when region style = 'PAGE LAYOUT'. | |
PREF_REGION_CODE | VARCHAR2 | (30) | Region Code for pointing to Preference region. This is valid only when region style = 'PAGE LAYOUT'. | |
DISABLE_HEADER | VARCHAR2 | (1) | This allows developers to remove the header title for Default Single/Double Column Layout | |
STANDALONE | VARCHAR2 | (1) | Y | This column indicates whether a region can be rendered standalone or not. |
AUTO_CUSTOMIZATION_CRITERIA | VARCHAR2 | (1) | Associated for regions of style QUERY. |
MultiLingual view (a language resolved view of the data.)
View of AK_REGION_ITEMS table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
REGION_APPLICATION_ID | NUMBER | (15) | Y | |
REGION_CODE | VARCHAR2 | (30) | Y | |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | |
ATTRIBUTE_APPLICATION_NAME | VARCHAR2 | (240) | Y | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | |
ATTRIBUTE_DESCRIPTION | VARCHAR2 | (2000) | ||
DISPLAY_SEQUENCE | NUMBER | (15) | Y | |
NODE_DISPLAY_FLAG | VARCHAR2 | (1) | Y | |
NODE_QUERY_FLAG | VARCHAR2 | (1) | Y | |
ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | Y | |
BOLD | VARCHAR2 | (1) | Y | |
ITALIC | VARCHAR2 | (1) | Y | |
VERTICAL_ALIGNMENT | VARCHAR2 | (30) | Y | |
HORIZONTAL_ALIGNMENT | VARCHAR2 | (30) | Y | |
ITEM_STYLE | VARCHAR2 | (30) | Y | |
UPDATE_FLAG | VARCHAR2 | (1) | Y | |
REQUIRED_FLAG | VARCHAR2 | (1) | Y | |
DISPLAY_VALUE_LENGTH | NUMBER | (15) | Y | |
SECURITY_CODE | VARCHAR2 | (30) | ||
LOV_PRESENCE_FLAG | VARCHAR2 | (1) | ||
LOV_REGION_APPLICATION_ID | NUMBER | (15) | ||
LOV_REGION_CODE | VARCHAR2 | (30) | ||
LOV_FOREIGN_KEY_NAME | VARCHAR2 | (30) | ||
LOV_ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | ||
LOV_ATTRIBUTE_CODE | VARCHAR2 | (30) | ||
LOV_DEFAULT_FLAG | VARCHAR2 | (1) | ||
REGION_DEFAULTING_API_PKG | VARCHAR2 | (30) | ||
REGION_DEFAULTING_API_PROC | VARCHAR2 | (30) | ||
REGION_VALIDATION_API_PKG | VARCHAR2 | (30) | ||
REGION_VALIDATION_API_PROC | VARCHAR2 | (30) | ||
ORDER_SEQUENCE | NUMBER | (15) | ||
ORDER_DIRECTION | VARCHAR2 | (30) | ||
LOV_REGION_NAME | VARCHAR2 | (80) | ||
LOV_ATTRIBUTE_NAME | VARCHAR2 | (80) | ||
DEFAULT_VALUE_VARCHAR2 | VARCHAR2 | (240) | ||
DEFAULT_VALUE_DATE | DATE | |||
DEFAULT_VALUE_NUMBER | NUMBER | (15) | ||
ICX_CUSTOM_CALL | VARCHAR2 | (80) | A URL to launch an html file | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | |
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | ||
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (30) | ||
OBJECT_ATTRIBUTE_FLAG | VARCHAR2 | (1) | Y | |
DATA_TYPE | VARCHAR2 | (30) | Y | |
DISPLAY_HEIGHT | NUMBER | |||
SUBMIT | VARCHAR2 | (1) | Y | |
ENCRYPT | VARCHAR2 | (1) | Y | |
NESTED_REGION_CODE | VARCHAR2 | (30) | ||
NESTED_REGION_APPLICATION_ID | NUMBER | |||
VIEW_USAGE_NAME | VARCHAR2 | (80) | ||
VIEW_ATTRIBUTE_NAME | VARCHAR2 | (80) | ||
CSS_CLASS_NAME | VARCHAR2 | (80) | ||
POPLIST_VIEWOBJECT | VARCHAR2 | (240) | ||
IMAGE_FILE_NAME | VARCHAR2 | (80) | ||
URL | VARCHAR2 | (2000) | ||
POPLIST_DISPLAY_ATTRIBUTE | VARCHAR2 | (80) | ||
POPLIST_VALUE_ATTRIBUTE | VARCHAR2 | (80) | ||
NESTED_REGION_NAME | VARCHAR2 | (80) | ||
ATTRIBUTE_VALUE_LENGTH | NUMBER | (15) | ||
DESCRIPTION | VARCHAR2 | (2000) | ||
ITEM_NAME | VARCHAR2 | (30) | ||
CSS_LABEL_CLASS_NAME | VARCHAR2 | (80) | ||
MENU_NAME | VARCHAR2 | (30) | ||
MENU_ID | NUMBER | |||
FLEXFIELD_NAME | VARCHAR2 | (40) | FND Flexfield name | |
FLEXFIELD_APPLICATION_ID | NUMBER | Flexfield Application Id | ||
FLEXFIELD_APPL_SHORT_NAME | VARCHAR2 | (50) | Application Short Name of Flexfield name | |
TABULAR_FUNCTION_CODE | VARCHAR2 | (30) | Function code for region item if region item is a function | |
TIP_TYPE | VARCHAR2 | (30) | Type of tip message of region item if the region item has a tip | |
TIP_MESSAGE_NAME | VARCHAR2 | (30) | message_name of tip message in FND_NEW_MESSAGES table | |
TIP_MESSAGE_APPLICATION_ID | NUMBER | application ID of tip message name | ||
TIP_MESSAGE_APPL_SHORT_NAME | VARCHAR2 | (50) | Application short name of tip message | |
FLEX_SEGMENT_LIST | VARCHAR2 | (4000) | ||
ENTITY_ID | VARCHAR2 | (30) | ||
ANCHOR | VARCHAR2 | (1) | ||
POPLIST_VIEW_USAGE_NAME | VARCHAR2 | (80) | ||
TARGET | VARCHAR2 | (1) | ||
SORTBY_VIEW_ATTRIBUTE_NAME | VARCHAR2 | (80) | ||
USER_CUSTOMIZABLE | VARCHAR2 | (1) | ||
ADMIN_CUSTOMIZABLE | VARCHAR2 | (1) | Y | especially useful in the defualt rendered regions where we don't want every cell format and row layout to be customizable by an administrator |
INVOKE_FUNCTION_NAME | VARCHAR2 | (30) | This is for constructing generic URL to launch functions from OA Framework. | |
EXPANSION | NUMBER | (15) | % of expansion that's allowed for translation. | |
ALS_MAX_LENGTH | NUMBER | (15) | Maximum length of ATTRIBUTE_LABEL_SHORT column that's allowed for translation. | |
INITIAL_SORT_SEQUENCE | VARCHAR2 | (30) | stores the startup sort sequence of a table. | |
CUSTOMIZATION_APPLICATION_ID | NUMBER | (15) | Customization application id of the extended item (added by customization) | |
CUSTOMIZATION_CODE | VARCHAR2 | (30) | Customization code of the extended item (added by customization) |
MultiLingual view (a language resolved view of the data.)
View of AK_REGION_LOV_RELATIONS table. AK_REGION_LOV_RELATIONS contains the data that defines relationships between LOV regions and regions.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
REGION_APPLICATION_ID | NUMBER | Y | Region Application Id of the region item which launches the LOV | |
REGION_APPLICATION_NAME | VARCHAR2 | (240) | Y | Region Application Name of the region item which launches the LOV |
REGION_CODE | VARCHAR2 | (30) | Y | Region Code of the region item which launches the LOV |
REGION_NAME | VARCHAR2 | (80) | Y | Region Name of the region item which launches the LOV |
ATTRIBUTE_APPLICATION_ID | NUMBER | Y | Attribute application id of the region item which launches this LOV | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute Code of the region item which launches the LOV |
ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | Attribute Name of the region item which launches the LOV |
ITEM_NAME | VARCHAR2 | (30) | Item Name | |
LOV_REGION_APPL_ID | NUMBER | Y | Region Application ID of LOV Region | |
LOV_REGION_APPL_NAME | VARCHAR2 | (240) | Y | Region Application Name of LOV Region |
LOV_REGION_CODE | VARCHAR2 | (30) | Y | Region code of LOV Region |
LOV_REGION_NAME | VARCHAR2 | (80) | Y | Region Name of LOV region |
LOV_ATTRIBUTE_APPL_ID | NUMBER | Y | Attribute Application Id of LOV Region Item | |
LOV_ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Attribute code of LOV Region Item |
LOV_ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | Attribute name of LOV Region Item |
LOV_ITEM_NAME | VARCHAR2 | (30) | Item name for LOV region | |
BASE_REGION_APPL_ID | NUMBER | Y | Region application id of the region which the LOV criteria is retreiving from or the LOV result is returning to. | |
BASE_REGION_CODE | VARCHAR2 | (30) | Y | Region code of the region which the LOV criteria is retreiving from or the LOV result is returning to. |
BASE_REGION_NAME | VARCHAR2 | (80) | Y | Region name of the region which the LOV criteria is retreiving from or the LOV result is returning to |
BASE_ATTRIBUTE_APPL_ID | NUMBER | Y | ID of the application of the base attribute. | |
BASE_ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | Code that identifies the base attribute. |
BASE_ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | Name that identifies the base attribute. |
BASE_ITEM_NAME | VARCHAR2 | (30) | Base Item Name | |
DIRECTION_FLAG | VARCHAR2 | (30) | Y | indicates this attribute value is a result returning to the caller or it's a criteria adding to another LOV |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Y | Standard Who Column | |
REQUIRED_FLAG | VARCHAR2 | (1) | Y | valid values of this column are 'Y' and 'N' |
APPS.AK_REGION_LOV_RELATIONS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Y | |
NAME | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (2000) | ||
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Y | |
APPLICATION_ID | NUMBER | (15) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_UNIQUE_KEYS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Y | |
UNIQUE_KEY_SEQUENCE | NUMBER | (15) | Y | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Y | |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Y | |
APPLICATION_NAME | VARCHAR2 | (240) | Y | |
ATTRIBUTE_NAME | VARCHAR2 | (80) | Y | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y |
APPS.AK_UNIQUE_KEY_COLUMNS_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |