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: | API definitions |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_APIS_U1 | UNIQUE | APPS_TS_SEED |
API_CODE
ZD_EDITION_NAME |
SYS_IL0000192692C00021$$ | UNIQUE | APPS_TS_SEED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
API_NAME | VARCHAR2 | (255) | Internal name of api | |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | The application that this api belongs to | |
SEQ | NUMBER | (15) | ||
DISPLAY_NAME | VARCHAR2 | (240) | Display name | |
DESCRIPTION | VARCHAR2 | (2000) | ||
COMMIT_IF_WARNING | VARCHAR2 | (1) | ||
TYPE_CODE | VARCHAR2 | (40) | ||
METHOD_NAME | VARCHAR2 | (240) | Method name of the api | |
PATH | VARCHAR2 | (240) | Path of the api | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
API_CODE | VARCHAR2 | (45) | Y | Internal code of api |
SEQ_NUM | NUMBER | (15) | The sequence no. for this api, used internally by loader | |
API_DESC | VARCHAR2 | (1800) | Description | |
COMMIT_IF_WARNING_FLAG | VARCHAR2 | (1) | Flag to indicate whether to commit in case of api warnings | |
API_TYPE | VARCHAR2 | (20) | Type of the api | |
REPORT_LAYOUT | VARCHAR2 | (30) | Report Layout | |
FILTERING_PARAMETERS | CLOB | (4000) | Filtering Parameters | |
DATA_SOURCE_NAME | VARCHAR2 | (240) | Data Source Name | |
UPDATABLE_FLAG | VARCHAR2 | (1) | API supports Update | |
CHANGE_UPDATABLE_FLAG | VARCHAR2 | (1) | User can control updates | |
ALLOW_SET_TARGETVAL_FLAG | VARCHAR2 | (1) | API supports Transformation | |
ALLOW_FILTER_FLAG | VARCHAR2 | (1) | API supports Filters | |
API_STANDALONE_FLAG | VARCHAR2 | (1) | API Standalone Flag | |
ACTIVE | VARCHAR2 | (1) | Active | |
DISABLE_REPORT_FLAG | VARCHAR2 | (1) | ||
DEP_REPORT_FLAG | VARCHAR2 | (1) | To Enable or Disable Deployment report | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_APIS does not reference any database object
AZ.AZ_APIS is referenced by following:
Description: | API attribute definitions |
---|
This table stores api attribute definitions for iSetups.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_API_ATTRIBUTES_U1 | UNIQUE | APPS_TS_SEED |
API_CODE
ATTRIBUTE_TAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
API_CODE | VARCHAR2 | (45) | Y | Internal name of api |
ATTRIBUTE_TAG | VARCHAR2 | (255) | Y | Attribute Tag |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
AZ.AZ_API_ATTRIBUTES does not reference any database object
AZ.AZ_API_ATTRIBUTES is referenced by following:
Description: | API dependencies |
---|
This table stores dependencies between apis.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_API_DEPENDENCIES_U1 | UNIQUE | APPS_TS_SEED |
DEPENDANT_API_CODE
REQUIRED_API_CODE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
API_NAME1 | VARCHAR2 | (255) | ||
API_NAME2 | VARCHAR2 | (255) | ||
TYPE | VARCHAR2 | (40) | ||
DESCRIPTION | VARCHAR2 | (2000) | ||
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard date column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
DEPENDANT_API_CODE | VARCHAR2 | (45) | Y | Internal name of depending api |
REQUIRED_API_CODE | VARCHAR2 | (45) | Y | Internal name of depended api |
RELATION_DESC | VARCHAR2 | (1800) | Type of dependency | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_API_DEPENDENCIES does not reference any database object
AZ.AZ_API_DEPENDENCIES is referenced by following:
Description: | API Dependency Attributes |
---|
This table stores API Dependency Attributes.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_API_DEP_ATTRIBUTES_U1 | UNIQUE | APPS_TS_SEED |
DEPENDANT_API_CODE
REQUIRED_API_CODE DEPENDANT_API_ATTRIBUTE REQUIRED_API_ATTRIBUTE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEPENDANT_API_CODE | VARCHAR2 | (45) | Y | API Dependency Attributes |
REQUIRED_API_CODE | VARCHAR2 | (45) | Y | Required API Code |
DEPENDANT_API_ATTRIBUTE | VARCHAR2 | (45) | Y | Dependant API Attribute |
REQUIRED_API_ATTRIBUTE | VARCHAR2 | (45) | Y | Required API Attribute |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_API_DEPENDENCY_ATTRIBUTES does not reference any database object
AZ.AZ_API_DEPENDENCY_ATTRIBUTES is referenced by following:
Description: | This table is used to store the header level information for the iSetup preferences. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_AP_PREFERENCES_B_U1 | UNIQUE | APPS_TS_TX_IDX |
PREFERENCE_CODE
USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREFERENCE_CODE | VARCHAR2 | (45) | Y | Identifies the preferences unique against an API |
API_CODE | VARCHAR2 | (45) | Unique API Code being refered from az_apis table | |
API_VERSION | VARCHAR2 | (45) | Y | API Version for which the preference has been done |
CREATED_BY | NUMBER | (15) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this row |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated | |
USER_ID | NUMBER | (15) | Y | Tracks the user_id created the preference |
ENABLED_FLAG | VARCHAR2 | (1) | Indicates if preference is Enabled |
AZ.AZ_API_PREFERENCES_B does not reference any database object
AZ.AZ_API_PREFERENCES_B is referenced by following:
Description: | This table stores multi-lingual info for az_api_preferences. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_APIS_PREFERENCES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
PREFERENCE_CODE
USER_ID LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREFERENCE_CODE | VARCHAR2 | (45) | Y | Unique Identifier of Preference |
PREFERENCE_NAME | VARCHAR2 | (45) | Y | Unique Name identifier against the user |
PREFERENCE_DESC | VARCHAR2 | (1800) | description of the Preference | |
LANGUAGE | VARCHAR2 | (4) | Y | Indicates the language owning the row is alloted for |
SOURCE_LANG | VARCHAR2 | (4) | Y | Indicates in which language the row is inserted |
CREATED_BY | NUMBER | (15) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this row |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Records the operating system user_id updating this row | |
USER_ID | NUMBER | (15) | Y | Tracks the user_id created the preference |
AZ.AZ_API_PREFERENCES_TL does not reference any database object
AZ.AZ_API_PREFERENCES_TL is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_API_PREFERENCE_SOURCES_B_U1 | UNIQUE | APPS_TS_TX_IDX |
PREFERENCE_CODE
DATA_SOURCE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREFERENCE_CODE | VARCHAR2 | (45) | Y | Unique identifier for a preference |
DATA_SOURCE | VARCHAR2 | (255) | Y | Data Source Name with in a API |
REF_DATA_SOURCE | VARCHAR2 | (255) | Reference Data Source | |
CREATED_BY | NUMBER | (15) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this row |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated |
AZ.AZ_API_PREFERENCE_SOURCES_B does not reference any database object
AZ.AZ_API_PREFERENCE_SOURCES_B is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_API_PREFERENCE_SOURCES_T_U1 | UNIQUE | APPS_TS_TX_IDX |
PREFERENCE_CODE
DATA_SOURCE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREFERENCE_CODE | VARCHAR2 | (45) | Y | Unique Identifier for a preference |
DATA_SOURCE | VARCHAR2 | (255) | Y | Source perataining to a given preference |
DISPLAY_NAME | VARCHAR2 | (255) | User name for the Data Source | |
LANGUAGE | VARCHAR2 | (4) | Y | Indicates the language owning the row is alloted for |
SOURCE_LANG | VARCHAR2 | (4) | Y | Indicates in which language the row is inserted |
CREATED_BY | NUMBER | (15) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this row |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated |
AZ.AZ_API_PREFERENCE_SOURCES_TL does not reference any database object
AZ.AZ_API_PREFERENCE_SOURCES_TL is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_API_PREF_SRC_ATTRIBUTE_B_U1 | UNIQUE | APPS_TS_TX_IDX |
PREFERENCE_CODE
DATA_SOURCE ATTRIBUTE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREFERENCE_CODE | VARCHAR2 | (45) | Y | Unique Identifier for Preferences |
DATA_SOURCE | VARCHAR2 | (255) | Y | Source for a given Preference |
ATTRIBUTE_CODE | VARCHAR2 | (255) | Y | Attribute for a given preferences |
PARAM1 | VARCHAR2 | (255) | Column for future use | |
PARAM2 | VARCHAR2 | (255) | Column for future use | |
PARAM3 | VARCHAR2 | (255) | Column for future use | |
PARAM4 | VARCHAR2 | (255) | Column for future use | |
PARAM5 | VARCHAR2 | (255) | Column for future use | |
CREATED_BY | NUMBER | (15) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this row |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated | |
KEY_FLAG | VARCHAR2 | (1) | Indicates if the attribute is part of unique key | |
ENABLE_REPORT_FLAG | VARCHAR2 | (1) | Indicates if the attribute is selected for reporting |
AZ.AZ_API_PREF_SRC_ATTRIBUTES_B does not reference any database object
AZ.AZ_API_PREF_SRC_ATTRIBUTES_B is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_API_SRC_ATTRIBUTE_T_U1 | NONUNIQUE | APPS_TS_TX_IDX |
PREFERENCE_CODE
DATA_SOURCE ATTRIBUTE_CODE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREFERENCE_CODE | VARCHAR2 | (45) | Y | Unique identifier for Preference |
DATA_SOURCE | VARCHAR2 | (255) | Y | Source for a given preference code |
ATTRIBUTE_CODE | VARCHAR2 | (255) | Y | Attribute for a given Souce of a Preference Code |
DISPLAY_NAME | VARCHAR2 | (255) | Display Name for an attribute | |
LANGUAGE | VARCHAR2 | (4) | Y | Indicates the language owning the row is alloted for |
SOURCE_LANG | VARCHAR2 | (4) | Y | Indicates in which language the row is inserted |
CREATED_BY | NUMBER | (15) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this row Records the user_id updating this row |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated |
AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL does not reference any database object
AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL is referenced by following:
Description: | Stores wizard data |
---|
Foreign Key Column | Foreign Table |
---|---|
AZ_ARCHIVE.PARENT_NODE_ID | AZ_ARCHIVE |
Foreign Key Column | Foreign Table |
---|---|
AZ_ARCHIVE.PARENT_NODE_ID | AZ_ARCHIVE |
AZ_ARCHIVE_STEPS.NODE_ID | AZ_ARCHIVE |
AZ_ARCHIVE stores Wizard data pertaining to groups, processes, and tasks. Each row in the table includes the node ID, the node type that indicates whether it is a group, process, or task, the node name that is the label for the process or group, the context type for the process, the context name for the process, the context ID for the process, the status code indicating if it is active or complete, the item key to identify the task, the assigned user for the task role, and comments for the process.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_ARCHIVE_U1 | UNIQUE | APPS_TS_ARCHIVE | NODE_ID |
AZ_ARCHIVE_N1 | NONUNIQUE | APPS_TS_ARCHIVE | PARENT_NODE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NODE_ID | VARCHAR2 | (240) | Y | Unique identifier |
NODE_TYPE | VARCHAR2 | (1) | Y | Indicates if it is group, process, or task |
NODE_NAME | VARCHAR2 | (80) | Label for group, process, or task | |
CONTEXT_TYPE | VARCHAR2 | (30) | Context type of the process (BG for business group, IO for inventory organization, OU for operating unit, SOB for set of books) | |
CONTEXT_TYPE_NAME | VARCHAR2 | (80) | Context name for process (Business Group for BG, Set of Books for SOB, Operating Unit for OU, Inventory Organization for IO) | |
CONTEXT_ID | NUMBER | (15) | Context identifier for the process | |
CONTEXT_NAME | VARCHAR2 | (80) | Context name | |
STATUS_CODE | VARCHAR2 | (30) | Status for a process or task (A for active, C for complete, and N for not started process) | |
STATUS_NAME | VARCHAR2 | (80) | Label or meaning for status codes | |
ITEM_KEY | VARCHAR2 | (240) | Unique identifier for task | |
ASSIGNED_USER | VARCHAR2 | (100) | Role for the task | |
ASSIGNED_USER_NAME | VARCHAR2 | (4000) | User name for the task | |
START_DATE | DATE | Start date for the task | ||
END_DATE | DATE | Date when the task was completed | ||
DURATION | NUMBER | (15) | Time for which a task was active | |
COMMENTS | VARCHAR2 | (2000) | User-entered comments for process | |
PARENT_NODE_ID | VARCHAR2 | (240) | Parent identifier |
AZ.AZ_ARCHIVE does not reference any database object
AZ.AZ_ARCHIVE is referenced by following:
Description: | Stores Wizard data pertaining to tasks |
---|
Foreign Key Column | Foreign Table |
---|---|
AZ_ARCHIVE_STEPS.NODE_ID | AZ_ARCHIVE |
AZ_ARCHIVE_STEPS stores Wizard data regarding tasks and all their steps. Each row has information regarding each step of the task, its status, the assigned user, the form name associated with the step, and the begin date for the the task step.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_ARCHIVE_STEPS_U1 | UNIQUE | APPS_TS_ARCHIVE |
ITEM_KEY
ACTIVITY_TYPE STEP BEGIN_DATE |
AZ_ARCHIVE_STEPS_N1 | NONUNIQUE | APPS_TS_ARCHIVE | NODE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_KEY | VARCHAR2 | (240) | Y | Unique identifier for the task |
ACTIVITY_TYPE | VARCHAR2 | (8) | Y | Identifies type of task step (FUNCTION, NOTICE, or PROCESS) |
STEP | VARCHAR2 | (30) | Y | Step for the task |
STEP_NAME | VARCHAR2 | (80) | Y | Label for the step |
ASSIGNED_USER | VARCHAR2 | (100) | Assigned role for notification | |
ASSIGNED_USER_NAME | VARCHAR2 | (4000) | User name for the notification | |
FORM_NAME | VARCHAR2 | (4000) | The form associated with the task step | |
STATUS_CODE | VARCHAR2 | (8) | Status for the task step, either ACTIVE, COMPLETE, NOTIFIED, or ERROR | |
RESULT_CODE | VARCHAR2 | (30) | Response code for the step (e.g. skipped,. done, etc.) | |
BEGIN_DATE | DATE | Y | Start date for the task step | |
END_DATE | DATE | End date for the task step | ||
DURATION | NUMBER | (15) | Duration of the task | |
COMMENTS | VARCHAR2 | (4000) | Comments | |
NODE_ID | VARCHAR2 | (240) | Y | Unique identifier for the task step |
AZ.AZ_ARCHIVE_STEPS does not reference any database object
AZ.AZ_ARCHIVE_STEPS is referenced by following:
Description: | Used for storing sql statements that are dynamically executed. The sql statements are used for populating, validating, deleting contexts |
---|
Used for storing sql statements that are dynamically executed. The sql statements are used for populating, validating, deleting contexts
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_CONTEXTS_SQL_U1 | UNIQUE | APPS_TS_ARCHIVE |
CONTEXT
PURPOSE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTEXT | VARCHAR2 | (10) | Y | Context type designated by a code like 'OPMCOM', 'SOB' |
SQL_STATEMENT | VARCHAR2 | (500) | The sql statement which is dynamically executed | |
PURPOSE | VARCHAR2 | (20) | Y | A brief description of the sql statement |
DESCRIPTION | VARCHAR2 | (500) | A brief description of the sql statement |
AZ.AZ_CONTEXTS_SQL does not reference any database object
AZ.AZ_CONTEXTS_SQL is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
SYS_IL0000394514C00019$$ | UNIQUE | APPS_TS_TX_DATA | |
AZ_DIFF_RESULTS_HCD_NU2 | NONUNIQUE | APPS_TS_TX_IDX | HASHCODE_DETAILS |
AZ_DIFF_RESULTS_NU1 | NONUNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
SOURCE PARENT_ID ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (240) | Entity Name | |
DISPLAY_NAME | VARCHAR2 | (240) | Entity Display Name | |
REQUEST_ID | NUMBER | (15) | Y | Concurrent Request ID |
SOURCE | VARCHAR2 | (240) | Y | Entity Code or Split code |
TYPE | NUMBER | (2) | Type Indicator for the record | |
ID | NUMBER | Y | Unique Sequence for the record | |
PARENT_ID | NUMBER | Parent Sequence ID | ||
HASHCODE_DETAILS | VARCHAR2 | (2000) | Hash of the key attributes | |
DEPTH | NUMBER | Level of Hierarchy | ||
IS_DIFFERENT | VARCHAR2 | (1) | Indicates if the row is different while being compared | |
IS_TRANSFORMED | VARCHAR2 | (1) | Indicates if the row is transformed | |
SHOW_ONLY_DIFF | VARCHAR2 | (1) | Flag to indicate that this record would be a part of only differences in the downloadable report | |
PARAM1 | VARCHAR2 | (240) | For future use | |
PARAM2 | VARCHAR2 | (240) | For future use | |
PARAM3 | VARCHAR2 | (240) | For future use | |
PARAM4 | VARCHAR2 | (240) | For future use | |
PARAM5 | VARCHAR2 | (240) | For future use | |
ATTR_DIFF | XMLTYPE | (2000) | ||
DETAIL_LOG_STATUS | VARCHAR2 | (255) | Status of a load for a given row | |
DETAIL_LOG_MSG | VARCHAR2 | (2000) | Log message of load for a given row |
Description: | Runtime files |
---|
This table stores runtime files for iSetups.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_FILES_U1 | UNIQUE | APPS_TS_TX_IDX |
CONFIG_HDR_ID
CONFIG_REV_NBR |
SYS_IL0000192707C00009$$ | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONFIG_HDR_ID | NUMBER | (9) | Y | Config id of the configuration of which this file belongs to |
CONFIG_REV_NBR | NUMBER | (9) | Y | The revision number of the configuration |
NAME | VARCHAR2 | (255) | Name of the file | |
DESCRIPTION | VARCHAR2 | (4000) | Description of the file | |
DISPLAYNAME | VARCHAR2 | (255) | Display name of the file | |
MISC1 | VARCHAR2 | (4000) | Reserved for future use | |
MISC2 | VARCHAR2 | (4000) | Reserved for future use | |
MISC3 | VARCHAR2 | (4000) | Reserved for future use | |
CONTENT | BLOB | (4000) | Content of the file | |
CREATED_BY | NUMBER | (15) | Y | Standard who/date columns |
CREATION_DATE | DATE | Y | Standard who/date columns | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who/date columns |
LAST_UPDATE_DATE | DATE | Y | Standard who/date columns | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who/date columns |
AZ.AZ_FILES does not reference any database object
AZ.AZ_FILES is referenced by following:
Description: | Process groups information |
---|
Foreign Key Column | Foreign Table |
---|---|
AZ_GROUPS.HIERARCHY_PARENT_ID
AZ_GROUPS.HIERARCHY_PARENT_PROCESS_TYPE |
AZ_GROUPS |
AZ_GROUPS.DEPENDENCY_PARENT_ID
AZ_GROUPS.DEPENDENCY_PARENT_PROCESS_TYPE |
AZ_GROUPS |
Foreign Key Column | Foreign Table |
---|---|
AZ_GROUPS.HIERARCHY_PARENT_ID
AZ_GROUPS.HIERARCHY_PARENT_PROCESS_TYPE |
AZ_GROUPS |
AZ_GROUPS.DEPENDENCY_PARENT_ID
AZ_GROUPS.DEPENDENCY_PARENT_PROCESS_TYPE |
AZ_GROUPS |
AZ_PROCESSES.PARENT_ID
AZ_PROCESSES.PROCESS_TYPE |
AZ_GROUPS |
AZ_PRODUCT_FLOWS.PARENT_ID
AZ_PRODUCT_FLOWS.PROCESS_TYPE |
AZ_GROUPS |
AZ_GROUPS stores information about the process groups used in the Implementation Wizard form. Each record contains the unique identifier of the group, the parent process group that is associated with the group, as well as the display order, color code, complete flag, and the application or lookup code that the process group is associated with. Additionally, to enable differents types of implementation of the Wizard, there is also a process type for each group indicating its implementation type.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_GROUPS_U1 | UNIQUE | APPS_TS_ARCHIVE |
GROUP_ID
PROCESS_TYPE |
AZ_GROUPS_N1 | NONUNIQUE | APPS_TS_ARCHIVE |
HIERARCHY_PARENT_ID
HIERARCHY_PARENT_PROCESS_TYPE |
AZ_GROUPS_N2 | NONUNIQUE | APPS_TS_ARCHIVE |
DEPENDENCY_PARENT_ID
DEPENDENCY_PARENT_PROCESS_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | VARCHAR2 | (240) | Y | Group identifier |
PROCESS_TYPE | VARCHAR2 | (30) | Y | Identifies the implementation type for the process |
HIERARCHY_PARENT_PROCESS_TYPE | VARCHAR2 | (30) | Implementation type for the parent of the node | |
COMPLETE_FLAG | VARCHAR2 | (1) | Y | Indicates whether the process group is complete |
COLOR_CODE | VARCHAR2 | (30) | Color code associated with the process group | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column |
DEPENDENCY_PARENT_PROCESS_TYPE | VARCHAR2 | (30) | Implementation type (upgrade or fresh implementation) of dependency parent or node | |
DISPLAY_ORDER | NUMBER | (15) | Y | Display order of process groups at different levels |
APPLICATION_ID | NUMBER | (15) | Application identifier | |
LOOKUP_CODE | VARCHAR2 | (30) | Quickcode code | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
HIERARCHY_PARENT_ID | VARCHAR2 | (240) | Parent process group that the process group is associated with in the hierarchy tree | |
DEPENDENCY_PARENT_ID | VARCHAR2 | (240) | Parent process group that the process group is associated with in the dependency chart |
AZ.AZ_GROUPS does not reference any database object
AZ.AZ_GROUPS is referenced by following:
Description: | DB Instances |
---|
This table stores connection info for each DB that iSetup Migrator uses.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_INSTANCES_U1 | UNIQUE | APPS_TS_TX_IDX |
INSTANCE_NAME
USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_NAME | VARCHAR2 | (45) | Y | Instance Name |
USER_ID | NUMBER | (15) | Y | User ID |
HOST_NAME | VARCHAR2 | (240) | Y | Host Name |
DATABASE_NAME | VARCHAR2 | (45) | Y | Database Name |
USER_NAME | VARCHAR2 | (100) | User Name | |
PASSWORD | VARCHAR2 | (100) | Password | |
RESPONSIBILITY_KEY | VARCHAR2 | (30) | Responsibility Key | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
DBC_FILENAME | VARCHAR2 | (300) | DBC Filename used for Mapping |
AZ.AZ_INSTANCES does not reference any database object
AZ.AZ_INSTANCES is referenced by following:
Description: | Triggers |
---|
This table stores triggers that are disabled by the
iSetups convert-to-multiorg concurrent program.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_NAME | VARCHAR2 | (50) | Y | Name of the trigger |
AZ.AZ_MORG_TRIGGERS does not reference any database object
AZ.AZ_MORG_TRIGGERS is referenced by following:
Description: | Workflow processes information |
---|
Foreign Key Column | Foreign Table |
---|---|
AZ_PROCESSES.PARENT_ID
AZ_PROCESSES.PROCESS_TYPE |
AZ_GROUPS |
AZ_PROCESSES stores information about the runnable workflow
processes with different context names and context types. Each record
contains the item type, process name, context ID, context name, and
context type, as well as the complete flag, the parent process group
that it is associated with, the display order in the hierarchy tree,
and the user entered comments for the process from the Implementation
Wizard form.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_PROCESSES_U1 | UNIQUE | APPS_TS_ARCHIVE |
ITEM_TYPE
PROCESS_NAME CONTEXT_ID |
AZ_PROCESSES_N1 | NONUNIQUE | APPS_TS_ARCHIVE |
PARENT_ID
PROCESS_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_TYPE | VARCHAR2 | (30) | Y | Identifies if the process belongs to a fresh implementation or an upgrade |
ITEM_TYPE | VARCHAR2 | (30) | Y | Item type |
PROCESS_NAME | VARCHAR2 | (30) | Y | Internal name of the process activity |
CONTEXT_ID | NUMBER | (15) | Y | Context identifier |
DISPLAY_ORDER | NUMBER | (15) | Y | Display order of the process in the hierarchy tree |
STATUS_CODE | VARCHAR2 | (30) | Y | Status for the process (A for Active, N for Not Started, C for Complete) |
CONTEXT_TYPE | VARCHAR2 | (30) | Y | Context type of the process (BG for business group, IO for inventory organization, OU for operating unit, SOB for set of books) |
CONTEXT_NAME | VARCHAR2 | (80) | Context name of the process | |
COMMENTS | VARCHAR2 | (2000) | User-entered comments for the process | |
PARENT_ID | VARCHAR2 | (240) | Y | Parent process group that the process is associated with |
COMPLETE_FLAG | VARCHAR2 | (1) | Flag to indicate whether the process is complete |
AZ.AZ_PROCESSES does not reference any database object
AZ.AZ_PROCESSES is referenced by following:
Description: | Workflow processes information for each product |
---|
Foreign Key Column | Foreign Table |
---|---|
AZ_PRODUCT_FLOWS.PARENT_ID
AZ_PRODUCT_FLOWS.PROCESS_TYPE |
AZ_GROUPS |
AZ_PRODUCT_FLOWS stores information about the runnable workflow
processes for each application. Each record contains the unique
identifier of the application, the item type, process name, and context
type, as well as the parent process group that it is associated with
and its display order in the hierarchy tree.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_PRODUCT_FLOWS_U1 | UNIQUE | APPS_TS_ARCHIVE |
APPLICATION_ID
ITEM_TYPE PROCESS_NAME |
AZ_PRODUCT_FLOWS_N1 | NONUNIQUE | APPS_TS_ARCHIVE |
PARENT_ID
PROCESS_TYPE |
AZ_PRODUCT_FLOWS_N2 | NONUNIQUE | APPS_TS_ARCHIVE |
ITEM_TYPE
PROCESS_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_TYPE | VARCHAR2 | (30) | Y | Implementation type for process, Fresh or Upgrade |
APPLICATION_ID | NUMBER | (15) | Y | Application identifier |
ITEM_TYPE | VARCHAR2 | (30) | Y | Item type |
PROCESS_NAME | VARCHAR2 | (30) | Y | Internal name of the process activity |
DISPLAY_ORDER | NUMBER | (15) | Y | Display order of the process in the hierarchy tree |
CONTEXT_TYPE | VARCHAR2 | (30) | Y | Context type of the process (BG for business group, IO for inventory organization, OU for operating unit, SOB for set of books) |
PARENT_ID | VARCHAR2 | (240) | Y | Parent process group that the process is associated with |
AZ.AZ_PRODUCT_FLOWS does not reference any database object
AZ.AZ_PRODUCT_FLOWS is referenced by following:
Description: | Phase information for each installed product |
---|
AZ_PRODUCT_PHASES stores information about the phase for each
installed product. Each record contains the unique identifier of
the application and its corresponding phase.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_PRODUCT_PHASES_U1 | UNIQUE | APPS_TS_ARCHIVE | APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Y | Application identifier |
PHASE | NUMBER | (15) | Y | Phase in the implementation cycle |
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) | Standard Who column |
AZ.AZ_PRODUCT_PHASES does not reference any database object
AZ.AZ_PRODUCT_PHASES is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
SYS_IL0000394516C00019$$ | UNIQUE | APPS_TS_TX_DATA | |
AZ_REPORTER_DATA_HCD_NU3 | NONUNIQUE | APPS_TS_TX_IDX | HASHCODE_DETAILS |
AZ_REPORTER_DATA_HC_NU2 | NONUNIQUE | APPS_TS_TX_IDX | HASHCODE |
AZ_REPORTER_DATA_ISPRIM_NU2 | NONUNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
SOURCE ID PARENT_ID IS_PRIMARY |
AZ_REPORTER_DATA_NU1 | NONUNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
SOURCE PARENT_ID ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (240) | Y | |
DISPLAY_NAME | VARCHAR2 | (240) | ||
REQUEST_ID | NUMBER | (15) | Y | |
SOURCE | VARCHAR2 | (240) | Y | |
TYPE | NUMBER | (2) | ||
ID | NUMBER | Y | ||
PARENT_ID | NUMBER | |||
HASHCODE | NUMBER | |||
HASHCODE_DETAILS | VARCHAR2 | (2000) | ||
DELETED_FLAG | VARCHAR2 | (1) | ||
IS_PRIMARY | VARCHAR2 | (1) | Y | |
PARAM1 | VARCHAR2 | (240) | ||
PARAM2 | VARCHAR2 | (240) | ||
PARAM3 | VARCHAR2 | (240) | ||
PARAM4 | VARCHAR2 | (240) | ||
PARAM5 | VARCHAR2 | (240) | ||
DEPTH | NUMBER | |||
ATTRIBUTES | XMLTYPE | (2000) |
Description: | iSetup Requests |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_REQUESTS_U1 | UNIQUE | APPS_TS_TX_IDX |
JOB_NAME
REQUEST_TYPE USER_ID |
SYS_IL0000239517C00012$$ | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000239517C00031$$ | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000239517C00033$$ | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NAME | VARCHAR2 | (45) | Y | Job Name |
REQUEST_TYPE | VARCHAR2 | (1) | Y | Request Type |
USER_ID | NUMBER | (15) | Y | User ID |
REQUEST_ID | NUMBER | (15) | Y | Request ID |
INSTANCE_NAME | VARCHAR2 | (45) | Y | Instance Name |
JOB_DESC | VARCHAR2 | (1800) | Job Description | |
PREVIOUS_REQ_IDS | VARCHAR2 | (240) | Previous request IDs | |
REQUEST_PHASE | VARCHAR2 | (1) | Y | Request Phase |
REQUEST_STATUS | VARCHAR2 | (1) | Y | Request Status |
SUBMISSION_DATE | DATE | Submission Date | ||
COMPLETION_DATE | DATE | Completion Date | ||
CONTENT | BLOB | (4000) | Content | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
PARAM1 | VARCHAR2 | (240) | Param1 | |
PARAM2 | VARCHAR2 | (240) | Param1 | |
PARAM3 | VARCHAR2 | (240) | Param1 | |
PARAM4 | VARCHAR2 | (240) | Param1 | |
PARAM5 | VARCHAR2 | (240) | Param1 | |
PARAM6 | VARCHAR2 | (240) | Param1 | |
PARAM7 | VARCHAR2 | (240) | Param1 | |
PARAM8 | VARCHAR2 | (240) | Param1 | |
PARAM9 | VARCHAR2 | (240) | Param1 | |
PARAM10 | VARCHAR2 | (240) | Param1 | |
SCHEDULED | DATE | |||
ACTIVE | VARCHAR2 | (1) | ||
SELECTION_SET | XMLTYPE | (2000) | ||
DRIVER_FILE | XMLTYPE | (2000) |
Description: | Selection Sets |
---|
This table stores selection sets.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_SELECTION_SETS_B_U1 | UNIQUE | APPS_TS_TX_IDX |
SELECTION_SET_CODE
USER_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SELECTION_SET_CODE | VARCHAR2 | (45) | Y | Selection Set Code |
USER_ID | NUMBER | (15) | Y | User ID |
STRUCTURE_CODE | VARCHAR2 | (30) | Y | Structure Code |
PREDEFINED_FLAG | VARCHAR2 | (1) | Y | Predefined Flag |
SOURCE_INSTANCE | VARCHAR2 | (45) | Source Instance | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
REF_SELECTION_SET_CODE | VARCHAR2 | (45) | Reference Selection Set Code | |
ACTIVE | VARCHAR2 | (1) | Active | |
HIERARCHICAL_FLAG | VARCHAR2 | (1) | Hierarchical Flag | |
PARTIAL_SELECTION | VARCHAR2 | (1) | Partial Selection | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_SELECTION_SETS_B does not reference any database object
AZ.AZ_SELECTION_SETS_B is referenced by following:
Description: | Selection Sets TL |
---|
This table stores multi-lingual info for az_selection_sets.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_SELECTION_SETS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
SELECTION_SET_CODE
USER_ID LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SELECTION_SET_CODE | VARCHAR2 | (45) | Y | Selection Set Code |
USER_ID | NUMBER | (15) | Y | User ID |
LANGUAGE | VARCHAR2 | (4) | Y | Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source Language |
SELECTION_SET_NAME | VARCHAR2 | (45) | Y | Selection Set Name |
SELECTION_SET_DESC | VARCHAR2 | (1800) | Selection Set Description | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_SELECTION_SETS_TL does not reference any database object
AZ.AZ_SELECTION_SETS_TL is referenced by following:
Description: | Selection Set APIs Definition |
---|
This table stores what APIs are included in each selection set for iSetup Migrator.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_SELECTION_SET_APIS_U1 | UNIQUE | APPS_TS_TX_IDX |
JOB_NAME
ENTITY_OCCURANCE_CODE SUBMITTED_BY |
SYS_IL0000239541C00011$$ | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NAME | VARCHAR2 | (45) | Y | Job Name |
ENTITY_OCCURANCE_CODE | VARCHAR2 | (45) | Y | Entity Occurance Code |
SUBMITTED_BY | NUMBER | (15) | Y | Submitted By |
API_CODE | VARCHAR2 | (45) | Y | API Code |
EXECUTION_STATUS | VARCHAR2 | (1) | Y | Execution Status |
CREATED_BY | NUMBER | (15) | Y | Standard who columns |
CREATION_DATE | DATE | Y | Standard who columns | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who columns |
LAST_UPDATE_DATE | DATE | Y | Standard who columns | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who columns | |
FILTERING_PARAMETER | CLOB | (4000) | Filtering Parameter |
AZ.AZ_SELECTION_SET_APIS does not reference any database object
AZ.AZ_SELECTION_SET_APIS is referenced by following:
Description: | Selection Set Entities |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_SELECTION_SET_ENTITIES_B_U1 | UNIQUE | APPS_TS_TX_IDX |
SELECTION_SET_CODE
USER_ID ENTITY_OCCURANCE_CODE ZD_EDITION_NAME |
SYS_IL0000239549C00016$$ | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SELECTION_SET_CODE | VARCHAR2 | (45) | Y | Selection Set Code |
USER_ID | NUMBER | (15) | Y | User ID |
ENTITY_OCCURANCE_CODE | VARCHAR2 | (45) | Y | Entity Occurance Code |
ENTITY_CODE | VARCHAR2 | (45) | Y | Entity Code |
INCLUDE_TYPE | VARCHAR2 | (1) | Include Type | |
REF_ENTITY_OCCURANCE_CODE | VARCHAR2 | (45) | Reference Entity Occurance Code | |
UPDATABLE_FLAG | VARCHAR2 | (1) | Updatable Flag | |
CHANGE_UPDATABLE_FLAG | VARCHAR2 | (1) | Change Updatable Flag | |
ALLOW_SET_TARGETVAL_FLAG | VARCHAR2 | (1) | Allow Set Targetval Flag | |
ALLOW_FILTER_FLAG | VARCHAR2 | (1) | Allow Filter Flag | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
FILTERING_PARAMETERS | CLOB | (4000) | Filtering Parameters | |
SELECTION_FLAG | VARCHAR2 | (1) | Selection Flag | |
SEQ_NUM | NUMBER | (15) | SEQ_NUM | |
FILTER_SET_FLAG | VARCHAR2 | (1) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_SELECTION_SET_ENTITIES_B does not reference any database object
AZ.AZ_SELECTION_SET_ENTITIES_B is referenced by following:
Description: | Selection Set Entities TL |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_SELECTION_SET_ENTITIES_TL | UNIQUE | APPS_TS_TX_IDX |
SELECTION_SET_CODE
USER_ID ENTITY_OCCURANCE_CODE LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SELECTION_SET_CODE | VARCHAR2 | (45) | Y | |
USER_ID | NUMBER | (15) | Y | |
ENTITY_OCCURANCE_CODE | VARCHAR2 | (45) | Y | |
LANGUAGE | VARCHAR2 | (4) | Y | |
SOURCE_LANG | VARCHAR2 | (4) | Y | |
ENTITY_OCCURANCE_NAME | VARCHAR2 | (240) | ||
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) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_SELECTION_SET_ENTITIES_TL does not reference any database object
AZ.AZ_SELECTION_SET_ENTITIES_TL is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_SELECTION_SET_TAXONOMIES_U1 | UNIQUE | APPS_TS_TX_IDX |
SELECTION_SET_CODE
TAXONOMY_CODE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SELECTION_SET_CODE | VARCHAR2 | (45) | Y | Indicates the code of the Selection Sets |
TAXONOMY_CODE | VARCHAR2 | (45) | Y | Unique identification for a Taxonomy |
SEQ_NUM | NUMBER | (15) | Indicates the sequence of the Selection Sets within a Taxonomy | |
CREATED_BY | NUMBER | (15) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this row |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Records the operating system user_id updating this row | |
ENABLED_FLAG | VARCHAR2 | (1) | Indicates if the Selection Set is enabled under a taxonomy | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_SELECTION_SET_TAXONOMIES does not reference any database object
AZ.AZ_SELECTION_SET_TAXONOMIES is referenced by following:
Description: | Structures |
---|
This table stores api structures.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_STRUCTURES_B_U1 | UNIQUE | APPS_TS_SEED |
STRUCTURE_CODE
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STRUCTURE_CODE | VARCHAR2 | (30) | Y | Structure Code |
HIERARCHICAL_FLAG | VARCHAR2 | (1) | Y | Hierarchical Flag |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ACTIVE | VARCHAR2 | (1) | Active | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_STRUCTURES_B does not reference any database object
AZ.AZ_STRUCTURES_B is referenced by following:
Description: | Structures TL |
---|
This table stores multilingual info for structures_b.
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_STRUCTURES_TL_U1 | UNIQUE | APPS_TS_SEED |
STRUCTURE_CODE
LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STRUCTURE_CODE | VARCHAR2 | (30) | Y | Structure Code |
LANGUAGE | VARCHAR2 | (4) | Y | Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source Language |
STRUCTURE_NAME | VARCHAR2 | (150) | Sturcture Name | |
STRUCTURE_DESC | VARCHAR2 | (1800) | Sturcture Description | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard datecolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_STRUCTURES_TL does not reference any database object
AZ.AZ_STRUCTURES_TL is referenced by following:
Description: | Structure APIs |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_STRUCTURE_APIS_B_U1 | UNIQUE | APPS_TS_SEED |
STRUCTURE_CODE
ENTITY_CODE ZD_EDITION_NAME |
SYS_IL0000239503C00011$$ | UNIQUE | APPS_TS_SEED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STRUCTURE_CODE | VARCHAR2 | (30) | Y | Structure Code is used to classify Selection Set Templates |
ENTITY_CODE | VARCHAR2 | (45) | Y | Used to establish relationship between Interfaces and Template entity names |
API_CODE | VARCHAR2 | (45) | Uniquely identifies an Interface | |
DISPLAY_RECORDS_FLAG | VARCHAR2 | (1) | Y | Display Records Flag |
PARENT_ENTITY_CODE | VARCHAR2 | (30) | Used to create hierarchical relationship between Template entities | |
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) | Standard who column | |
FILTERING_PARAMETER | CLOB | (4000) | Filtering Parameter | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_STRUCTURE_APIS_B does not reference any database object
AZ.AZ_STRUCTURE_APIS_B is referenced by following:
Description: | Structure APIs TL |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_STRUCTURE_APIS_TL_U1 | UNIQUE | APPS_TS_SEED |
STRUCTURE_CODE
ENTITY_CODE LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STRUCTURE_CODE | VARCHAR2 | (30) | Y | Used to classify Selection Set Templates |
ENTITY_CODE | VARCHAR2 | (45) | Y | Used to establish relationship between Interfaces and Template entity names |
LANGUAGE | VARCHAR2 | (4) | Y | Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source Language |
ENTITY_NAME | VARCHAR2 | (240) | Y | Entity Name |
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) | Standard who column | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_STRUCTURE_APIS_TL does not reference any database object
AZ.AZ_STRUCTURE_APIS_TL is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_TAXONOMIES_B_U1 | UNIQUE | APPS_TS_TX_IDX |
TAXONOMY_CODE
USER_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAXONOMY_CODE | VARCHAR2 | (45) | Y | Unique identification for a Taxonomy |
USER_ID | NUMBER | (15) | Y | Tracks the user id owning the taxonomy |
ENABLED_FLAG | VARCHAR2 | (1) | Indicates if the taxonomy is enabled | |
CREATED_BY | NUMBER | (4) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this row |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Records the operating system user_id updating this row | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_TAXONOMIES_B does not reference any database object
AZ.AZ_TAXONOMIES_B is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_TAXONOMIES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
TAXONOMY_CODE
USER_ID LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAXONOMY_CODE | VARCHAR2 | (45) | Y | Unique identification for a Taxonomy |
USER_ID | NUMBER | (15) | Y | Tracks the user id owning the taxonomy |
LANGUAGE | VARCHAR2 | (4) | Y | Indicates the language owning the row is alloted for |
SOURCE_LANG | VARCHAR2 | (4) | Y | Indicates in which language the row is inserted |
TAXONOMY_NAME | VARCHAR2 | (45) | Y | Name of the Taxonomy |
TAXONOMY_DESC | VARCHAR2 | (1800) | Description of the taxonomy | |
CREATED_BY | NUMBER | (15) | Y | Records the user_id creating the row |
CREATION_DATE | DATE | Y | Records the date row got created | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Records the user_id updating this ro |
LAST_UPDATE_DATE | DATE | Y | Records the date row got updated | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Records the operating system user_id updating this row | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
AZ.AZ_TAXONOMIES_TL does not reference any database object
AZ.AZ_TAXONOMIES_TL is referenced by following:
Description: | Templates |
---|
This table stores template files for iSetups
Index | Type | Tablespace | Column |
---|---|---|---|
AZ_TEMPLATES_U1 | UNIQUE | APPS_TS_SEED | NAME |
SYS_IL0000192701C00005$$ | UNIQUE | APPS_TS_SEED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (255) | Y | Name of the template file |
DISPLAY_NAME | VARCHAR2 | (255) | display name of the template file | |
DESCRIPTION | VARCHAR2 | (4000) | Description of the template file | |
VERSION | VARCHAR2 | (255) | Version of the template file | |
CONTENT | BLOB | (4000) | The content of the file | |
CREATED_BY | NUMBER | (15) | Y | Standard who/date column |
CREATION_DATE | DATE | Y | Standard who/date column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who/date column |
LAST_UPDATE_DATE | DATE | Y | Standard who/date column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who/date columns |
AZ.AZ_TEMPLATES does not reference any database object
AZ.AZ_TEMPLATES is referenced by following:
A public view which may be useful for custom reporting or other data requirements.
AZ_FLOW_PHASES_V is a view that stores information about the workflow
processes and their corresponding phase(s). Each row includes the
item type, process name and its associated phase. This view is
primarily used for backend processing.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_TYPE | VARCHAR2 | (30) | Y | WorkFlow Item Type |
PROCESS_NAME | VARCHAR2 | (30) | Y | Workflow process name |
PHASE | NUMBER | (15) | Y | The implementation phase for this process |
APPS.AZ_FLOW_PHASES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_GROUPS_V is a view that joins AZ_GROUPS, FND_APPLICATION_VL, and FND_LOOKUPS to provide quick access to the display name of each group.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | VARCHAR2 | (240) | Implementation group ID | |
PROCESS_TYPE | VARCHAR2 | (30) | Type of processes belonging to this group | |
DISPLAY_NAME | VARCHAR2 | (240) | Display name | |
DISPLAY_ORDER | NUMBER | (15) | The display order for this group | |
STATUS | VARCHAR2 | (1) | Implementation status of this group | |
COMPLETE_FLAG | VARCHAR2 | (1) | Completion status | |
APPLICATION_ID | NUMBER | (15) | Application ID of the group | |
LOOKUP_CODE | VARCHAR2 | (30) | Lookup code of this group | |
COLOR_CODE | VARCHAR2 | (30) | Color code for display | |
HIERARCHY_PARENT_ID | VARCHAR2 | (240) | Hierarchy parent ID | |
HIERARCHY_PARENT_PROCESS_TYPE | VARCHAR2 | (30) | Hierarchy parent process type | |
DEPENDENCY_PARENT_ID | VARCHAR2 | (240) | Dependency parent ID | |
DEPENDENCY_PARENT_PROCESS_TYPE | VARCHAR2 | (30) | Dependency parent process type | |
CREATION_DATE | DATE | Standard who column | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
APPS.AZ_GROUPS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_PROCESSES_V is a view based on ap_processes regardless of the process_type. It also provides quick access to the display name and the context type name of the processes.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_TYPE | VARCHAR2 | (30) | Y | Workflow item type |
PROCESS_NAME | VARCHAR2 | (30) | Y | Workflow process name |
DISPLAY_NAME | VARCHAR2 | (80) | Y | Display name |
CONTEXT_ID | NUMBER | (15) | Y | ID of the context for this process |
PARENT_ID | VARCHAR2 | (240) | Y | Parent process ID |
DISPLAY_ORDER | NUMBER | (15) | Y | The display order for this process |
STATUS | VARCHAR2 | (30) | Y | Implementation status of this process |
PROCESS_TYPE | VARCHAR2 | (30) | Y | Process type |
CONTEXT_TYPE | VARCHAR2 | (30) | Y | Context type |
CONTEXT_TYPE_NAME | VARCHAR2 | (80) | Y | Context type display name |
CONTEXT_NAME | VARCHAR2 | (80) | Name of the context | |
COMMENTS | VARCHAR2 | (2000) | Comments recorded for this context | |
DESCRIPTION | VARCHAR2 | (240) | Description for this process |
APPS.AZ_PROCESSES_ALL_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
A view based on az_processes table. It provides a view of az_processes filtering processes by their
process type. The view contains wizard processes having process type equal to the current implementation mode which is a profile option.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_TYPE | VARCHAR2 | (30) | Y | Workflow item type |
PROCESS_NAME | VARCHAR2 | (30) | Y | Workflow process name |
CONTEXT_ID | NUMBER | (15) | Y | ID of the context for this process |
PARENT_ID | VARCHAR2 | (240) | Y | Parent process ID |
DISPLAY_ORDER | NUMBER | (15) | Y | The display order for this process |
STATUS_CODE | VARCHAR2 | (30) | Y | Implementation status for this process |
PROCESS_TYPE | VARCHAR2 | (30) | Y | Process type |
CONTEXT_TYPE | VARCHAR2 | (30) | Y | Context type |
CONTEXT_NAME | VARCHAR2 | (80) | Name of the context | |
COMMENTS | VARCHAR2 | (2000) | Comments recorded for this process |
APPS.AZ_PROCESSES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_PROCESS_ACTIVITIES_V is a view that stores the definition of a
process. Each row includes the item type, process name, context id as
well as the complete flag, description and user entered comments of a
process. This view is mainly used by the Implementation Wizard form.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_TYPE | VARCHAR2 | (30) | Y | Workflow item type |
PROCESS_NAME | VARCHAR2 | (30) | Y | Workflow process name |
CONTEXT_ID | NUMBER | (15) | Y | ID of the context for this process |
COMPLETE_FLAG | VARCHAR2 | (1) | Completion status | |
COMMENTS | VARCHAR2 | (2000) | Comments recorded for this process | |
VERSION | NUMBER | Y | Version of this process | |
DESCRIPTION | VARCHAR2 | (240) | Description for this process |
APPS.AZ_PROCESS_ACTIVITIES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_PRODUCT_PHASES_V is a view that stores information about the phase
for each installed product defined in AZ_GROUPS. Each row includes
the unique identifier and name of an application as well as its
corresponding phase. This view is mainly used by the Define Phase
form.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Y | Application ID for this product |
APPLICATION_NAME | VARCHAR2 | (240) | Y | Application name for this product |
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | Application short name for this product |
PHASE | NUMBER | (15) | Y | Implementation phase for this product |
APPS.AZ_PRODUCT_PHASES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_SELECTION_SETS_VL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ROW_ID | |
CREATION_DATE | DATE | Y | CREATION_DATE | |
LAST_UPDATED_BY | NUMBER | (15) | Y | LAST_UPDATED_BY |
LAST_UPDATE_DATE | DATE | Y | LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | NUMBER | (15) | LAST_UPDATE_LOGIN | |
SELECTION_SET_CODE | VARCHAR2 | (45) | Y | SELECTION_SET_CODE |
USER_ID | NUMBER | (15) | Y | USER_ID |
STRUCTURE_CODE | VARCHAR2 | (30) | Y | STRUCTURE_CODE |
REF_SELECTION_SET_CODE | VARCHAR2 | (45) | Reference Selection Set Code | |
ACTIVE | VARCHAR2 | (1) | Active | |
HIERARCHICAL_FLAG | VARCHAR2 | (1) | Hierarchical Flag | |
PARTIAL_SELECTION | VARCHAR2 | (1) | Partial Selection | |
CREATED_BY | NUMBER | (15) | Y | CREATED_BY |
SOURCE_INSTANCE | VARCHAR2 | (45) | SOURCE_INSTANCE | |
PREDEFINED_FLAG | VARCHAR2 | (1) | Y | PREDEFINED_FLAG |
SELECTION_SET_NAME | VARCHAR2 | (45) | Y | SELECTION_SET_NAME |
SELECTION_SET_DESC | VARCHAR2 | (1800) | SELECTION_SET_DESC |
APPS.AZ_SELECTION_SETS_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_SELECTION_SET_ENTITIES_VL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ROW_ID | |
REF_ENTITY_OCCURANCE_CODE | VARCHAR2 | (45) | REF_ENTITY_OCCURANCE_CODE | |
UPDATABLE_FLAG | VARCHAR2 | (1) | UPDATABLE_FLAG | |
ALLOW_SET_TARGETVAL_FLAG | VARCHAR2 | (1) | ALLOW_SET_TARGETVAL_FLAG | |
ALLOW_FILTER_FLAG | VARCHAR2 | (1) | ALLOW_FILTER_FLAG | |
CREATED_BY | NUMBER | (15) | Y | CREATED_BY |
CREATION_DATE | DATE | Y | CREATION_DATE | |
LAST_UPDATED_BY | NUMBER | (15) | Y | LAST_UPDATED_BY |
LAST_UPDATE_DATE | DATE | Y | LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | NUMBER | (15) | LAST_UPDATE_LOGIN | |
CHANGE_UPDATABLE_FLAG | VARCHAR2 | (1) | CHANGE_UPDATABLE_FLAG | |
ENTITY_CODE | VARCHAR2 | (45) | Y | ENTITY_CODE |
FILTERING_PARAMETERS | CLOB | (4000) | FILTERING_PARAMETERS | |
INCLUDE_TYPE | VARCHAR2 | (1) | INCLUDE_TYPE | |
ENTITY_OCCURANCE_CODE | VARCHAR2 | (45) | Y | ENTITY_OCCURANCE_CODE |
USER_ID | NUMBER | (15) | Y | USER_ID |
SELECTION_SET_CODE | VARCHAR2 | (45) | Y | SELECTION_SET_CODE |
FILTER_SET_FLAG | VARCHAR2 | (1) | Filter Set Flag | |
SEQ_NUM | NUMBER | (15) | SEQ_NUM | |
SELECTION_FLAG | VARCHAR2 | (1) | SELECTION_FLAG | |
ENTITY_OCCURANCE_NAME | VARCHAR2 | (240) | ENTITY_OCCURANCE_NAME |
APPS.AZ_SELECTION_SET_ENTITIES_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_STRUCTURES_VL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ROW_ID | |
CREATION_DATE | DATE | Y | CREATION_DATE | |
LAST_UPDATED_BY | NUMBER | (15) | Y | LAST_UPDATED_BY |
LAST_UPDATE_DATE | DATE | Y | LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | NUMBER | (15) | LAST_UPDATE_LOGIN | |
STRUCTURE_CODE | VARCHAR2 | (30) | Y | STRUCTURE_CODE |
HIERARCHICAL_FLAG | VARCHAR2 | (1) | Y | HIERARCHICAL_FLAG |
ACTIVE | VARCHAR2 | (1) | ACTIVE | |
CREATED_BY | NUMBER | (15) | Y | CREATED_BY |
STRUCTURE_NAME | VARCHAR2 | (150) | STRUCTURE_NAME | |
STRUCTURE_DESC | VARCHAR2 | (1800) | STRUCTURE_DESC |
APPS.AZ_STRUCTURES_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_STRUCTURE_APIS_VL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ROW_ID | |
LAST_UPDATE_LOGIN | NUMBER | (15) | LAST_UPDATE_LOGIN | |
PARENT_ENTITY_CODE | VARCHAR2 | (30) | PARENT_ENTITY_CODE | |
FILTERING_PARAMETER | CLOB | (4000) | FILTERING_PARAMETER | |
DISPLAY_RECORDS_FLAG | VARCHAR2 | (1) | Y | DISPLAY_RECORDS_FLAG |
LAST_UPDATE_DATE | DATE | Y | LAST_UPDATE_DATE | |
STRUCTURE_CODE | VARCHAR2 | (30) | Y | STRUCTURE_CODE |
ENTITY_CODE | VARCHAR2 | (45) | Y | ENTITY_CODE |
API_CODE | VARCHAR2 | (45) | API_CODE | |
CREATION_DATE | DATE | Y | CREATION_DATE | |
LAST_UPDATED_BY | NUMBER | (15) | Y | LAST_UPDATED_BY |
CREATED_BY | NUMBER | (15) | Y | CREATED_BY |
ENTITY_NAME | VARCHAR2 | (240) | Y | ENTITY_NAME |
APPS.AZ_STRUCTURE_APIS_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
AZ_TASKS_V is a view containing all the tasks, or items in Workflow terminology, belong to AZ. Each row includes item key, item type, process name, activity instance id, begin date, end date, assigned user, status, and duration. It is built upon WF_ITEMS, WF_ITEM_ATTRIBUTE_STATUSES, WF_ITEM_ATTRIBUTE_VALUES, and WF_PROCESS_ACTIVITIES.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_TYPE | VARCHAR2 | (8) | Y | Workflow item type |
ITEM_KEY | VARCHAR2 | (240) | Y | Workflow item key |
ROOT_ACTIVITY | VARCHAR2 | (30) | Y | Root activity for this task |
CONTEXT_ID | NUMBER | Context ID for this task | ||
CONTEXT_NAME | VARCHAR2 | (80) | Context name for this task | |
BEGIN_DATE | DATE | Y | The date this task is started | |
END_DATE | DATE | The date this task is completed | ||
ASSIGNED_USER | VARCHAR2 | (100) | The user working on this task | |
ACTIVITY_ID | NUMBER | Y | Activity ID for this task | |
STATUS | VARCHAR2 | (1) | Implementation status for this task | |
DURATION | NUMBER | The period between BEGIN_DATE and END_DATE |
APPS.AZ_TASKS_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |