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: | This table, will contain information associating a role definition tothe corresponding table and fields to which the role will beassociated. Also Defines the hierarchy of the role .This servers as aseed data for the form where the actual |
---|
This table, will contain information associating a role definition to the corresponding table and fields to which the role will be associated. Also Defines the hierarchy of the role .This servers as a
seed data for the form where the actual data is associated to a specific role.
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_ACTCOL_WF_B_PK | UNIQUE | APPS_TS_SEED |
ACTIVITY_ID
TABLE_NAME COLUMN_NAME ZD_EDITION_NAME |
GMA_ACTCOL_WF_B_UK | UNIQUE | APPS_TS_SEED |
ACTIVITY_ID
COLUMN_HIERARCHY ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_ID | NUMBER | (10) | Y | Activity Identification number |
COLUMN_HIERARCHY | NUMBER | (3) | Hierarchy of the field | |
TABLE_NAME | VARCHAR2 | (100) | Y | Table associated to the column |
COLUMN_NAME | VARCHAR2 | (32) | Y | Column name to which the role name is associated |
LOV_TABLE | VARCHAR2 | (100) | Y | Table from where the values are validated |
LOV_COLUMN | VARCHAR2 | (200) | Y | List of columns to be appearing on LOV |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO Column |
CREATED_BY | NUMBER | (15) | Y | Standard WHO Column |
CREATION_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.GMA_ACTCOL_WF_B does not reference any database object
GMA.GMA_ACTCOL_WF_B is referenced by following:
Description: | Checks the availability of Activity Identification in GMA_ACTDEF_WF before inserting a row in GMA_ACTCOL_WF |
---|
Checks the availability of Activity Identification in GMA_ACTDEF_WF before inserting a row in GMA_ACTCOL_WF
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_ACTCOL_WF_TL_UK | UNIQUE | APPS_TS_SEED |
ACTIVITY_ID
TABLE_NAME COLUMN_NAME LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_ID | NUMBER | (10) | Y | Activity Identification Number |
COLUMN_HIERARCHY | NUMBER | (5) | Hierarchy of the field | |
TABLE_NAME | VARCHAR2 | (100) | Y | Table associated to the column |
COLUMN_NAME | VARCHAR2 | (32) | Y | Column name to which the role name is associated |
COLUMN_PROMPT | VARCHAR2 | (40) | Y | Column prompt to be displayed |
SOURCE_LANG | VARCHAR2 | (4) | Y | MLS Support - source language |
LANGUAGE | VARCHAR2 | (4) | Y | MLS Suport - Current Language |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO Column |
CREATED_BY | NUMBER | (15) | Y | Standard WHO Column |
CREATION_DATE | DATE | Y | Standard WHO Column | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.GMA_ACTCOL_WF_TL does not reference any database object
GMA.GMA_ACTCOL_WF_TL is referenced by following:
Description: | This table will contain the actual data of the role association .User Role association with specific set of data is stored in this table. |
---|
This table will contain the actual data of the role association .User Role association with specific set of data is stored in this table.
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_ACTDATA_WF_UK | UNIQUE | APPS_TS_SEED |
ACTIVITY_ID
COLUMN_VALUE1 COLUMN_VALUE2 COLUMN_VALUE3 COLUMN_VALUE4 COLUMN_VALUE5 COLUMN_VALUE6 COLUMN_VALUE7 COLUMN_VALUE8 COLUMN_VALUE9 COLUMN_VALUE10 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_ID | NUMBER | (10) | Y | Role Identfication number |
COLUMN_NAME1 | VARCHAR2 | (32) | Column name1 to which the role name is associated | |
COLUMN_VALUE1 | VARCHAR2 | (240) | Column value 1 for the role | |
COLUMN_NAME2 | VARCHAR2 | (32) | Column name2 to which the role name is associated | |
COLUMN_VALUE2 | VARCHAR2 | (240) | Column value 2 for the role | |
COLUMN_NAME3 | VARCHAR2 | (32) | Column name3 to which the role name is associated | |
COLUMN_VALUE3 | VARCHAR2 | (240) | Column value 3 for the role | |
COLUMN_NAME4 | VARCHAR2 | (32) | Column name4 to which the role name is associated | |
COLUMN_VALUE4 | VARCHAR2 | (240) | Column value 4 for the role | |
COLUMN_NAME5 | VARCHAR2 | (32) | Column name5 to which the role name is associated | |
COLUMN_VALUE5 | VARCHAR2 | (240) | Column value 5 for the role | |
COLUMN_NAME6 | VARCHAR2 | (32) | Column name6 to which the role name is associated | |
COLUMN_VALUE6 | VARCHAR2 | (240) | Column value 6 for the role | |
COLUMN_NAME7 | VARCHAR2 | (32) | Column name7 to which the role name is associated | |
COLUMN_VALUE7 | VARCHAR2 | (240) | Column value 7 for the role | |
COLUMN_NAME8 | VARCHAR2 | (32) | Column name8 to which the role name is associated | |
COLUMN_VALUE8 | VARCHAR2 | (240) | Column value 8 for the role | |
COLUMN_NAME9 | VARCHAR2 | (32) | Column name9 to which the role name is associated | |
COLUMN_VALUE9 | VARCHAR2 | (240) | Column value 9 for the role | |
COLUMN_NAME10 | VARCHAR2 | (32) | Column name10 to which the role name is associated | |
COLUMN_VALUE10 | VARCHAR2 | (240) | Column value 10 for the role | |
ROLE | VARCHAR2 | (30) | Column role value associated | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO Column |
CREATED_BY | NUMBER | (15) | Y | Standard WHO Column |
CREATION_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
SORT_ORDER | NUMBER | (5) | Used to show the user in which order conditions are checked | |
ENABLE_FLAG | VARCHAR2 | (1) | Used to identify whetherapproval required or not |
GMA.GMA_ACTDATA_WF does not reference any database object
GMA.GMA_ACTDATA_WF is referenced by following:
Description: | This table is used to define the activity where a role has to be |
---|
This table is used to define the activity where a role has to be
resolved which will be used by a workflow and is to be resolved during
the process of the workflow.
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_ACTDEF_WF_PK | UNIQUE | APPS_TS_SEED | ACTIVITY_ID |
GMA_ACTDEF_WF_UK | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
PROCESS_NAME ACTIVITY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_ID | NUMBER | (10) | Y | Activity Identification Number |
WF_ITEM_TYPE | VARCHAR2 | (8) | Y | Item Type of the Workflow |
PROCESS_NAME | VARCHAR2 | (100) | Y | Process name in the workflow |
ACTIVITY_NAME | VARCHAR2 | (100) | Y | Activity name to where the role is resolved |
DESCRIPTION | VARCHAR2 | (240) | Description of the process | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO Column |
LAST_UPDATE_DATE | DATE | Y | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Y | Standard WHO Column |
CREATION_DATE | DATE | Y | Standard WHO Column | |
COLUMN_DATA_SQL | VARCHAR2 | (4000) | SQL statement to get the column values defined for the process level |
GMA.GMA_ACTDEF_WF does not reference any database object
GMA.GMA_ACTDEF_WF is referenced by following:
Description: | This table is to store Display columns for Shown on Audit Query Navigator |
---|
This table is to store Display columns for Shown on Audit Query Navigator
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_AUDIT_DISP_COLS_PK | UNIQUE | APPS_TS_ARCHIVE |
APPLICATION_ID
TABLE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Y | Table Owner Application ID as defined in FND Tables Table | |
TABLE_ID | NUMBER | Y | Table ID as defined in FND Tables Table | |
COL_DISP_IND | NUMBER | 0 - For Column List, 1 - For SQL Query | ||
SELECT_CLAUSE | VARCHAR2 | (2000) | This is to store Column List for both options | |
FROM_CLAUSE | VARCHAR2 | (2000) | This column store From clause of SQL Query if COL_DISP_IND value is 1 | |
WHERE_CLAUSE | VARCHAR2 | (2000) | This column store Where clause of SQL Query if COL_DISP_IND value is 1 | |
MIGRATED_IND | VARCHAR2 | (1) | This column is to indentify data migrated to FND tables or not |
GMA.GMA_AUDIT_DISP_COLS does not reference any database object
GMA.GMA_AUDIT_DISP_COLS is referenced by following:
Description: | This table is to store Lookup Type information to show decoded column values in Audit Query Navigator form |
---|
This table is to store Lookup Type information to show decoded column values in Audit Query Navigator form
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_AUDIT_LKUPS_P | UNIQUE | APPS_TS_ARCHIVE |
TABLE_APP_ID
AUDIT_TABLE_ID AUDIT_COLUMN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_TABLE_ID | NUMBER | Y | Table ID as defined in FND Audit Columns Table | |
AUDIT_COLUMN_ID | NUMBER | Y | Column ID as defined in FND Audit Columns Table | |
TABLE_APP_ID | NUMBER | Y | Table Owner Application ID as defined in FND Audit Columns Table | |
LOOKUP_TYPE | VARCHAR2 | (80) | FND Lookup Type |
GMA.GMA_AUDIT_LKUPS does not reference any database object
GMA.GMA_AUDIT_LKUPS is referenced by following:
Description: | This table is for Audit Trail Reporting. Data in this table is Temporary in nature |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REP_ID | NUMBER | |||
TABLE_NAME | VARCHAR2 | (30) | ||
AUDIT_KEY | VARCHAR2 | (240) | ||
ROW_DISP_COL | VARCHAR2 | (240) | ||
AUDIT_TIMESTAMP | DATE | |||
AUDIT_TRANSACTION_TYPE | VARCHAR2 | (20) | ||
AUDIT_USER_NAME | VARCHAR2 | (80) | ||
COLUMN1_VALUE | VARCHAR2 | (240) | ||
COLUMN2_VALUE | VARCHAR2 | (240) | ||
COLUMN3_VALUE | VARCHAR2 | (240) | ||
COLUMN4_VALUE | VARCHAR2 | (240) | ||
COLUMN5_VALUE | VARCHAR2 | (240) |
GMA.GMA_AUDIT_REP_DTL does not reference any database object
GMA.GMA_AUDIT_REP_DTL is referenced by following:
Description: | This table is for Audit Trail Reporting. Data in this table is Temporary in nature |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REP_ID | NUMBER | |||
TABLE_NAME | VARCHAR2 | (30) | ||
USER_TABLE_NAME | VARCHAR2 | (80) | ||
COLUMN1_NAME | VARCHAR2 | (80) | ||
COLUMN2_NAME | VARCHAR2 | (80) | ||
COLUMN3_NAME | VARCHAR2 | (80) | ||
COLUMN4_NAME | VARCHAR2 | (80) | ||
COLUMN5_NAME | VARCHAR2 | (80) | ||
SELECT_CLAUSE | VARCHAR2 | (2000) | ||
APPLICATION_ID | NUMBER | |||
TABLE_ID | NUMBER | |||
WHERE_CLAUSE | VARCHAR2 | (2000) |
GMA.GMA_AUDIT_REP_HDR does not reference any database object
GMA.GMA_AUDIT_REP_HDR is referenced by following:
Description: | This table is to store relation between Industry Templates and Audit Groups |
---|
Foreign Key Column | Foreign Table |
---|---|
GMA_AUDIT_TMPLT_DTL.TEMPLATE_NAME | GMA_AUDIT_TMPLT_MST |
This table is to store relation between Industry Templates and Audit Groups
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_AUDIT_TMPLT_DTL_PK | UNIQUE | APPS_TS_ARCHIVE |
TEMPLATE_NAME
AUDIT_GROUP_ID APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_NAME | VARCHAR2 | (80) | Y | Industry Template |
AUDIT_GROUP_ID | NUMBER | Y | Audit Group ID | |
APPLICATION_ID | NUMBER | Y | Audit Group Application ID | |
CREATION_DATE | DATE | Y | Creation Date | |
CREATED_BY | NUMBER | (15) | Y | Created By |
LAST_UPDATE_DATE | DATE | Y | Last Updated Date | |
LAST_UPDATED_BY | NUMBER | Y | Last Updated By | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Last Update Login |
MIGRATED_IND | VARCHAR2 | (1) | This column is to indentify data migrated to FND tables or not |
GMA.GMA_AUDIT_TMPLT_DTL does not reference any database object
GMA.GMA_AUDIT_TMPLT_DTL is referenced by following:
Description: | This table is to store Industry Templates |
---|
Foreign Key Column | Foreign Table |
---|---|
GMA_AUDIT_TMPLT_DTL.TEMPLATE_NAME | GMA_AUDIT_TMPLT_MST |
This table is to store Industry Templates
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_AUDIT_TMPLT_MST_PK | UNIQUE | APPS_TS_ARCHIVE | TEMPLATE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_NAME | VARCHAR2 | (80) | Y | Industry Template |
TEMPLATE_DESC | VARCHAR2 | (100) | Industry Template Description | |
CREATION_DATE | DATE | Y | Creation Date | |
CREATED_BY | NUMBER | (15) | Y | Created By |
LAST_UPDATE_DATE | DATE | Y | Last Updated Date | |
LAST_UPDATED_BY | NUMBER | Y | Last Updated By | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Last Update Login |
MIGRATED_IND | VARCHAR2 | (1) | This column is to indentify data migrated to FND tables or not |
GMA.GMA_AUDIT_TMPLT_MST does not reference any database object
GMA.GMA_AUDIT_TMPLT_MST is referenced by following:
Description: | TO TRACK MIGRATION ERRORS |
---|
TO TRACK MIGRATION ERRORS
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_MIGRATION_CONTROL_N1 | NONUNIQUE | APPS_TS_TX_IDX | MIG_NAME |
GMA_MIGRATION_CONTROL_N2 | NONUNIQUE | APPS_TS_TX_IDX | APPLICATION_SHORT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RUN_ID | NUMBER | ID to track each run of migration scripts | ||
MIG_NAME | VARCHAR2 | (80) | Y | Name of Migration |
MIG_START_DATE | DATE | The start time of the migration | ||
MIG_END_DATE | DATE | The end time of the migration | ||
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | Application Short Name |
GMA.GMA_MIGRATION_CONTROL does not reference any database object
GMA.GMA_MIGRATION_CONTROL is referenced by following:
Description: | TO TRACK MIGRATION ERRORS |
---|
TO TRACK MIGRATION ERRORS
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_MIGRATION_LOG_I1 | NONUNIQUE | APPS_TS_TX_IDX |
RUN_ID
TABLE_NAME |
GMA_MIGRATION_LOG_N1 | NONUNIQUE | APPS_TS_TX_IDX | MESSAGE_TYPE |
GMA_MIGRATION_LOG_N2 | NONUNIQUE | APPS_TS_TX_IDX | TABLE_NAME |
GMA_MIGRATION_LOG_N3 | NONUNIQUE | APPS_TS_TX_IDX | CONTEXT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_NAME | VARCHAR2 | (80) | The name of the table the message is for | |
LINE_NO | NUMBER | Line number that caused the error | ||
RUN_ID | NUMBER | Y | ID to track each run of migration scripts | |
MESSAGE_TOKEN | VARCHAR2 | (80) | Y | Message being entered |
MESSAGE_TYPE | VARCHAR2 | (2) | Y | Either I, E, D, P |
PARAM1 | VARCHAR2 | (2000) | OPTIONAL PARAM1 | |
PARAM2 | VARCHAR2 | (2000) | OPTIONAL PARAM2 | |
PARAM3 | VARCHAR2 | (2000) | OPTIONAL PARAM3 | |
PARAM4 | VARCHAR2 | (2000) | OPTIONAL PARAM4 | |
PARAM5 | VARCHAR2 | (2000) | OPTIONAL PARAM5 | |
DB_ERROR | VARCHAR2 | (2000) | TRACK DB ERROR | |
POSITION | NUMBER | Position in function where the error occurred | ||
TIMESTAMP | DATE | Time of table entry | ||
BASE_MESSAGE | VARCHAR2 | (2000) | Message for the programmer to bypass fnd_message reference | |
MSG_APP_SHORT_NAME | VARCHAR2 | (3) | Application short name for the message text | |
CONTEXT | VARCHAR2 | (80) | Migration context in which the message was logged | |
TOKEN1 | VARCHAR2 | (80) | Token for substituting values in the message | |
TOKEN2 | VARCHAR2 | (80) | Token for substituting values in the message | |
TOKEN3 | VARCHAR2 | (80) | Token for substituting values in | |
TOKEN4 | VARCHAR2 | (80) | Token for substituting values in | |
TOKEN5 | VARCHAR2 | (80) | Token for substituting values in | |
TOKEN6 | VARCHAR2 | (80) | Token for substituting values in | |
PARAM6 | VARCHAR2 | (2000) | Value to substitute for token6 |
GMA.GMA_MIGRATION_LOG does not reference any database object
GMA.GMA_MIGRATION_LOG is referenced by following:
Description: | This table contains information about configuration columns at workflow process level. Using these columns users can customize the approval process behavior. This data is used as seed data for the Workflow Process Configuration screen. |
---|
This table contains information about configuration columns at workflow process level. Using these columns users can customize the approval process behavior. This data is used as seed data for the Workflow Process Configuration screen. When users query an approval process in the form, this table data is used to determine how many columns are associated with the approval process and what are these columns.
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_PROCCOL_WF_B_PK | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
PROCESS_NAME TABLE_NAME COLUMN_NAME ZD_EDITION_NAME |
GMA_PROCCOL_WF_B_UK | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
PROCESS_NAME COLUMN_HIERARCHY ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WF_ITEM_TYPE | VARCHAR2 | (8) | Y | Workflow Item Type |
PROCESS_NAME | VARCHAR2 | (30) | Y | Workflow process name |
COLUMN_HIERARCHY | NUMBER | (3) | Y | Workflow column hierarchy |
TABLE_NAME | VARCHAR2 | (100) | Y | Workflow table name |
COLUMN_NAME | VARCHAR2 | (32) | Y | Workflow column name |
COLUMN_PROMPT | VARCHAR2 | (40) | Workflow column prompt | |
LOV_TABLE | VARCHAR2 | (100) | Y | List of Values table |
LOV_COLUMN | VARCHAR2 | (200) | Y | List of Values column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.GMA_PROCCOL_WF_B does not reference any database object
GMA.GMA_PROCCOL_WF_B is referenced by following:
Description: | This table contains translated column prompts and provides multi-lingueal support. |
---|
This table contains translated column prompts and provides multi-lingueal support.
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_PROCCOL_WF_TL_PK | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
PROCESS_NAME TABLE_NAME COLUMN_NAME LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WF_ITEM_TYPE | VARCHAR2 | (8) | Y | Item type of the workflow |
PROCESS_NAME | VARCHAR2 | (30) | Y | Process name of the workflow |
COLUMN_HIERARCHY | NUMBER | (5) | Y | Hierarchy of the field |
TABLE_NAME | VARCHAR2 | (100) | Y | Table associated to the column |
COLUMN_NAME | VARCHAR2 | (32) | Y | Column name |
COLUMN_PROMPT | VARCHAR2 | (40) | Y | Column prompt to be displayed |
SOURCE_LANG | VARCHAR2 | (4) | Y | MLS Support - Source Language |
LANGUAGE | VARCHAR2 | (4) | Y | MLS Support-Current Language |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.GMA_PROCCOL_WF_TL does not reference any database object
GMA.GMA_PROCCOL_WF_TL is referenced by following:
Description: | This table stores users process customizations data. This data determines the approval process behavior and is used by the API to determine if approval is required or not for a data set. |
---|
This table stores users process customizations data. This data determines the approval process behavior and is used by the API to determine if approval is required or not for a data set.
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_PROCDATA_WF_UK | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
PROCESS_NAME COLUMN_VALUE1 COLUMN_VALUE2 COLUMN_VALUE3 COLUMN_VALUE4 COLUMN_VALUE5 COLUMN_VALUE6 COLUMN_VALUE7 COLUMN_VALUE8 COLUMN_VALUE9 COLUMN_VALUE10 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WF_ITEM_TYPE | VARCHAR2 | (8) | Item type of the workflow | |
PROCESS_NAME | VARCHAR2 | (30) | Process name of the workflow | |
COLUMN_NAME1 | VARCHAR2 | (32) | Column name 1 | |
COLUMN_VALUE1 | VARCHAR2 | (240) | Column value 1 | |
COLUMN_NAME2 | VARCHAR2 | (32) | Column name 2 | |
COLUMN_VALUE2 | VARCHAR2 | (240) | Column value 2 | |
COLUMN_NAME3 | VARCHAR2 | (32) | Column name 3 | |
COLUMN_VALUE3 | VARCHAR2 | (240) | Column value 3 | |
COLUMN_NAME4 | VARCHAR2 | (32) | Column name 4 | |
COLUMN_VALUE4 | VARCHAR2 | (240) | Column value 4 | |
COLUMN_NAME5 | VARCHAR2 | (32) | Column name 5 | |
COLUMN_VALUE5 | VARCHAR2 | (240) | Column value 5 | |
COLUMN_NAME6 | VARCHAR2 | (32) | Column name 6 | |
COLUMN_VALUE6 | VARCHAR2 | (240) | Column value 6 | |
COLUMN_NAME7 | VARCHAR2 | (32) | Column name 7 | |
COLUMN_VALUE7 | VARCHAR2 | (240) | Column value 7 | |
COLUMN_NAME8 | VARCHAR2 | (32) | Column name 8 | |
COLUMN_VALUE8 | VARCHAR2 | (240) | Column value 8 | |
COLUMN_NAME9 | VARCHAR2 | (32) | Column name 9 | |
COLUMN_VALUE9 | VARCHAR2 | (240) | Column value 9 | |
COLUMN_NAME10 | VARCHAR2 | (32) | Column name 10 | |
COLUMN_VALUE10 | VARCHAR2 | (240) | Column value 10 | |
ROLE | VARCHAR2 | (30) | Workflow role | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
ENABLE_FLAG | VARCHAR2 | (1) | Values are N or Y | |
SORT_ORDER | NUMBER | (5) | Sort order |
GMA.GMA_PROCDATA_WF does not reference any database object
GMA.GMA_PROCDATA_WF is referenced by following:
Description: | Purpose of this table is to store workflow processes that are using generic approval process configuration framework. This also stores the information about these processes whether they enabled or disabled. |
---|
Purpose of this table is to store workflow processes that are using generic approval process configuration framework. This also stores the information about these processes whether they enabled or disabled. Using this data, API determines whether the approval process is enabled or disabled at instance level.
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_PROCDEF_WF_PK | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
PROCESS_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WF_ITEM_TYPE | VARCHAR2 | (8) | Y | Item type for the workflow |
PROCESS_NAME | VARCHAR2 | (30) | Y | Process name for the workflow |
ENABLE_FLAG | VARCHAR2 | (1) | Workflow enable/disable flag, values are Y or N | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
COLUMN_DATA_SQL | VARCHAR2 | (4000) | SQL statement to get the column values defined for the process level |
GMA.GMA_PROCDEF_WF does not reference any database object
GMA.GMA_PROCDEF_WF is referenced by following:
Description: | Reason Code Security Table |
---|
This table is used with Reason Code Security to allow OPM users to associate security to reason codes by document type and user responsibility.
Index | Type | Tablespace | Column |
---|---|---|---|
GMA_REASON_CODE_SECURITY_U1 | UNIQUE | APPS_TS_TX_IDX |
REASON_CODE
DOC_TYPE RESPONSIBILITY_ID |
GMA_REASON_CODE_SECURITY_I1 | NONUNIQUE | APPS_TS_TX_IDX |
DOC_TYPE
RESPONSIBILITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REASON_CODE | VARCHAR2 | (4) | Y | Reason Code used for Security |
DOC_TYPE | VARCHAR2 | (4) | Document Type used for Security | |
RESPONSIBILITY_ID | NUMBER | (15) | User Responsibility ID used for Security | |
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 | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column |
GMA.GMA_REASON_CODE_SECURITY does not reference any database object
GMA.GMA_REASON_CODE_SECURITY is referenced by following:
Description: | OPM Address master. Table which stores addresses for all Oracle Process |
---|
Foreign Key Column | Foreign Table |
---|---|
GR_RECIPIENT_ADDRESSES.ADDR_ID | SY_ADDR_MST |
IC_WHSE_MST.ADDR_ID | SY_ADDR_MST |
OP_BILL_LAD.BOLADDR_ID | SY_ADDR_MST |
OP_CUST_CON.ADDR_ID | SY_ADDR_MST |
OP_CUST_MST_OPM.ADDR_ID | SY_ADDR_MST |
OP_CUST_MST_OPM.MAILADDR_ID | SY_ADDR_MST |
OP_CUST_MST.ADDR_ID | SY_ADDR_MST |
OP_CUST_MST.MAILADDR_ID | SY_ADDR_MST |
OP_FOBC_MST.ADDR_ID | SY_ADDR_MST |
OP_LKBX_MST.ADDR_ID | SY_ADDR_MST |
OP_ORDR_DTL.SHIPADDR_ID | SY_ADDR_MST |
OP_ORDR_HDR.SHIPADDR_ID | SY_ADDR_MST |
OP_PORT_MST.ADDR_ID | SY_ADDR_MST |
OP_PRSL_DTL.SHIPADDR_ID | SY_ADDR_MST |
OP_PRSL_HDR.SHIPADDR_ID | SY_ADDR_MST |
OP_RELS_SCH.SHIPADDR_ID | SY_ADDR_MST |
OP_SHIP_MST.ADDR_ID | SY_ADDR_MST |
OP_SLSR_MST.ADDR_ID | SY_ADDR_MST |
PO_BPOS_DTL.RECVADDR_ID | SY_ADDR_MST |
PO_BPOS_HDR.ORGNADDR_ID | SY_ADDR_MST |
PO_ORDR_DTL.RECVADDR_ID | SY_ADDR_MST |
PO_ORDR_HDR.RECVADDR_ID | SY_ADDR_MST |
PO_RECV_DTL.RECVADDR_ID | SY_ADDR_MST |
PO_RELS_SCH.RECVADDR_ID | SY_ADDR_MST |
PO_RTRN_HDR.RTRNADDR_ID | SY_ADDR_MST |
PO_VEND_MST.ADDR_ID | SY_ADDR_MST |
PO_VEND_MST.MAILADDR_ID | SY_ADDR_MST |
SY_ORGN_MST_B.ADDR_ID | SY_ADDR_MST |
SY_ORGN_MST.ADDR_ID | SY_ADDR_MST |
TX_TAXA_MST.ADDR_ID | SY_ADDR_MST |
OPM Address master. Table which stores addresses for all Oracle Process
Manufacturing applications entities.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDR_ID | NUMBER | (10) | Y | Surrogate id uniquely identifying an address. |
ADDR1 | VARCHAR2 | (70) | First line of the address. | |
ADDR2 | VARCHAR2 | (70) | Second line of the address. | |
ADDR3 | VARCHAR2 | (70) | Third line of the address. | |
ADDR4 | VARCHAR2 | (70) | Fourth line of the address. | |
STATE_CODE | VARCHAR2 | (4) | State code of the address. | |
COUNTRY_CODE | VARCHAR2 | (4) | Country code of the address. | |
POSTAL_CODE | VARCHAR2 | (16) | Postal code of the address. | |
PSEUDO_KEY | VARCHAR2 | (70) | Y | Allows recreation of link to originating record in case of table corruption. |
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 |
COMMENTS | VARCHAR2 | (40) | Comment Field - unused | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TRANS_CNT | NUMBER | (10) | Not currently used | |
ORA_ADDR4 | VARCHAR2 | (70) | Address Line used for Oracle Financials Integration | |
PROVINCE | VARCHAR2 | (70) | Province code | |
COUNTY | VARCHAR2 | (70) | County code | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
REQUEST_ID | NUMBER | (15) | Concurrent who column |
GMA.SY_ADDR_MST does not reference any database object
GMA.SY_ADDR_MST is referenced by following:
Description: | Stores Organization Definitions at a single level |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_CMPY_MST.CO_CODE | SY_ORGN_MST_B |
SY_CMPY_MST.CO_CODE | SY_ORGN_MST |
Stores Organization Definitions at a single level
Index | Type | Tablespace | Column |
---|---|---|---|
SY_CMPY_MST_PK | UNIQUE | APPS_TS_TX_IDX | CO_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | Y | Company Code |
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 |
GMA.SY_CMPY_MST does not reference any database object
GMA.SY_CMPY_MST is referenced by following:
Description: | Oracle Process Manufacturing Document master. This table stores document definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_DOCS_MST.TEXT_CODE | SY_TEXT_HDR |
Foreign Key Column | Foreign Table |
---|---|
IC_ADJS_JNL.TRANS_TYPE | SY_DOCS_MST |
IC_CYCL_ADT.DOC_TYPE | SY_DOCS_MST |
IC_TRAN_ARC.DOC_TYPE | SY_DOCS_MST |
IC_TRAN_CMP.DOC_TYPE | SY_DOCS_MST |
IC_TRAN_PND.DOC_TYPE | SY_DOCS_MST |
MR_ACTN_TBL.DOC_TYPE | SY_DOCS_MST |
PC_TRAN_PND.DOC_TYPE | SY_DOCS_MST |
PO_COST_DTL.DOC_TYPE | SY_DOCS_MST |
PO_DIST_DTL.DOC_TYPE | SY_DOCS_MST |
SY_DOCS_SEQ.DOC_TYPE | SY_DOCS_MST |
Oracle Process Manufacturing Document master. This table stores document definitions
used by inventory, resource and costing transactions in OPM.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_DOCS_MST_PK | UNIQUE | APPS_TS_SEED |
DOC_TYPE
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOC_TYPE | VARCHAR2 | (4) | Y | Document type. |
DOC_DESC | VARCHAR2 | (80) | Y | Description of the document in the default language. |
DESC_ENGLISH | VARCHAR2 | (80) | Y | Description of the document in english. |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.SY_DOCS_MST does not reference any database object
GMA.SY_DOCS_MST is referenced by following:
Description: | Document sequencing by organization. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_DOCS_SEQ.ORGN_CODE | SY_ORGN_MST_B |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE | SY_ORGN_MST_B |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE2 | SY_ORGN_MST_B |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE3 | SY_ORGN_MST_B |
SY_DOCS_SEQ.ORGN_CODE | SY_ORGN_MST |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE | SY_ORGN_MST |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE2 | SY_ORGN_MST |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE3 | SY_ORGN_MST |
SY_DOCS_SEQ.TEXT_CODE | SY_TEXT_HDR |
SY_DOCS_SEQ.DOC_TYPE | SY_DOCS_MST |
Foreign Key Column | Foreign Table |
---|---|
SY_ORGN_MST_B.SY_ORGN_MST_DOC_TYPE
SY_ORGN_MST_B.SY_ORGN_MST_ORGN_CODE |
SY_DOCS_SEQ |
SY_ORGN_MST.SY_ORGN_MST_DOC_TYPE
SY_ORGN_MST.SY_ORGN_MST_ORGN_CODE |
SY_DOCS_SEQ |
Document sequencing by OPM organization. Maintains document number
assignment rules including auto assignment. Does not support blank padding
characters.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_DOCS_SEQ_PK | UNIQUE | APPS_TS_TX_IDX |
DOC_TYPE
ORGN_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOC_TYPE | VARCHAR2 | (4) | Y | Document type for which the document sequencing rules are defined. |
ORGN_CODE | VARCHAR2 | (4) | Y | Organization for which document sequencing rules are defined. |
ASSIGNMENT_TYPE | NUMBER | (5) | Y | 1= manual assignment; 2=auto integer sequencing. |
LAST_ASSIGNED | NUMBER | (10) | Last integer assigned to the document inthe organization. | |
FORMAT_SIZE | NUMBER | (5) | Size of the document number. Must be greater than 0, less than 11. | |
PAD_CHAR | VARCHAR2 | (1) | Padding character used for padding leading spaces in the document number. Either blank or zero. | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DUMMY_FILL | VARCHAR2 | (255) | Used to enlarge record so it fills more of a logical database page. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SY_DOCS_SEQ_ORGN_CODE | VARCHAR2 | (4) | Document sequence organization code | |
SY_DOCS_SEQ_ORGN_CODE2 | VARCHAR2 | (4) | Document sequence organization code | |
SY_DOCS_SEQ_ORGN_CODE3 | VARCHAR2 | (4) | Document sequence organization code |
GMA.SY_DOCS_SEQ does not reference any database object
GMA.SY_DOCS_SEQ is referenced by following:
Description: | Geographic regions. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_GEOG_MST.TEXT_CODE | SY_TEXT_HDR |
Stores geographic regions used by Oracle Process Manufacturing entities. These regions
are classified by Country, State, Province and County.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_GEOG_MST_PK | UNIQUE | APPS_TS_SEED |
GEOG_TYPE
GEOG_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GEOG_TYPE | NUMBER | (2) | Y | Type of Geographical Region. 1=Country, 2=State, 3=Province, 4=County. |
GEOG_ID | NUMBER | Surrogate ID for composite PK - GEOG_TYPE + GEOG_CODE | ||
GEOG_CODE | VARCHAR2 | (4) | Y | Geography code such as state or country abbreviations. |
GEOG_DESC | VARCHAR2 | (80) | Y | Description of geography code. |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 |
GMA.SY_GEOG_MST does not reference any database object
GMA.SY_GEOG_MST is referenced by following:
Description: | Organization code master Base Table. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_ORGN_MST_B.ADDR_ID | SY_ADDR_MST |
SY_ORGN_MST_B.SY_ORGN_MST_DOC_TYPE
SY_ORGN_MST_B.SY_ORGN_MST_ORGN_CODE |
SY_DOCS_SEQ |
SY_ORGN_MST_B.CO_CODE | SY_ORGN_MST_B |
SY_ORGN_MST_B.PARENT_ORGN_CODE | SY_ORGN_MST_B |
SY_ORGN_MST_B.TEXT_CODE | SY_TEXT_HDR |
SY_ORGN_MST_B.TAXLOC_CODE | TX_TLOC_CDS |
Foreign Key Column | Foreign Table |
---|---|
CM_BRDN_DTL.ORGN_CODE | SY_ORGN_MST_B |
CM_CLDR_HDR_B.CO_CODE | SY_ORGN_MST_B |
CM_CMPT_MTL.CO_CODE | SY_ORGN_MST_B |
CM_RSRC_DTL.ORGN_CODE | SY_ORGN_MST_B |
CM_WHSE_EFF.ORGN_CODE | SY_ORGN_MST_B |
CM_WHSE_SRC.ORGN_CODE | SY_ORGN_MST_B |
CR_RSRC_DTL.ORGN_CODE | SY_ORGN_MST_B |
FC_FCST_DTL.ORGN_CODE | SY_ORGN_MST_B |
FM_CONF_TBL.ORGN_CODE | SY_ORGN_MST_B |
GL_ACCT_MAP.ORGN_CODE | SY_ORGN_MST_B |
GL_ACCU_MAP.ORGN_CODE | SY_ORGN_MST_B |
GL_ITEM_CST.ORGN_CODE | SY_ORGN_MST_B |
GL_LEDG_MAP.ORGN_CODE | SY_ORGN_MST_B |
GL_PLCY_MST.CO_CODE | SY_ORGN_MST_B |
GL_SETU_ERR.CO_CODE | SY_ORGN_MST_B |
GMD_RECIPE_PROCESS_PARAMETERS.ORGN_CODE | SY_ORGN_MST_B |
GMD_TESTS_B.ORGN_CODE | SY_ORGN_MST_B |
GMF_BURDEN_PERCENTAGES.ORGN_CODE | SY_ORGN_MST_B |
GMF_BURDEN_PRIORITIES.CO_CODE | SY_ORGN_MST_B |
GMP_FORM_EFF.PLANT_CODE | SY_ORGN_MST_B |
GMP_ITEM_APS.PLANT_CODE | SY_ORGN_MST_B |
GMP_ITEM_WPS.PLANT_CODE | SY_ORGN_MST_B |
GR_OTHER_NAMES_TL.ORGN_CODE | SY_ORGN_MST_B |
IC_ADJS_JNL.ORGN_CODE | SY_ORGN_MST_B |
IC_ADJS_JNL.CO_CODE | SY_ORGN_MST_B |
IC_CLDR_HDR_B.ORGN_CODE | SY_ORGN_MST_B |
IC_CYCL_HDR.ORGN_CODE | SY_ORGN_MST_B |
IC_JRNL_MST.ORGN_CODE | SY_ORGN_MST_B |
IC_PLNT_INV.ORGN_CODE | SY_ORGN_MST_B |
IC_TRAN_ARC.ORGN_CODE | SY_ORGN_MST_B |
IC_TRAN_ARC.CO_CODE | SY_ORGN_MST_B |
IC_TRAN_CMP.ORGN_CODE | SY_ORGN_MST_B |
IC_TRAN_CMP.CO_CODE | SY_ORGN_MST_B |
IC_TRAN_PND.ORGN_CODE | SY_ORGN_MST_B |
IC_TRAN_PND.CO_CODE | SY_ORGN_MST_B |
IC_WHSE_MST.ORGN_CODE | SY_ORGN_MST_B |
IC_XFER_MST.ORGN_CODE | SY_ORGN_MST_B |
MR_ACTN_TBL.ORGN_CODE | SY_ORGN_MST_B |
MR_MESG_TBL.ORGN_CODE | SY_ORGN_MST_B |
MR_TRAN_TBL.ORGN_CODE | SY_ORGN_MST_B |
MR_TRAN_TBL.CO_CODE | SY_ORGN_MST_B |
OP_BILL_LAD.ORGN_CODE | SY_ORGN_MST_B |
OP_CUST_MST_OPM.CO_CODE | SY_ORGN_MST_B |
OP_CUST_MST.CO_CODE | SY_ORGN_MST_B |
OP_ORDR_HDR.ORGN_CODE | SY_ORGN_MST_B |
OP_PRCE_EFF.ORGN_CODE | SY_ORGN_MST_B |
OP_SLSR_MST.CO_CODE | SY_ORGN_MST_B |
PC_TRAN_PND.ORGN_CODE | SY_ORGN_MST_B |
PM_BTCH_HDR.PLANT_CODE | SY_ORGN_MST_B |
PO_BPOS_HDR.ORGN_CODE | SY_ORGN_MST_B |
PO_DIST_DTL.CO_CODE | SY_ORGN_MST_B |
PO_ORDR_HDR.ORGN_CODE | SY_ORGN_MST_B |
PO_RECV_HDR.ORGN_CODE | SY_ORGN_MST_B |
PO_RTRN_HDR.ORGN_CODE | SY_ORGN_MST_B |
PO_VEND_MST.CO_CODE | SY_ORGN_MST_B |
PS_SCHD_DTL.ORGN_CODE | SY_ORGN_MST_B |
PS_SCHD_HDR.ORGN_CODE | SY_ORGN_MST_B |
PS_WHSE_EFF.PLANT_CODE | SY_ORGN_MST_B |
QC_ASSY_TYP.ORGN_CODE | SY_ORGN_MST_B |
QC_RSLT_MST.ORGN_CODE | SY_ORGN_MST_B |
QC_SMPL_MST.ORGN_CODE | SY_ORGN_MST_B |
QC_SPEC_MST.ORGN_CODE | SY_ORGN_MST_B |
SY_SOFT_DTL.CO_CODE | SY_ORGN_MST_B |
SY_CMPY_MST.CO_CODE | SY_ORGN_MST_B |
SY_DOCS_SEQ.ORGN_CODE | SY_ORGN_MST_B |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE | SY_ORGN_MST_B |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE2 | SY_ORGN_MST_B |
SY_DOCS_SEQ.SY_DOCS_SEQ_ORGN_CODE3 | SY_ORGN_MST_B |
SY_EXCP_TBL.CO_CODE | SY_ORGN_MST_B |
SY_ORGN_MST_B.CO_CODE | SY_ORGN_MST_B |
SY_ORGN_MST_B.PARENT_ORGN_CODE | SY_ORGN_MST_B |
SY_ORGN_USR.ORGN_CODE | SY_ORGN_MST_B |
Organization code (business unit) master for Oracle Process Manufacturing.
Define organization codes and addresses here. This table is linked to
HR_ORGANIZATION_UNITS by ORGANIZATION_ID, where a one to one relationship exists.
It also stores Resource Warehouse as used in the APS integration.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_ORGN_MST_B_PK | UNIQUE | APPS_TS_TX_IDX | ORGN_CODE |
SY_ORGN_MST_B_U1 | UNIQUE | APPS_TS_TX_IDX | ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization code. |
ORGN_NAME | VARCHAR2 | (40) | Organization name. | |
PARENT_ORGN_CODE | VARCHAR2 | (4) | Y | Orgn to which orgn_code reports. Must already exist in the table. |
CO_CODE | VARCHAR2 | (4) | Y | Company code of the organization. |
PLANT_IND | NUMBER | (5) | Y | 0=no the organization is not a plant; 1=yes the organization is a plant, 2=organization is a lab |
ADDR_ID | NUMBER | (10) | Surrogate of the organization address. | |
ORGANIZATION_ID | NUMBER | (15) | Foreign reference to HR_ORGANIZATION_UNITS | |
TAXLOC_CODE | VARCHAR2 | (10) | Tax Location Code for this organization (FK to TX_TLOC_CDS) | |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TRANS_CNT | NUMBER | (10) | Y | Not currently used |
POC_IND | NUMBER | (5) | 0=Do not generate POC transactions for organization; 1=Generate POC transactions for organization | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 | |
RESOURCE_WHSE_CODE | VARCHAR2 | (4) | Resource warehouse code associated to Plants | |
SY_ORGN_MST_ORGN_CODE | VARCHAR2 | (4) | Organization master organization code | |
SY_ORGN_MST_DOC_TYPE | VARCHAR2 | (4) | Organization master document type | |
ATTRIBUTE1 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE2 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE3 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE4 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE5 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE6 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE7 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE8 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE9 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE10 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE11 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE12 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE13 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE14 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE16 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE17 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE18 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE19 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE20 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE21 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE22 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE23 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE24 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE25 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE26 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE27 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE28 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE29 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE30 | VARCHAR2 | (240) | Standard WHO Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard WHO Column | |
MFG_CALENDAR_ID | NUMBER | The Surrogate Key for the MRP Calendar to be assigned to the Organization | ||
MIGRATE_AS_IND | NUMBER | (5) | This column holds the value for the migration preference for the organization. 0 - No Migration, 1 - Migrate As New, 2 - Migrate As Existing, 3 - Migrate As Inactive | |
ACTIVE_IND | NUMBER | (5) | Indicator if organization is used. 0 - Not Used, 1 - Used | |
INVENTORY_ORG_IND | VARCHAR2 | (1) | Indicator for migrating Org as an inventory org. Y - Yes, N - No | |
MASTER_ORGANIZATION_ID | NUMBER | (15) | Master Organization Id for the migrated organization | |
MIGRATED_IND | NUMBER | (5) | Organization migrated indicator. 0 - Not Migrated, 1 - Migrated | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Inventory Organization Code for the migrating organization | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Organization Name for the new orgs created at discrete end | |
PROCESS_ENABLED_IND | VARCHAR2 | (1) | Process Enabled Indicator. Y- Yes, N- No | |
REGULATORY_ORG_IND | VARCHAR2 | (1) | Regulatory organization indicator | |
TEMPLATE_ORGANIZATION_ID | NUMBER | (15) | Template organization for copying the values for the new org | |
DEFAULT_STATUS | VARCHAR2 | (4) | default status is added for R12.1 migration |
GMA.SY_ORGN_MST_B does not reference any database object
GMA.SY_ORGN_MST_B is referenced by following:
Description: | Translations table table holding OPM Organization names in multiple languages |
---|
Translations table table holding OPM Organization names in multiple languages
Index | Type | Tablespace | Column |
---|---|---|---|
SY_ORGN_MST_TL_PK | NONUNIQUE | APPS_TS_TX_IDX |
ORGN_CODE
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization code. |
LANGUAGE | VARCHAR2 | (4) | Y | Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source Language |
ORGN_NAME | VARCHAR2 | (40) | Y | Organization name. |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 |
GMA.SY_ORGN_MST_TL does not reference any database object
GMA.SY_ORGN_MST_TL is referenced by following:
Description: | Associates OPM Organizations with FND users |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_ORGN_USR.ORGN_CODE | SY_ORGN_MST_B |
SY_ORGN_USR.ORGN_CODE | SY_ORGN_MST |
Associates OPM Organizations with FND users. This dictates what Organization
a User has access to, limiting the ability to process transactions and view organization
specific data where necessary.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_ORGN_USR_PK | UNIQUE | APPS_TS_TX_IDX |
USER_ID
ORGN_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_ID | NUMBER | (15) | Y | Foreign Key to FND_USER |
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code (Foreign key to SY_ORGN_MST) |
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 |
GMA.SY_ORGN_USR does not reference any database object
GMA.SY_ORGN_USR is referenced by following:
Description: | Stores paragraph codes |
---|
Stores Oracle Process Manufacturing Paragraph Codes, which are used to
categorize text entered against any row in any OPM table. Paragraphs can be
defined at multiple levels, including by language and sub-paragraph code.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_PARA_CDS_TL_PK | UNIQUE | APPS_TS_TX_IDX |
TABLE_NAME
PARAGRAPH_CODE SUB_PARACODE LANGUAGE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_NAME | VARCHAR2 | (32) | Y | Table name |
LANG_CODE | VARCHAR2 | (4) | Y | Indicates language used in text. |
PARAGRAPH_CODE | VARCHAR2 | (4) | Y | Paragraph code |
SUB_PARACODE | NUMBER | (5) | Y | Sub Paragraph code |
PARA_DESC | VARCHAR2 | (255) | Y | Description of the Paragraph code |
NONPRINTABLE_IND | NUMBER | (5) | Y | Indicates whether the paragraph is printable |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 | |
LANGUAGE | VARCHAR2 | (4) | Y | The value stored in this column represents the Language in which the data will be displayed. |
SOURCE_LANG | VARCHAR2 | (4) | Y | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
SY_PARA_CDS_TL_TEXT_CODE | NUMBER | (10) | Translation text code | |
SY_PARA_CDS_TL_LANG_CODE | VARCHAR2 | (4) | Translation language code | |
SY_PARA_CDS_TL_PARAGRAPH_CODE | VARCHAR2 | (4) | Translation paragraph code | |
SY_PARA_CDS_TL_SUB_PARACODE | NUMBER | (5) | Translation subparagraph code | |
SY_PARA_CDS_TL_LINE_NO | NUMBER | (5) | Translation line number | |
SY_PARA_CDS_TL_LANGUAGE | VARCHAR2 | (4) | Translation language | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.SY_PARA_CDS_TL does not reference any database object
GMA.SY_PARA_CDS_TL is referenced by following:
Description: | OPM Purge and Archive definitions are stored in this table |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_DEF.TEXT_CODE | SY_TEXT_HDR |
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_DEF_ACT.PURGE_TYPE | SY_PURG_DEF |
SY_PURG_DEF_CRIT.PURGE_TYPE | SY_PURG_DEF |
SY_PURG_MST.PURGE_TYPE | SY_PURG_DEF |
OPM Purge and Archive definitions are stored in this table.
Index | Type | Tablespace | Column |
---|---|---|---|
SYS_IL0000035918C00014$$ | UNIQUE | APPS_TS_SEED | |
SY_PURG_DEF_PK | UNIQUE | APPS_TS_SEED |
PURGE_TYPE
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_TYPE | VARCHAR2 | (4) | Y | Purge Type - the name of the Purge and Archive routine (eg, PROD). |
PURGE_CLASS | VARCHAR2 | (1) | Y | Differentiates standard, pre-defined purges from user-defined purges. S = Standard Purge, Blank or Other = User Defined purge |
PURGE_DESC | VARCHAR2 | (255) | Y | Description of the Purge Type |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
WORK_TABLESPACE | VARCHAR2 | (30) | Tablespace to use for P/A temporary tables (defaults to user's default tablespace if null). | |
DEFAULT_TARGET_TABLESPACE | VARCHAR2 | (30) | Tablespace to use for P/A target tables (defaults to user's default tablespace if null). Can be overridden at the table level through sy_purg_def_act. | |
SQLSTATEMENT | CLOB | (4000) | Y | The sql statement used to select the rows to be archived or purged. |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.SY_PURG_DEF does not reference any database object
GMA.SY_PURG_DEF is referenced by following:
Description: | Designates the Action to be performed by OPM Purge and Archive on a table by table basis. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_DEF_ACT.PURGE_TYPE | SY_PURG_DEF |
SY_PURG_DEF_ACT.TEXT_CODE | SY_TEXT_HDR |
Designates the Action to be performed by OPM Purge and Archive on a table by table basis.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_PURG_DEF_ACT_PK | UNIQUE | APPS_TS_SEED |
PURGE_TYPE
TABLE_NAME ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_TYPE | VARCHAR2 | (4) | Y | Purge Type - the name of the Purge and Archive routine (eg, PROD). |
TABLE_NAME | VARCHAR2 | (32) | Y | Table to be archived or purged |
ACTION | VARCHAR2 | (1) | Not Used | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
ARCHIVE_ACTION | VARCHAR2 | (1) | Y | D = Delete rows after they are archived. K = Keep rows after they are archived |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
TARGET_TABLESPACE | VARCHAR2 | (30) | Tablespace to use for *this* table. If null, defaults to sy_purg_def.default_target_tablespace, then user's default tablespace. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.SY_PURG_DEF_ACT does not reference any database object
GMA.SY_PURG_DEF_ACT is referenced by following:
Description: | Stores the Purge Criteria tags. These criteria are used to determine what rows will be archived and purged. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_DEF_CRIT.TEXT_CODE | SY_TEXT_HDR |
SY_PURG_DEF_CRIT.PURGE_TYPE | SY_PURG_DEF |
Stores the Purge Criteria tags. These criteria are used to determine
what rows will be archived and purged.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_PURG_DEF_CRIT_PK | UNIQUE | APPS_TS_SEED |
PURGE_TYPE
CRIT_TAG ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_TYPE | VARCHAR2 | (4) | Y | Purge Type - the name of the Purge and Archive routine (eg, PROD). |
CRIT_TAG | VARCHAR2 | (32) | Y | Criteria tag. Serves as a placeholder where selection criteria will be entered |
DEFAULT_VALUE | VARCHAR2 | (32) | Default value for the Criteria Tag. Default Value is Blank, but can be updated by the end user. | |
MASK | VARCHAR2 | (120) | Not Used | |
DESCRIPTION | VARCHAR2 | (80) | Description of what criteria should be entered for a field on the form (eg, Enter Operator Code). This will be displayed at the time of criteria entry. | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
VALUE_MASK | VARCHAR2 | (120) | Y | Will handle masking of data in order to feed Criteria to SQL statement during execution (eg, CHAR, DATE, NUMBER). |
SEQUENCE | NUMBER | (15) | Purge Sequence | |
LOV_TABLE | VARCHAR2 | (4000) | Holds the base table for the Purge Criteria LOV. | |
LOV_FIELD | VARCHAR2 | (4000) | Holds the field name for the Purge Criteria LOV. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
GMA.SY_PURG_DEF_CRIT does not reference any database object
GMA.SY_PURG_DEF_CRIT is referenced by following:
Description: | Stores the database output from the GMA_PURGE_ENGINE package |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_ERR.PURGE_ID | SY_PURG_MST |
Stores the database output from the OPM Purge and Archive utility,
specifically the GMA_PURGE_ENGINE package.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_PURGE_ERR_PK | UNIQUE | APPS_TS_TX_IDX |
PURGE_ID
LINE_NO |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_ID | NUMBER | (5) | Y | Unique identifier for each purge. |
LINE_NO | NUMBER | Y | Line number of error message. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
TEXT | VARCHAR2 | (80) | Error text associated with the purge ID. |
GMA.SY_PURG_ERR does not reference any database object
GMA.SY_PURG_ERR is referenced by following:
Description: | Stores OPM Purge and Archive statistics table by table based on Purge ID. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_LOG.PURGE_ID | SY_PURG_MST |
Stores OPM Purge and Archive statistics table by table based on Purge ID.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_PURGE_LOG_PK | UNIQUE | APPS_TS_TX_IDX |
PURGE_ID
TABLE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_ID | NUMBER | (5) | Y | Unique identifier for each purge. |
TABLE_NAME | VARCHAR2 | (32) | Y | Table that was archived or purged. |
ROWS_ARCHIVED | NUMBER | (10) | Y | Number of rows archived for this purge_id/table. |
ROWS_DELETED | NUMBER | (10) | Y | Number of rows deleted for this purge_id/table. |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
GMA.SY_PURG_LOG does not reference any database object
GMA.SY_PURG_LOG is referenced by following:
Description: | Table storing data of all OPM Archives/Purges that have been run |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_MST.PURGE_TYPE | SY_PURG_DEF |
SY_PURG_MST.TEXT_CODE | SY_TEXT_HDR |
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_ERR.PURGE_ID | SY_PURG_MST |
SY_PURG_LOG.PURGE_ID | SY_PURG_MST |
SY_PURG_MST_CRIT.PURGE_ID | SY_PURG_MST |
Table storing data of all OPM Archives/Purges that have been run
Index | Type | Tablespace | Column |
---|---|---|---|
SY_PURG_MST_PK | UNIQUE | APPS_TS_TX_IDX | PURGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_ID | NUMBER | (5) | Y | Unique identifier for each purge. |
PURGE_TYPE | VARCHAR2 | (4) | Y | Purge Type - the name of the Purge and Archive routine (eg, PROD). |
STATUS | NUMBER | (5) | Y | No longer used. Purge Status used instead. |
PURGE_COMMENT | VARCHAR2 | (256) | User entered purge comment. | |
ROWS_ARCHIVED | NUMBER | (10) | Number of rows archived for this purge_id. | |
ROWS_DELETED | NUMBER | (10) | Number of rows deleted for this purge_id. | |
ARCHIVE_START_TIME | DATE | Date and Time Archive process began. | ||
ARCHIVE_ELAPSED_TIME | NUMBER | (38) | Elapsed time ONLY FOR ARCHIVE (in seconds). | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
ORA_STATUS | NUMBER | Oracle Error message number | ||
PURGE_START_TIME | DATE | Date and Time Purge process began. | ||
PURGE_ELAPSED_TIME | NUMBER | (38) | Elapsed time ONLY FOR PURGE (in seconds). | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SELECTION_ELAPSED_TIME | NUMBER | (38) | Time in seconds for P/A row selection | |
COPY_ELAPSED_TIME | NUMBER | (38) | Time in seconds for copy function | |
ROWS_PER_SECOND | NUMBER | (38) | Rows per second using end to end P/A execution time (includes selection time). | |
COPY_ROWS_PER_SECOND | NUMBER | (38) | Rows per second * just* usin copy time. Probably represents a platform dependent constant. Performance increases as rows_per_second approaches copy_rows_per_second. | |
DEBUG_FLAG | VARCHAR2 | (1) | If set to 'T', adds debuggin information to logged output. Basically, this means that the generated SQL is output for analysis. | |
DISABLE_CONSTRAINTS_FLAG | VARCHAR2 | (1) | If set to 'T', disables constraints as appropriate before the copy function starts and restores them after the end of the ocpy function. 'As appropriate', means that if a table is marked for delete, constraints are disabled. This greatly spedd performance. This requires that the purge definition respects data integrity constraints (as it should be). | |
CALCULATE_STORAGE_FLAG | VARCHAR2 | (1) | If set to 'T', calcuates the size of target tables before the copy function and attempts to allocate the entire space. Failure to do so will *not* stop archiver; archiver will then just use 'standard' method. | |
COMMIT_FREQUENCY | NUMBER | Store value that designates how often to commit. Advanced users may find that this settin affects copy_rows_per_second. Defaults to 1000 if not specified. | ||
PURGE_STATUS | NUMBER | (5) | Y | 0= Defined, not yet run. 1= Archive in progress. 2= Archived Successfully. 3= Purge in progress. 4= Purge Completed Successfully. -1= Archive process failed. -3=Purge process failed. |
OBJECT_OWNER | VARCHAR2 | (30) | The name of the Product that owns the purged object. | |
ARCHIVE_TABLE_COUNT | NUMBER | Count of tables to be archived. |
GMA.SY_PURG_MST does not reference any database object
GMA.SY_PURG_MST is referenced by following:
Description: | OPM Purge and Archive table used to store the criteria entered specific to a Purge ID. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_MST_CRIT.PURGE_ID | SY_PURG_MST |
SY_PURG_MST_CRIT.TEXT_CODE | SY_TEXT_HDR |
OPM Purge and Archive table used to store the criteria entered specific to a Purge ID.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_PURG_MST_CRIT_PK | UNIQUE | APPS_TS_TX_IDX |
PURGE_ID
CRIT_TAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_ID | NUMBER | (5) | Y | Unique identifier for each purge. |
CRIT_TAG | VARCHAR2 | (32) | Y | Criteria tag. Serves as a placeholder where selection criteria will be entered. |
CRIT_VALUE | VARCHAR2 | (64) | Y | User entered value against criteria tag for this purge_id. |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
GMA.SY_PURG_MST_CRIT does not reference any database object
GMA.SY_PURG_MST_CRIT is referenced by following:
Description: | The Reason Code table is used to store Reason Code definitions which provide information on the increase or decrease in inventory. Reason codes are used to flag transactions and attach reasons to them. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_REAS_CDS_B.TEXT_CODE | SY_TEXT_HDR |
Foreign Key Column | Foreign Table |
---|---|
GL_ACCT_MAP.REASON_CODE | SY_REAS_CDS_B |
GMP_RSRC_EXCP_DTL.REASON_CODE | SY_REAS_CDS_B |
GMP_RSRC_UNAVAIL_MAN.REASON_CODE | SY_REAS_CDS_B |
IC_ADJS_JNL.REASON_CODE | SY_REAS_CDS_B |
IC_PHYS_CNT.REASON_CODE | SY_REAS_CDS_B |
IC_TRAN_ARC.REASON_CODE | SY_REAS_CDS_B |
IC_TRAN_CMP.REASON_CODE | SY_REAS_CDS_B |
IC_TRAN_PND.REASON_CODE | SY_REAS_CDS_B |
IC_XFER_MST.RELEASE_REASON_CODE | SY_REAS_CDS_B |
IC_XFER_MST.RECEIVE_REASON_CODE | SY_REAS_CDS_B |
IC_XFER_MST.CANCEL_REASON_CODE | SY_REAS_CDS_B |
OP_ORDR_DTL.CHANGEREAS_CODE | SY_REAS_CDS_B |
OP_ORDR_HDR.CHANGEREAS_CODE | SY_REAS_CDS_B |
PC_TRAN_PND.REASON_CODE | SY_REAS_CDS_B |
PO_BPOS_DTL.BPOHOLD_CODE | SY_REAS_CDS_B |
PO_BPOS_DTL.CANCELLATION_CODE | SY_REAS_CDS_B |
PO_BPOS_DTL.CLOSURE_CODE | SY_REAS_CDS_B |
PO_BPOS_HDR.BPOHOLD_CODE | SY_REAS_CDS_B |
PO_BPOS_HDR.CANCELLATION_CODE | SY_REAS_CDS_B |
PO_BPOS_HDR.CLOSURE_CODE | SY_REAS_CDS_B |
PO_ORDR_DTL.POHOLD_CODE | SY_REAS_CDS_B |
PO_ORDR_DTL.CANCELLATION_CODE | SY_REAS_CDS_B |
PO_ORDR_HDR.POHOLD_CODE | SY_REAS_CDS_B |
PO_ORDR_HDR.CANCELLATION_CODE | SY_REAS_CDS_B |
PO_RECV_HDR.REASON_CODE | SY_REAS_CDS_B |
PO_RTRN_DTL.RETURN_CODE | SY_REAS_CDS_B |
The Reason Code table is used to store Reason Code definitions which provide information on the increase or decrease in inventory. Reason codes are used to flag transactions and attach reasons to them.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_REAS_CDS_B_PK | UNIQUE | APPS_TS_SEED | REASON_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REASON_CODE | VARCHAR2 | (4) | Y | Reason code. |
REASON_DESC1 | VARCHAR2 | (40) | Description of the reason code. | |
REASON_DESC2 | VARCHAR2 | (70) | Description of the reason code (not used). | |
REASON_TYPE | NUMBER | (5) | Y | Indicates change type for the reason. |
FLOW_TYPE | NUMBER | (5) | Y | Indicates inventory flow. -1=inflow; 1=outflow; 0=usage; 2=exclude. |
AUTH_STRING | VARCHAR2 | (90) | Unused. | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 | |
REASON_ID | NUMBER | (15) | 'DIscrete Reason ID equivalent to the Reason Code' |
GMA.SY_REAS_CDS_B does not reference any database object
GMA.SY_REAS_CDS_B is referenced by following:
Description: | Translations table table holding OPM reason code descriptions in multiple languages |
---|
Translations table table holding OPM reason code descriptions in multiple languages
Index | Type | Tablespace | Column |
---|---|---|---|
SY_REAS_CDS_TL_PK | NONUNIQUE | APPS_TS_SEED |
REASON_CODE
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REASON_CODE | VARCHAR2 | (4) | Y | Reason code. |
LANGUAGE | VARCHAR2 | (4) | Y | Language |
SOURCE_LANG | VARCHAR2 | (4) | Y | Source Language |
REASON_DESC1 | VARCHAR2 | (40) | Y | Description of the reason code. |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 |
GMA.SY_REAS_CDS_TL does not reference any database object
GMA.SY_REAS_CDS_TL is referenced by following:
Description: | Master table for creation and storage of OPM text codes associated with GMA tables. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_PURG_DEF_CRIT.TEXT_CODE | SY_TEXT_HDR |
SY_DOCS_MST.TEXT_CODE | SY_TEXT_HDR |
SY_DOCS_SEQ.TEXT_CODE | SY_TEXT_HDR |
SY_GEOG_MST.TEXT_CODE | SY_TEXT_HDR |
SY_ORGN_MST_B.TEXT_CODE | SY_TEXT_HDR |
SY_ORGN_MST.TEXT_CODE | SY_TEXT_HDR |
SY_PURG_MST_CRIT.TEXT_CODE | SY_TEXT_HDR |
SY_PURG_DEF_ACT.TEXT_CODE | SY_TEXT_HDR |
SY_PURG_DEF.TEXT_CODE | SY_TEXT_HDR |
SY_PURG_MST.TEXT_CODE | SY_TEXT_HDR |
SY_REAS_CDS_B.TEXT_CODE | SY_TEXT_HDR |
SY_REAS_CDS.TEXT_CODE | SY_TEXT_HDR |
SY_TEXT_TKN_TL.TEXT_CODE | SY_TEXT_HDR |
SY_UOMS_MST.TEXT_CODE | SY_TEXT_HDR |
SY_UOMS_TYP.TEXT_CODE | SY_TEXT_HDR |
Master table for creation and storage of OPM text codes associated with GMA tables.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_TEXT_HDR_PK | UNIQUE | APPS_TS_TX_IDX | TEXT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEXT_CODE | NUMBER | (10) | Y | Surrogate key for this record. ID which joins any rows of text in this table to the Text Table for this Module |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
GMA.SY_TEXT_HDR does not reference any database object
GMA.SY_TEXT_HDR is referenced by following:
Description: | GMA product Text Lines (OPM System Administration). Descriptive text for all tables in this module. Also storesText Token text. |
---|
GMA product Text Lines (OPM System Administration). Descriptive text for all tables in this module. Also storesText Token text.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_TEXT_TBL_TL_PK | UNIQUE | APPS_TS_TX_IDX |
TEXT_CODE
LANG_CODE PARAGRAPH_CODE SUB_PARACODE LINE_NO LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEXT_CODE | NUMBER | (10) | Y | ID which joins any rows of text in this table to the Text Table for this Module |
LANG_CODE | VARCHAR2 | (4) | Y | Indicates language used in text. |
PARAGRAPH_CODE | VARCHAR2 | (4) | Y | Defined in sy_para_cds. |
SUB_PARACODE | NUMBER | (5) | Y | Defined in sy_para_cds. |
LINE_NO | NUMBER | (5) | Y | Line number which allows multiple lines of descripitive text for underlying record. -1 = line is used to recreate key of underlying record; 1 <= descriptive text. |
TEXT | VARCHAR2 | (70) | Descriptive text. | |
LANGUAGE | VARCHAR2 | (4) | Y | The value stored in this column represents the Language in which the data will be displayed. |
SOURCE_LANG | VARCHAR2 | (4) | Y | The Language the text will mirror. If text is not yet translated into LANGUAGE thenany changes to the text in the source language row will be reflected here as well. |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
GMA.SY_TEXT_TBL_TL does not reference any database object
GMA.SY_TEXT_TBL_TL is referenced by following:
Description: | Stores OPM Text Token definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_TEXT_TKN_TL.TEXT_CODE | SY_TEXT_HDR |
Stores OPM Text Token definitions
Index | Type | Tablespace | Column |
---|---|---|---|
SY_TEXT_TKN_TL_PK | UNIQUE | APPS_TS_TX_IDX |
TEXT_KEY
LANG_CODE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEXT_KEY | VARCHAR2 | (32) | Y | Text Token Name |
LANG_CODE | VARCHAR2 | (4) | Y | Indicates language used in text. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
TOKEN_DESC | VARCHAR2 | (70) | Y | Description of the Text token. |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 | |
LANGUAGE | VARCHAR2 | (4) | Y | The value stored in this column represents the Language in which the data will be displayed. |
SOURCE_LANG | VARCHAR2 | (4) | Y | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
GMA.SY_TEXT_TKN_TL does not reference any database object
GMA.SY_TEXT_TKN_TL is referenced by following:
Description: | Used to store the detail information about theTriggers responsible for Starting the Workflows and their Status ( Enabled, Disabled ) of the individual triggers. |
---|
Used to store the detail information about theTriggers responsible for Starting the Workflows and their Status ( Enabled, Disabled ) of the individual triggers.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_TRIGGER_ACTIVATION_WF_PK | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
TRIGGER_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WF_ITEM_TYPE | VARCHAR2 | (8) | Y | Workflow Item Type |
WF_DESCRIPTION | VARCHAR2 | (80) | Y | Workflow description |
TRIGGER_NAME | VARCHAR2 | (30) | Y | Trigger responsible for the workflow |
TRIGGER_DESCRIPTION | VARCHAR2 | (40) | Y | Trigger description |
ENABLE_FLAG | NUMBER | (5) | Y | Indicates whether the trigger is enabled or not. |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column |
GMA.SY_TRIGGER_ACTIVATION_WF does not reference any database object
GMA.SY_TRIGGER_ACTIVATION_WF is referenced by following:
Description: | Table for associating Units of Measure and UOM Types. Not yet used. |
---|
Foreign Key Column | Foreign Table |
---|---|
SY_UOMS_STD.UM_TYPE | SY_UOMS_TYP |
SY_UOMS_STD.UM_CODE | SY_UOMS_MST |
Table for associating Units of Measure and UOM Types. Not yet used.
Index | Type | Tablespace | Column |
---|---|---|---|
SY_UOMS_STD_PK | UNIQUE | APPS_TS_TX_IDX | UM_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UM_TYPE | VARCHAR2 | (4) | Y | The Unit of Measure Type associated with each Unit of Measure |
UM_CODE | VARCHAR2 | (4) | Y | Unit of Measure code for which the conversion is defined. |
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 |
GMA.SY_UOMS_STD does not reference any database object
GMA.SY_UOMS_STD is referenced by following:
A public view which may be useful for custom reporting or other data requirements.
View of all tables owned by OPM
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_NAME | VARCHAR2 | (30) | Y | Table Name |
APPS.GEMMS_TABLES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View of all OPM Lookups
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Y | lookup type |
LOOKUP_CODE | VARCHAR2 | (30) | Y | lookup code |
MEANING | VARCHAR2 | (80) | Y | value meaning |
DESCRIPTION | VARCHAR2 | (240) | value description | |
ENABLED_FLAG | VARCHAR2 | (1) | Y | enabled flag |
START_DATE_ACTIVE | DATE | start active date | ||
END_DATE_ACTIVE | DATE | end active date |
MultiLingual view (a language resolved view of the data.)
This View will be the Used to fetch the data for Column prompt.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
ACTIVITY_ID | NUMBER | (10) | Y | |
COLUMN_HIERARCHY | NUMBER | (3) | ||
TABLE_NAME | VARCHAR2 | (100) | Y | |
COLUMN_NAME | VARCHAR2 | (32) | Y | |
LOV_TABLE | VARCHAR2 | (100) | Y | |
LOV_COLUMN | VARCHAR2 | (200) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
COLUMN_PROMPT | VARCHAR2 | (40) | Y |
APPS.GMA_ACTCOL_WF_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View on columns from GMA_MIGRATION_CONTROL, GMA_MIGRATION_LOG, FND_NEW_MESSAGES.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MIG_NAME | VARCHAR2 | (80) | Y | Migration name |
RUN_ID | NUMBER | The Unique Run ID for the migration run. | ||
TABLE_NAME | VARCHAR2 | (80) | The table being migrated | |
MESSAGE_TOKEN | VARCHAR2 | (80) | Y | FND Message Token |
MESSAGE_TYPE | VARCHAR2 | (2) | Y | The category of the message |
MESSAGE_TEXT | VARCHAR2 | (4000) | Actual message | |
TIMESTAMP | DATE | Time of message | ||
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | Application that logged the message |
CONTEXT | VARCHAR2 | (80) | Context of migration when the message was logged | |
LINE_NO | NUMBER | Line Number Identifier |
APPS.GMA_MIGRATION_LOG_V1 is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
GMA View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
WF_ITEM_TYPE | VARCHAR2 | (8) | Y | |
PROCESS_NAME | VARCHAR2 | (30) | Y | |
COLUMN_HIERARCHY | NUMBER | (3) | Y | |
TABLE_NAME | VARCHAR2 | (100) | Y | |
COLUMN_NAME | VARCHAR2 | (32) | Y | |
LOV_TABLE | VARCHAR2 | (100) | Y | |
LOV_COLUMN | VARCHAR2 | (200) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
COLUMN_PROMPT | VARCHAR2 | (40) | Y |
APPS.GMA_PROCCOL_WF_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View of sy_addr_mst for OPM OF customers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDR_ID | NUMBER | id uniquely identifying an address. | ||
ADDR1 | VARCHAR2 | (240) | First line of the address. | |
ADDR2 | VARCHAR2 | (240) | Second line of the address. | |
ADDR3 | VARCHAR2 | (240) | Third line of the address. | |
ADDR4 | VARCHAR2 | (70) | Forth line of the address. | |
STATE_CODE | VARCHAR2 | (120) | State code of the address. | |
COUNTRY_CODE | VARCHAR2 | (60) | Country code of the address. | |
POSTAL_CODE | VARCHAR2 | (30) | Postal code of the address. |
APPS.SY_ADDR_MST_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View of ADDR_ID + first two lines of the address
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDR_ID | NUMBER | (10) | Y | Surrogate id uniquely identifying an address. |
ADDR_DISPLAY1 | VARCHAR2 | (70) | First line of the address. | |
ADDR_DISPLAY2 | VARCHAR2 | (70) | Second line of the address. |
APPS.SY_ADDR_MST_VW1 is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Organization Master View to setup the data
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORGN_CODE | VARCHAR2 | (4) | Y | |
PARENT_ORGN_CODE | VARCHAR2 | (4) | Y | |
CO_CODE | VARCHAR2 | (4) | Y | |
PLANT_IND | NUMBER | (5) | Y | |
ADDR_ID | NUMBER | (10) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
TAXLOC_CODE | VARCHAR2 | (10) | ||
TEXT_CODE | NUMBER | (10) | ||
DELETE_MARK | NUMBER | (5) | Y | |
TRANS_CNT | NUMBER | (10) | Y | |
POC_IND | NUMBER | (5) | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
RESOURCE_WHSE_CODE | VARCHAR2 | (4) | ||
SY_ORGN_MST_ORGN_CODE | VARCHAR2 | (4) | ||
SY_ORGN_MST_DOC_TYPE | VARCHAR2 | (4) | ||
MFG_CALENDAR_ID | NUMBER | |||
ATTRIBUTE1 | VARCHAR2 | (240) | ||
ATTRIBUTE2 | VARCHAR2 | (240) | ||
ATTRIBUTE3 | VARCHAR2 | (240) | ||
ATTRIBUTE4 | VARCHAR2 | (240) | ||
ATTRIBUTE5 | VARCHAR2 | (240) | ||
ATTRIBUTE6 | VARCHAR2 | (240) | ||
ATTRIBUTE7 | VARCHAR2 | (240) | ||
ATTRIBUTE8 | VARCHAR2 | (240) | ||
ATTRIBUTE9 | VARCHAR2 | (240) | ||
ATTRIBUTE10 | VARCHAR2 | (240) | ||
ATTRIBUTE11 | VARCHAR2 | (240) | ||
ATTRIBUTE12 | VARCHAR2 | (240) | ||
ATTRIBUTE13 | VARCHAR2 | (240) | ||
ATTRIBUTE14 | VARCHAR2 | (240) | ||
ATTRIBUTE15 | VARCHAR2 | (240) | ||
ATTRIBUTE16 | VARCHAR2 | (240) | ||
ATTRIBUTE17 | VARCHAR2 | (240) | ||
ATTRIBUTE18 | VARCHAR2 | (240) | ||
ATTRIBUTE19 | VARCHAR2 | (240) | ||
ATTRIBUTE20 | VARCHAR2 | (240) | ||
ATTRIBUTE21 | VARCHAR2 | (240) | ||
ATTRIBUTE22 | VARCHAR2 | (240) | ||
ATTRIBUTE23 | VARCHAR2 | (240) | ||
ATTRIBUTE24 | VARCHAR2 | (240) | ||
ATTRIBUTE25 | VARCHAR2 | (240) | ||
ATTRIBUTE26 | VARCHAR2 | (240) | ||
ATTRIBUTE27 | VARCHAR2 | (240) | ||
ATTRIBUTE28 | VARCHAR2 | (240) | ||
ATTRIBUTE29 | VARCHAR2 | (240) | ||
ATTRIBUTE30 | VARCHAR2 | (240) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ORGN_NAME | VARCHAR2 | (40) | Y | |
MIGRATE_AS_IND | NUMBER | (5) | ||
ACTIVE_IND | NUMBER | (5) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
INVENTORY_ORG_IND | VARCHAR2 | (1) | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
TEMPLATE_ORGANIZATION_ID | NUMBER | (15) | ||
PROCESS_ENABLED_IND | VARCHAR2 | (1) | ||
REGULATORY_ORG_IND | VARCHAR2 | (1) | ||
MIGRATED_IND | NUMBER | (5) | ||
MASTER_ORGANIZATION_ID | NUMBER | (15) | ||
DEFAULT_STATUS | VARCHAR2 | (4) | Default status is added for R12.1 migration |
MultiLingual view (a language resolved view of the data.)
View of all paragraph codes in SY_PARA_CDS_TL .
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
TABLE_NAME | VARCHAR2 | (32) | Y | |
LANG_CODE | VARCHAR2 | (4) | Y | |
PARAGRAPH_CODE | VARCHAR2 | (4) | Y | |
SUB_PARACODE | NUMBER | (5) | Y | |
NONPRINTABLE_IND | NUMBER | (5) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PARA_DESC | VARCHAR2 | (255) | Y |
APPS.SY_PARA_CDS_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
MLS enabled view of OPM Reason Codes.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
REASON_CODE | VARCHAR2 | (4) | Y | Reason code. |
REASON_DESC2 | VARCHAR2 | (70) | ||
REASON_TYPE | NUMBER | (5) | Y | Indicates change type for the reason. |
FLOW_TYPE | NUMBER | (5) | Y | Indicates Inventory flow. -1=inflow; 1=outflow; 0=usage; 2=exclude. |
AUTH_STRING | VARCHAR2 | (90) | Unused. | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module. | |
TRANS_CNT | NUMBER | (10) | Standard: program flag to control locking. | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
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 | |
REASON_DESC1 | VARCHAR2 | (40) | Y | Description of Reason Code. |
MultiLingual view (a language resolved view of the data.)
View of all the Descriptive text in SY_TEXT_TBL_TL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique row identifier | |
TEXT_CODE | NUMBER | (10) | Y | ID which joins any rows of text in this table to the Text Table for this Module |
LANG_CODE | VARCHAR2 | (4) | Y | Language code for the text |
PARAGRAPH_CODE | VARCHAR2 | (4) | Y | Paragraph code for the text |
SUB_PARACODE | NUMBER | (5) | Y | Sub Paragraph code fo the text |
LINE_NO | NUMBER | (5) | Y | Line number of text |
TEXT | VARCHAR2 | (70) | Text entered by user | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Row Who Column |
CREATED_BY | NUMBER | (15) | Y | Standard Row Who Column |
LAST_UPDATE_DATE | DATE | Y | Standard Row Who Column | |
CREATION_DATE | DATE | Y | Standard Row Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Row Who Column |
APPS.SY_TEXT_TBL_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View of all Text Tokens in SY_TEXT_TKN_TL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
TEXT_KEY | VARCHAR2 | (32) | Y | |
LANG_CODE | VARCHAR2 | (4) | Y | |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
TOKEN_DESC | VARCHAR2 | (70) | Y |
APPS.SY_TEXT_TKN_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View of unit of measure master
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UM_CODE | VARCHAR2 | (25) | Unit of Measure code | |
UM_DESC | VARCHAR2 | (40) | Unit of Measure description | |
UM_TYPE | VARCHAR2 | (10) | Y | Unit of Measure type |
STD_FACTOR | NUMBER | Standard factor | ||
UNIT_OF_MEASURE | VARCHAR2 | (25) | Y | Unit of Measure |
UOM_CODE | VARCHAR2 | (3) | Y | Unit of Measure code |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
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 | |
DELETE_MARK | NUMBER | Standard delete mark | ||
TEXT_CODE | NUMBER | Text code | ||
RND_FACTOR | NUMBER | rnd factor | ||
REF_UM | VARCHAR2 | (0) | Reference unit of measure | |
TRANS_CNT | NUMBER | transaction count |
A public view which may be useful for custom reporting or other data requirements.
View of unit of measure types
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UM_TYPE | VARCHAR2 | (10) | Y | UOM Type |
TYPE_DESC | VARCHAR2 | (40) | Type of UOM | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
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 | |
DELETE_MARK | NUMBER | Standard delete mark | ||
TEXT_CODE | NUMBER | Text code | ||
TRANS_CNT | NUMBER | Transaction count | ||
STD_UM | VARCHAR2 | (25) | Standard UOM |
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |