Oracle eBusiness Suite Technical Reference

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

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

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

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

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

eTRM - GMA Tables and Views

TABLE - GMA.GMA_ACTCOL_WF_B
TABLE - GMA.GMA_ACTCOL_WF_TL
TABLE - GMA.GMA_ACTDATA_WF
TABLE - GMA.GMA_ACTDEF_WF
TABLE - GMA.GMA_AUDIT_DISP_COLS
TABLE - GMA.GMA_AUDIT_LKUPS
TABLE - GMA.GMA_AUDIT_REP_DTL
TABLE - GMA.GMA_AUDIT_REP_HDR
TABLE - GMA.GMA_AUDIT_TMPLT_DTL
TABLE - GMA.GMA_AUDIT_TMPLT_MST
TABLE - GMA.GMA_MIGRATION_CONTROL
TABLE - GMA.GMA_MIGRATION_LOG
TABLE - GMA.GMA_PROCCOL_WF_B
TABLE - GMA.GMA_PROCCOL_WF_TL
TABLE - GMA.GMA_PROCDATA_WF
TABLE - GMA.GMA_PROCDEF_WF
TABLE - GMA.GMA_REASON_CODE_SECURITY
TABLE - GMA.SY_ADDR_MST
TABLE - GMA.SY_CMPY_MST
TABLE - GMA.SY_DOCS_MST
TABLE - GMA.SY_DOCS_SEQ
TABLE - GMA.SY_GEOG_MST
TABLE - GMA.SY_ORGN_MST_B
TABLE - GMA.SY_ORGN_MST_TL
TABLE - GMA.SY_ORGN_USR
TABLE - GMA.SY_PARA_CDS_TL
TABLE - GMA.SY_PURG_DEF
TABLE - GMA.SY_PURG_DEF_ACT
TABLE - GMA.SY_PURG_DEF_CRIT
TABLE - GMA.SY_PURG_ERR
TABLE - GMA.SY_PURG_LOG
TABLE - GMA.SY_PURG_MST
TABLE - GMA.SY_PURG_MST_CRIT
TABLE - GMA.SY_REAS_CDS_B
TABLE - GMA.SY_REAS_CDS_TL
TABLE - GMA.SY_TEXT_HDR
TABLE - GMA.SY_TEXT_TBL_TL
TABLE - GMA.SY_TEXT_TKN_TL
TABLE - GMA.SY_TRIGGER_ACTIVATION_WF
TABLE - GMA.SY_UOMS_STD
VIEW - APPS.GEMMS_TABLES
VIEW - APPS.GEM_LOOKUPS
VIEW - APPS.GMA_ACTCOL_WF_VL
VIEW - APPS.GMA_MIGRATION_LOG_V1
VIEW - APPS.GMA_PROCCOL_WF_VL
VIEW - APPS.SY_ADDR_MST_V
VIEW - APPS.SY_ADDR_MST_VW1
VIEW - APPS.SY_ORGN_MST_VL
VIEW - APPS.SY_PARA_CDS_VL
VIEW - APPS.SY_REAS_CDS_VL
VIEW - APPS.SY_TEXT_TBL_VL
VIEW - APPS.SY_TEXT_TKN_VL
VIEW - APPS.SY_UOMS_MST_V
VIEW - APPS.SY_UOMS_TYP_V

Table: GMA_ACTCOL_WF_B

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
Primary Key: GMA_ACTCOL_WF_B_PK
  1. ACTIVITY_ID
  2. TABLE_NAME
  3. COLUMN_NAME
Primary Key: GMA_ACTCOL_WF_B_UK
  1. ACTIVITY_ID
  2. COLUMN_HIERARCHY
Comments

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.

Indexes
Index Type Tablespace Column
GMA_ACTCOL_WF_B_PK UNIQUE APPS_TS_SEED ACTIVITY_ID
TABLE_NAME
COLUMN_NAME
GMA_ACTCOL_WF_B_UK UNIQUE APPS_TS_SEED ACTIVITY_ID
COLUMN_HIERARCHY
Columns
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

[top of page]

GMA.GMA_ACTCOL_WF_B does not reference any database object

GMA.GMA_ACTCOL_WF_B is referenced by following:

APPS
SYNONYM - GMA_ACTCOL_WF_B

[top of page]

Table: GMA_ACTCOL_WF_TL

Description: Checks the availability of Activity Identification in GMA_ACTDEF_WF before inserting a row in GMA_ACTCOL_WF
Primary Key: GMA_ACTCOL_WF_TL_UK
  1. ACTIVITY_ID
  2. TABLE_NAME
  3. COLUMN_NAME
  4. LANGUAGE
Comments

Checks the availability of Activity Identification in GMA_ACTDEF_WF before inserting a row in GMA_ACTCOL_WF

Indexes
Index Type Tablespace Column
GMA_ACTCOL_WF_TL_UK UNIQUE APPS_TS_SEED ACTIVITY_ID
TABLE_NAME
COLUMN_NAME
LANGUAGE
Columns
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

[top of page]

GMA.GMA_ACTCOL_WF_TL does not reference any database object

GMA.GMA_ACTCOL_WF_TL is referenced by following:

APPS
SYNONYM - GMA_ACTCOL_WF_TL

[top of page]

Table: GMA_ACTDATA_WF

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.
Primary Key: GMA_ACTDATA_WF_UK
  1. ACTIVITY_ID
  2. COLUMN_VALUE1
  3. COLUMN_VALUE2
  4. COLUMN_VALUE3
  5. COLUMN_VALUE4
  6. COLUMN_VALUE5
  7. COLUMN_VALUE6
  8. COLUMN_VALUE7
  9. COLUMN_VALUE8
  10. COLUMN_VALUE9
  11. COLUMN_VALUE10
Comments

This table will contain the actual data of the role association .User Role association with specific set of data is stored in this table.

Indexes
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
Columns
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

[top of page]

GMA.GMA_ACTDATA_WF does not reference any database object

GMA.GMA_ACTDATA_WF is referenced by following:

APPS
SYNONYM - GMA_ACTDATA_WF

[top of page]

Table: GMA_ACTDEF_WF

Description: This table is used to define the activity where a role has to be
Primary Key: GMA_ACTDEF_WF_PK
  1. ACTIVITY_ID
Primary Key: GMA_ACTDEF_WF_UK
  1. WF_ITEM_TYPE
  2. PROCESS_NAME
  3. ACTIVITY_NAME
Comments

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.

Indexes
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
Columns
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

[top of page]

GMA.GMA_ACTDEF_WF does not reference any database object

GMA.GMA_ACTDEF_WF is referenced by following:

APPS
SYNONYM - GMA_ACTDEF_WF

[top of page]

Table: GMA_AUDIT_DISP_COLS

Description: This table is to store Display columns for Shown on Audit Query Navigator
Primary Key: GMA_AUDIT_DISP_COLS_PK
  1. APPLICATION_ID
  2. TABLE_ID
Comments

This table is to store Display columns for Shown on Audit Query Navigator

Indexes
Index Type Tablespace Column
GMA_AUDIT_DISP_COLS_PK UNIQUE APPS_TS_ARCHIVE APPLICATION_ID
TABLE_ID
Columns
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

[top of page]

GMA.GMA_AUDIT_DISP_COLS does not reference any database object

GMA.GMA_AUDIT_DISP_COLS is referenced by following:

APPS
SYNONYM - GMA_AUDIT_DISP_COLS

[top of page]

Table: GMA_AUDIT_LKUPS

Description: This table is to store Lookup Type information to show decoded column values in Audit Query Navigator form
Primary Key: GMA_AUDIT_LKUPS_P
  1. TABLE_APP_ID
  2. AUDIT_TABLE_ID
  3. AUDIT_COLUMN_ID
Comments

This table is to store Lookup Type information to show decoded column values in Audit Query Navigator form

Indexes
Index Type Tablespace Column
GMA_AUDIT_LKUPS_P UNIQUE APPS_TS_ARCHIVE TABLE_APP_ID
AUDIT_TABLE_ID
AUDIT_COLUMN_ID
Columns
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

[top of page]

GMA.GMA_AUDIT_LKUPS does not reference any database object

GMA.GMA_AUDIT_LKUPS is referenced by following:

APPS
SYNONYM - GMA_AUDIT_LKUPS

[top of page]

Table: GMA_AUDIT_REP_DTL

Description: This table is for Audit Trail Reporting. Data in this table is Temporary in nature
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
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)

[top of page]

GMA.GMA_AUDIT_REP_DTL does not reference any database object

GMA.GMA_AUDIT_REP_DTL is referenced by following:

APPS
SYNONYM - GMA_AUDIT_REP_DTL

[top of page]

Table: GMA_AUDIT_REP_HDR

Description: This table is for Audit Trail Reporting. Data in this table is Temporary in nature
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
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)

[top of page]

GMA.GMA_AUDIT_REP_HDR does not reference any database object

GMA.GMA_AUDIT_REP_HDR is referenced by following:

APPS
SYNONYM - GMA_AUDIT_REP_HDR

[top of page]

Table: GMA_AUDIT_TMPLT_DTL

Description: This table is to store relation between Industry Templates and Audit Groups
Primary Key: GMA_AUDIT_TMPLT_DTL_PK
  1. TEMPLATE_NAME
  2. AUDIT_GROUP_ID
  3. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMA_AUDIT_TMPLT_DTL.TEMPLATE_NAME GMA_AUDIT_TMPLT_MST
Comments

This table is to store relation between Industry Templates and Audit Groups

Indexes
Index Type Tablespace Column
GMA_AUDIT_TMPLT_DTL_PK UNIQUE APPS_TS_ARCHIVE TEMPLATE_NAME
AUDIT_GROUP_ID
APPLICATION_ID
Columns
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

[top of page]

GMA.GMA_AUDIT_TMPLT_DTL does not reference any database object

GMA.GMA_AUDIT_TMPLT_DTL is referenced by following:

APPS
SYNONYM - GMA_AUDIT_TMPLT_DTL

[top of page]

Table: GMA_AUDIT_TMPLT_MST

Description: This table is to store Industry Templates
Primary Key: GMA_AUDIT_TMPLT_MST_PK
  1. TEMPLATE_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMA_AUDIT_TMPLT_DTL.TEMPLATE_NAME GMA_AUDIT_TMPLT_MST
Comments

This table is to store Industry Templates

Indexes
Index Type Tablespace Column
GMA_AUDIT_TMPLT_MST_PK UNIQUE APPS_TS_ARCHIVE TEMPLATE_NAME
Columns
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

[top of page]

GMA.GMA_AUDIT_TMPLT_MST does not reference any database object

GMA.GMA_AUDIT_TMPLT_MST is referenced by following:

APPS
SYNONYM - GMA_AUDIT_TMPLT_MST

[top of page]

Table: GMA_MIGRATION_CONTROL

Description: TO TRACK MIGRATION ERRORS
Comments

TO TRACK MIGRATION ERRORS

Indexes
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
Columns
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

[top of page]

GMA.GMA_MIGRATION_CONTROL does not reference any database object

GMA.GMA_MIGRATION_CONTROL is referenced by following:

APPS
SYNONYM - GMA_MIGRATION_CONTROL

[top of page]

Table: GMA_MIGRATION_LOG

Description: TO TRACK MIGRATION ERRORS
Comments

TO TRACK MIGRATION ERRORS

Indexes
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
Columns
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

[top of page]

GMA.GMA_MIGRATION_LOG does not reference any database object

GMA.GMA_MIGRATION_LOG is referenced by following:

APPS
SYNONYM - GMA_MIGRATION_LOG

[top of page]

Table: GMA_PROCCOL_WF_B

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.
Primary Key: GMA_PROCCOL_WF_B_PK
  1. WF_ITEM_TYPE
  2. PROCESS_NAME
  3. TABLE_NAME
  4. COLUMN_NAME
Primary Key: GMA_PROCCOL_WF_B_UK
  1. WF_ITEM_TYPE
  2. PROCESS_NAME
  3. COLUMN_HIERARCHY
Comments

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.

Indexes
Index Type Tablespace Column
GMA_PROCCOL_WF_B_PK UNIQUE APPS_TS_SEED WF_ITEM_TYPE
PROCESS_NAME
TABLE_NAME
COLUMN_NAME
GMA_PROCCOL_WF_B_UK UNIQUE APPS_TS_SEED WF_ITEM_TYPE
PROCESS_NAME
COLUMN_HIERARCHY
Columns
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

[top of page]

GMA.GMA_PROCCOL_WF_B does not reference any database object

GMA.GMA_PROCCOL_WF_B is referenced by following:

APPS
SYNONYM - GMA_PROCCOL_WF_B

[top of page]

Table: GMA_PROCCOL_WF_TL

Description: This table contains translated column prompts and provides multi-lingueal support.
Primary Key: GMA_PROCCOL_WF_TL_PK
  1. WF_ITEM_TYPE
  2. PROCESS_NAME
  3. TABLE_NAME
  4. COLUMN_NAME
  5. LANGUAGE
Comments

This table contains translated column prompts and provides multi-lingueal support.

Indexes
Index Type Tablespace Column
GMA_PROCCOL_WF_TL_PK UNIQUE APPS_TS_SEED WF_ITEM_TYPE
PROCESS_NAME
TABLE_NAME
COLUMN_NAME
LANGUAGE
Columns
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

[top of page]

GMA.GMA_PROCCOL_WF_TL does not reference any database object

GMA.GMA_PROCCOL_WF_TL is referenced by following:

APPS
SYNONYM - GMA_PROCCOL_WF_TL

[top of page]

Table: GMA_PROCDATA_WF

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.
Primary Key: GMA_PROCDATA_WF_UK
  1. WF_ITEM_TYPE
  2. PROCESS_NAME
  3. COLUMN_VALUE1
  4. COLUMN_VALUE2
  5. COLUMN_VALUE3
  6. COLUMN_VALUE4
  7. COLUMN_VALUE5
  8. COLUMN_VALUE6
  9. COLUMN_VALUE7
  10. COLUMN_VALUE8
  11. COLUMN_VALUE9
  12. COLUMN_VALUE10
Comments

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.

Indexes
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
Columns
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

[top of page]

GMA.GMA_PROCDATA_WF does not reference any database object

GMA.GMA_PROCDATA_WF is referenced by following:

APPS
SYNONYM - GMA_PROCDATA_WF

[top of page]

Table: GMA_PROCDEF_WF

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.
Primary Key: GMA_PROCDEF_WF_PK
  1. WF_ITEM_TYPE
  2. PROCESS_NAME
Comments

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.

Indexes
Index Type Tablespace Column
GMA_PROCDEF_WF_PK UNIQUE APPS_TS_SEED WF_ITEM_TYPE
PROCESS_NAME
Columns
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

[top of page]

GMA.GMA_PROCDEF_WF does not reference any database object

GMA.GMA_PROCDEF_WF is referenced by following:

APPS
SYNONYM - GMA_PROCDEF_WF

[top of page]

Table: GMA_REASON_CODE_SECURITY

Description: Reason Code Security Table
Primary Key: GMA_REASON_CODE_SECURITY_U1
  1. REASON_CODE
  2. DOC_TYPE
  3. RESPONSIBILITY_ID
Comments

This table is used with Reason Code Security to allow OPM users to associate security to reason codes by document type and user responsibility.

Indexes
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
Columns
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

[top of page]

GMA.GMA_REASON_CODE_SECURITY does not reference any database object

GMA.GMA_REASON_CODE_SECURITY is referenced by following:

APPS
SYNONYM - GMA_REASON_CODE_SECURITY

[top of page]

Table: SY_ADDR_MST

Description: OPM Address master. Table which stores addresses for all Oracle Process
Primary Key: SY_ADDR_MST_PK
  1. ADDR_ID
Foreign Keys to this table:
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
Comments

OPM Address master. Table which stores addresses for all Oracle Process
Manufacturing applications entities.

Columns
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

[top of page]

GMA.SY_ADDR_MST does not reference any database object

GMA.SY_ADDR_MST is referenced by following:

APPS
SYNONYM - SY_ADDR_MST

[top of page]

Table: SY_CMPY_MST

Description: Stores Organization Definitions at a single level
Primary Key: SY_CMPY_MST_PK
  1. CO_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_CMPY_MST.CO_CODE SY_ORGN_MST_B
SY_CMPY_MST.CO_CODE SY_ORGN_MST
Comments

Stores Organization Definitions at a single level

Indexes
Index Type Tablespace Column
SY_CMPY_MST_PK UNIQUE APPS_TS_TX_IDX CO_CODE
Columns
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

[top of page]

GMA.SY_CMPY_MST does not reference any database object

GMA.SY_CMPY_MST is referenced by following:

APPS
SYNONYM - SY_CMPY_MST

[top of page]

Table: SY_DOCS_MST

Description: Oracle Process Manufacturing Document master. This table stores document definitions
Primary Key: SY_DOCS_MST_PK
  1. DOC_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_DOCS_MST.TEXT_CODE SY_TEXT_HDR
Foreign Keys to this table:
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
Comments

Oracle Process Manufacturing Document master. This table stores document definitions
used by inventory, resource and costing transactions in OPM.

Indexes
Index Type Tablespace Column
SY_DOCS_MST_PK UNIQUE APPS_TS_SEED DOC_TYPE
Columns
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

[top of page]

GMA.SY_DOCS_MST does not reference any database object

GMA.SY_DOCS_MST is referenced by following:

APPS
SYNONYM - SY_DOCS_MST

[top of page]

Table: SY_DOCS_SEQ

Description: Document sequencing by organization.
Primary Key: SY_DOCS_SEQ_PK
  1. DOC_TYPE
  2. ORGN_CODE
Foreign Keys from this table:
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 Keys to this table:
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
Comments

Document sequencing by OPM organization. Maintains document number
assignment rules including auto assignment. Does not support blank padding
characters.

Indexes
Index Type Tablespace Column
SY_DOCS_SEQ_PK UNIQUE APPS_TS_TX_IDX DOC_TYPE
ORGN_CODE
Columns
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

[top of page]

GMA.SY_DOCS_SEQ does not reference any database object

GMA.SY_DOCS_SEQ is referenced by following:

APPS
SYNONYM - SY_DOCS_SEQ

[top of page]

Table: SY_GEOG_MST

Description: Geographic regions.
Primary Key: SY_GEOG_MST_PK
  1. GEOG_TYPE
  2. GEOG_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_GEOG_MST.TEXT_CODE SY_TEXT_HDR
Comments

Stores geographic regions used by Oracle Process Manufacturing entities. These regions
are classified by Country, State, Province and County.

Indexes
Index Type Tablespace Column
SY_GEOG_MST_PK UNIQUE APPS_TS_SEED GEOG_TYPE
GEOG_CODE
Columns
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

[top of page]

GMA.SY_GEOG_MST does not reference any database object

GMA.SY_GEOG_MST is referenced by following:

APPS
SYNONYM - SY_GEOG_MST

[top of page]

Table: SY_ORGN_MST_B

Description: Organization code master Base Table.
Primary Key: SY_ORGN_MST_B_PK
  1. ORGN_CODE
Primary Key: SY_ORGN_MST_B_U1
  1. ORGANIZATION_ID
Foreign Keys from this 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 Keys to this table:
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
Comments

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.

Indexes
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
Columns
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

[top of page]

GMA.SY_ORGN_MST_B does not reference any database object

GMA.SY_ORGN_MST_B is referenced by following:

APPS
SYNONYM - SY_ORGN_MST_B

[top of page]

Table: SY_ORGN_MST_TL

Description: Translations table table holding OPM Organization names in multiple languages
Primary Key: SY_ORGN_MST_TL_PK
  1. ORGN_CODE
  2. LANGUAGE
Comments

Translations table table holding OPM Organization names in multiple languages

Indexes
Index Type Tablespace Column
SY_ORGN_MST_TL_PK NONUNIQUE APPS_TS_TX_IDX ORGN_CODE
LANGUAGE
Columns
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

[top of page]

GMA.SY_ORGN_MST_TL does not reference any database object

GMA.SY_ORGN_MST_TL is referenced by following:

APPS
SYNONYM - SY_ORGN_MST_TL

[top of page]

Table: SY_ORGN_USR

Description: Associates OPM Organizations with FND users
Primary Key: SY_ORGN_USR_PK
  1. USER_ID
  2. ORGN_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_ORGN_USR.ORGN_CODE SY_ORGN_MST_B
SY_ORGN_USR.ORGN_CODE SY_ORGN_MST
Comments

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.

Indexes
Index Type Tablespace Column
SY_ORGN_USR_PK UNIQUE APPS_TS_TX_IDX USER_ID
ORGN_CODE
Columns
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

[top of page]

GMA.SY_ORGN_USR does not reference any database object

GMA.SY_ORGN_USR is referenced by following:

APPS
SYNONYM - SY_ORGN_USR

[top of page]

Table: SY_PARA_CDS_TL

Description: Stores paragraph codes
Primary Key: SY_PARA_CDS_TL_PK
  1. TABLE_NAME
  2. PARAGRAPH_CODE
  3. SUB_PARACODE
  4. LANGUAGE
Comments

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.

Indexes
Index Type Tablespace Column
SY_PARA_CDS_TL_PK UNIQUE APPS_TS_TX_IDX TABLE_NAME
PARAGRAPH_CODE
SUB_PARACODE
LANGUAGE
Columns
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

[top of page]

GMA.SY_PARA_CDS_TL does not reference any database object

GMA.SY_PARA_CDS_TL is referenced by following:

APPS
SYNONYM - SY_PARA_CDS_TL

[top of page]

Table: SY_PURG_DEF

Description: OPM Purge and Archive definitions are stored in this table
Primary Key: SY_PURG_DEF_PK
  1. PURGE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_PURG_DEF.TEXT_CODE SY_TEXT_HDR
Foreign Keys to this table:
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
Comments

OPM Purge and Archive definitions are stored in this table.

Indexes
Index Type Tablespace Column
SYS_IL0000035918C00014$$ UNIQUE APPS_TS_SEED
SY_PURG_DEF_PK UNIQUE APPS_TS_SEED PURGE_TYPE
Columns
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.

[top of page]

GMA.SY_PURG_DEF does not reference any database object

GMA.SY_PURG_DEF is referenced by following:

APPS
SYNONYM - SY_PURG_DEF

[top of page]

Table: SY_PURG_DEF_ACT

Description: Designates the Action to be performed by OPM Purge and Archive on a table by table basis.
Primary Key: SY_PURG_DEF_ACT_PK
  1. PURGE_TYPE
  2. TABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_PURG_DEF_ACT.PURGE_TYPE SY_PURG_DEF
SY_PURG_DEF_ACT.TEXT_CODE SY_TEXT_HDR
Comments

Designates the Action to be performed by OPM Purge and Archive on a table by table basis.

Indexes
Index Type Tablespace Column
SY_PURG_DEF_ACT_PK UNIQUE APPS_TS_SEED PURGE_TYPE
TABLE_NAME
Columns
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.

[top of page]

GMA.SY_PURG_DEF_ACT does not reference any database object

GMA.SY_PURG_DEF_ACT is referenced by following:

APPS
SYNONYM - SY_PURG_DEF_ACT

[top of page]

Table: SY_PURG_DEF_CRIT

Description: Stores the Purge Criteria tags. These criteria are used to determine what rows will be archived and purged.
Primary Key: SY_PURG_DEF_CRIT_PK
  1. PURGE_TYPE
  2. CRIT_TAG
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_PURG_DEF_CRIT.TEXT_CODE SY_TEXT_HDR
SY_PURG_DEF_CRIT.PURGE_TYPE SY_PURG_DEF
Comments

Stores the Purge Criteria tags. These criteria are used to determine
what rows will be archived and purged.

Indexes
Index Type Tablespace Column
SY_PURG_DEF_CRIT_PK UNIQUE APPS_TS_SEED PURGE_TYPE
CRIT_TAG
Columns
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.

[top of page]

GMA.SY_PURG_DEF_CRIT does not reference any database object

GMA.SY_PURG_DEF_CRIT is referenced by following:

APPS
SYNONYM - SY_PURG_DEF_CRIT

[top of page]

Table: SY_PURG_ERR

Description: Stores the database output from the GMA_PURGE_ENGINE package
Primary Key: SY_PURGE_ERR_PK
  1. PURGE_ID
  2. LINE_NO
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_PURG_ERR.PURGE_ID SY_PURG_MST
Comments

Stores the database output from the OPM Purge and Archive utility,
specifically the GMA_PURGE_ENGINE package.

Indexes
Index Type Tablespace Column
SY_PURGE_ERR_PK UNIQUE APPS_TS_TX_IDX PURGE_ID
LINE_NO
Columns
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.

[top of page]

GMA.SY_PURG_ERR does not reference any database object

GMA.SY_PURG_ERR is referenced by following:

APPS
SYNONYM - SY_PURG_ERR

[top of page]

Table: SY_PURG_LOG

Description: Stores OPM Purge and Archive statistics table by table based on Purge ID.
Primary Key: SY_PURGE_LOG_PK
  1. PURGE_ID
  2. TABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_PURG_LOG.PURGE_ID SY_PURG_MST
Comments

Stores OPM Purge and Archive statistics table by table based on Purge ID.

Indexes
Index Type Tablespace Column
SY_PURGE_LOG_PK UNIQUE APPS_TS_TX_IDX PURGE_ID
TABLE_NAME
Columns
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

[top of page]

GMA.SY_PURG_LOG does not reference any database object

GMA.SY_PURG_LOG is referenced by following:

APPS
SYNONYM - SY_PURG_LOG

[top of page]

Table: SY_PURG_MST

Description: Table storing data of all OPM Archives/Purges that have been run
Primary Key: SY_PURG_MST_PK
  1. PURGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_PURG_MST.PURGE_TYPE SY_PURG_DEF
SY_PURG_MST.TEXT_CODE SY_TEXT_HDR
Foreign Keys to this table:
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
Comments

Table storing data of all OPM Archives/Purges that have been run

Indexes
Index Type Tablespace Column
SY_PURG_MST_PK UNIQUE APPS_TS_TX_IDX PURGE_ID
Columns
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.

[top of page]

GMA.SY_PURG_MST does not reference any database object

GMA.SY_PURG_MST is referenced by following:

APPS
SYNONYM - SY_PURG_MST

[top of page]

Table: SY_PURG_MST_CRIT

Description: OPM Purge and Archive table used to store the criteria entered specific to a Purge ID.
Primary Key: SY_PURG_MST_CRIT_PK
  1. PURGE_ID
  2. CRIT_TAG
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_PURG_MST_CRIT.PURGE_ID SY_PURG_MST
SY_PURG_MST_CRIT.TEXT_CODE SY_TEXT_HDR
Comments

OPM Purge and Archive table used to store the criteria entered specific to a Purge ID.

Indexes
Index Type Tablespace Column
SY_PURG_MST_CRIT_PK UNIQUE APPS_TS_TX_IDX PURGE_ID
CRIT_TAG
Columns
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

[top of page]

GMA.SY_PURG_MST_CRIT does not reference any database object

GMA.SY_PURG_MST_CRIT is referenced by following:

APPS
SYNONYM - SY_PURG_MST_CRIT

[top of page]

Table: SY_REAS_CDS_B

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.
Primary Key: SY_REAS_CDS_B_PK
  1. REASON_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_REAS_CDS_B.TEXT_CODE SY_TEXT_HDR
Foreign Keys to this table:
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
Comments

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.

Indexes
Index Type Tablespace Column
SY_REAS_CDS_B_PK UNIQUE APPS_TS_SEED REASON_CODE
Columns
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'

[top of page]

GMA.SY_REAS_CDS_B does not reference any database object

GMA.SY_REAS_CDS_B is referenced by following:

APPS
SYNONYM - SY_REAS_CDS_B

[top of page]

Table: SY_REAS_CDS_TL

Description: Translations table table holding OPM reason code descriptions in multiple languages
Primary Key: SY_REAS_CDS_TL_PK
  1. REASON_CODE
  2. LANGUAGE
Comments

Translations table table holding OPM reason code descriptions in multiple languages

Indexes
Index Type Tablespace Column
SY_REAS_CDS_TL_PK NONUNIQUE APPS_TS_SEED REASON_CODE
LANGUAGE
Columns
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

[top of page]

GMA.SY_REAS_CDS_TL does not reference any database object

GMA.SY_REAS_CDS_TL is referenced by following:

APPS
SYNONYM - SY_REAS_CDS_TL

[top of page]

Table: SY_TEXT_HDR

Description: Master table for creation and storage of OPM text codes associated with GMA tables.
Primary Key: SY_TEXT_HDR_PK
  1. TEXT_CODE
Foreign Keys to this table:
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
Comments

Master table for creation and storage of OPM text codes associated with GMA tables.

Indexes
Index Type Tablespace Column
SY_TEXT_HDR_PK UNIQUE APPS_TS_TX_IDX TEXT_CODE
Columns
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

[top of page]

GMA.SY_TEXT_HDR does not reference any database object

GMA.SY_TEXT_HDR is referenced by following:

APPS
SYNONYM - SY_TEXT_HDR

[top of page]

Table: SY_TEXT_TBL_TL

Description: GMA product Text Lines (OPM System Administration). Descriptive text for all tables in this module. Also storesText Token text.
Primary Key: SY_TEXT_TBL_TL_PK
  1. TEXT_CODE
  2. LANG_CODE
  3. PARAGRAPH_CODE
  4. SUB_PARACODE
  5. LINE_NO
  6. LANGUAGE
Comments

GMA product Text Lines (OPM System Administration). Descriptive text for all tables in this module. Also storesText Token text.

Indexes
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
Columns
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

[top of page]

GMA.SY_TEXT_TBL_TL does not reference any database object

GMA.SY_TEXT_TBL_TL is referenced by following:

APPS
SYNONYM - SY_TEXT_TBL_TL

[top of page]

Table: SY_TEXT_TKN_TL

Description: Stores OPM Text Token definitions
Primary Key: SY_TEXT_TKN_TL_PK
  1. TEXT_KEY
  2. LANG_CODE
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_TEXT_TKN_TL.TEXT_CODE SY_TEXT_HDR
Comments

Stores OPM Text Token definitions

Indexes
Index Type Tablespace Column
SY_TEXT_TKN_TL_PK UNIQUE APPS_TS_TX_IDX TEXT_KEY
LANG_CODE
LANGUAGE
Columns
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.

[top of page]

GMA.SY_TEXT_TKN_TL does not reference any database object

GMA.SY_TEXT_TKN_TL is referenced by following:

APPS
SYNONYM - SY_TEXT_TKN_TL

[top of page]

Table: SY_TRIGGER_ACTIVATION_WF

Description: Used to store the detail information about theTriggers responsible for Starting the Workflows and their Status ( Enabled, Disabled ) of the individual triggers.
Primary Key: SY_TRIGGER_ACTIVATION_WF_PK
  1. WF_ITEM_TYPE
  2. TRIGGER_NAME
Comments

Used to store the detail information about theTriggers responsible for Starting the Workflows and their Status ( Enabled, Disabled ) of the individual triggers.

Indexes
Index Type Tablespace Column
SY_TRIGGER_ACTIVATION_WF_PK UNIQUE APPS_TS_SEED WF_ITEM_TYPE
TRIGGER_NAME
Columns
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

[top of page]

GMA.SY_TRIGGER_ACTIVATION_WF does not reference any database object

GMA.SY_TRIGGER_ACTIVATION_WF is referenced by following:

APPS
SYNONYM - SY_TRIGGER_ACTIVATION_WF

[top of page]

Table: SY_UOMS_STD

Description: Table for associating Units of Measure and UOM Types. Not yet used.
Primary Key: SY_UOMS_STD_PK
  1. UM_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
SY_UOMS_STD.UM_TYPE SY_UOMS_TYP
SY_UOMS_STD.UM_CODE SY_UOMS_MST
Comments

Table for associating Units of Measure and UOM Types. Not yet used.

Indexes
Index Type Tablespace Column
SY_UOMS_STD_PK UNIQUE APPS_TS_TX_IDX UM_TYPE
Columns
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

[top of page]

GMA.SY_UOMS_STD does not reference any database object

GMA.SY_UOMS_STD is referenced by following:

APPS
SYNONYM - SY_UOMS_STD

[top of page]

View: GEMMS_TABLES

Comments
View Type

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

View of all tables owned by OPM

Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Y Table Name

[top of page]

APPS.GEMMS_TABLES references the following:

APPS
SYNONYM - FND_APPLICATION
SYNONYM - FND_TABLES

APPS.GEMMS_TABLES is not referenced by any database object

[top of page]

View: GEM_LOOKUPS

Comments
View Type

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

View of all OPM Lookups

Columns
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

[top of page]

APPS.GEM_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.GEM_LOOKUPS is referenced by following:

APPS
PACKAGE - GMA_VALID_GRP
PACKAGE BODY - GMA_VALID_GRP
PACKAGE BODY - GMDFMVAL_PUB
PACKAGE BODY - GMDQSPEC_APPROVAL_WF_PKG
PACKAGE BODY - GMDQSVRS_APPROVAL_WF_PKG
PACKAGE BODY - GMD_COA_DATA_OM
PACKAGE BODY - GMD_CONC_REPLACE_PKG
PACKAGE BODY - GMD_ERES_UTILS
VIEW - GMD_MBR_MATERIAL_V1
VIEW - GMD_MBR_STEP_MATERIAL_V1
PACKAGE BODY - GMD_PARAMETERS_DTL_PKG
PACKAGE BODY - GMD_QCR01USR_XMLP_PKG
PACKAGE BODY - GMD_QCR02USR_XMLP_PKG
PACKAGE BODY - GMD_QCR03USR_XMLP_PKG
PACKAGE BODY - GMD_QCRCOA03_XMLP_PKG
PACKAGE BODY - GMD_QC_ERES_UTILS
PACKAGE BODY - GMD_QC_LABELS_UTIL
VIEW - GMD_QC_RESULTS_TREE_V
PACKAGE BODY - GMD_QC_TESTS_GRP
PACKAGE BODY - GMD_QMREJ
PACKAGE BODY - GMD_QMSED
PACKAGE BODY - GMD_QMSMC
PACKAGE BODY - GMD_QM_CONC_REPLACE_PKG
PACKAGE BODY - GMD_RESULTS_GRP
PACKAGE BODY - GMD_SAMPLES_GRP
PACKAGE BODY - GMD_SAMPLES_PUB
PACKAGE BODY - GMD_SPEC_VRS_GRP
PACKAGE BODY - GMD_SS_APPROVAL_WF_PKG
PACKAGE BODY - GMD_TEST_INTERVAL_PLANS_GRP
PACKAGE BODY - GME_API_PUB
PACKAGE BODY - GME_BATCHSTEP_RSRC_PVT
VIEW - GME_BATCH_STEPS_V
VIEW - GME_MATERIAL_DETAILS_V
PACKAGE BODY - GME_MOBILE_LOVS
VIEW - GME_STEP_MATERIAL_DETAILS_V
PACKAGE BODY - GMF_MIGRATION
PACKAGE BODY - GMF_SUBLEDGER_PKG
PACKAGE BODY - GMF_SUBLEDGER_REPORT
PACKAGE BODY - GMI_VALID_GRP
PACKAGE BODY - GML_GMLUNALC_XMLP_PKG
PACKAGE BODY - GML_ORUARPJ_XMLP_PKG
VIEW - GMP_EAM_JOBS_RESOURCES_V
VIEW - IC_ITEM_HIERARCHY_V
PACKAGE BODY - INV_LABEL_PVT15
VIEW - MTL_MFG_BATCHES_SECURITY_V
VIEW - MTL_MFG_BATCHES_V
VIEW - MTL_WORK_ORDER_HEADER_V
PACKAGE BODY - OPI_EDW_JOB_DETAIL_FOPM_SZ
VIEW - OPI_EDW_OPM_JOB_DETAIL_FCV
VIEW - PMIFV_BATCH_STATUS_V
VIEW - PMIFV_BTCH_QCRSLT_V
VIEW - PMIFV_QCRESULT_V
VIEW - PMITS_ITEM_MASTER_V
VIEW - PMITS_QC_SAMPLES_V
VIEW - PMITS_RECIPE_VALIDITY_RULE_V
VIEW - PMITS_ROUTING_DETAIL_V
VIEW - PMITS_WAREHOUSE_MASTER_V
PACKAGE BODY - PMI_COST_ANALZ_PACK
PACKAGE - PMI_COST_ANALZ_PACK

[top of page]

View: GMA_ACTCOL_WF_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This View will be the Used to fetch the data for Column prompt.

Columns
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

[top of page]

APPS.GMA_ACTCOL_WF_VL references the following:

APPS
SYNONYM - GMA_ACTCOL_WF_B
SYNONYM - GMA_ACTCOL_WF_TL
APPS.GMA_ACTCOL_WF_VL is referenced by following:

APPS
PACKAGE BODY - GMA_WFSTD_P

[top of page]

View: GMA_MIGRATION_LOG_V1

Comments
View Type

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.

Columns
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

[top of page]

APPS.GMA_MIGRATION_LOG_V1 references the following:

APPS
PACKAGE - GMA_MIGRATION
SYNONYM - GMA_MIGRATION_CONTROL
SYNONYM - GMA_MIGRATION_LOG

APPS.GMA_MIGRATION_LOG_V1 is not referenced by any database object

[top of page]

View: GMA_PROCCOL_WF_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

GMA View

Columns
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

[top of page]

APPS.GMA_PROCCOL_WF_VL references the following:

APPS
SYNONYM - GMA_PROCCOL_WF_B
SYNONYM - GMA_PROCCOL_WF_TL
APPS.GMA_PROCCOL_WF_VL is referenced by following:

APPS
PACKAGE BODY - GMA_WFSTD_P

[top of page]

View: SY_ADDR_MST_V

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of sy_addr_mst for OPM OF customers

Columns
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.

[top of page]

APPS.SY_ADDR_MST_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - SY_ADDR_MST
APPS.SY_ADDR_MST_V is referenced by following:

APPS
PACKAGE BODY - GR_PROCESS_ORDERS
PACKAGE - GR_PROCESS_ORDERS

[top of page]

View: SY_ADDR_MST_VW1

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of ADDR_ID + first two lines of the address

Columns
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.

[top of page]

APPS.SY_ADDR_MST_VW1 references the following:

APPS
SYNONYM - SY_ADDR_MST

APPS.SY_ADDR_MST_VW1 is not referenced by any database object

[top of page]

View: SY_ORGN_MST_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Organization Master View to setup the data

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Databased Row Identifier
ORGN_CODE VARCHAR2 (4) Y Organization Code
PARENT_ORGN_CODE VARCHAR2 (4) Y Parent Organization code
CO_CODE VARCHAR2 (4) Y Company code
PLANT_IND NUMBER (5) Y Plan Indicator
ADDR_ID NUMBER (10)
Foreign Key to Address Master
ORGANIZATION_ID NUMBER (15)
Organization ID
TAXLOC_CODE VARCHAR2 (10)
Tax Location Code
TEXT_CODE NUMBER (10)
Text Code
DELETE_MARK NUMBER (5) Y Delete Mark
TRANS_CNT NUMBER (10) Y Not used
POC_IND NUMBER (5)
Process Operation Control Indicator
CREATION_DATE DATE
Y Standard Row Identifiers
CREATED_BY NUMBER (15) Y Standard Row Identifiers
LAST_UPDATE_DATE DATE
Y Standard Row Identifiers
LAST_UPDATED_BY NUMBER (15) Y Standard Row Identifiers
LAST_UPDATE_LOGIN NUMBER (15)
Standard Row Identifiers
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
MFG_CALENDAR_ID NUMBER

Manufacturing Calendar ID
ATTRIBUTE1 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE2 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE3 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE4 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE5 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE6 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE7 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE8 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE9 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE10 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE11 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE12 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE13 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE14 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE15 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE16 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE17 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE18 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE19 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE20 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE21 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE22 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE23 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE24 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE25 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE26 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE27 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE28 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE29 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE30 VARCHAR2 (240)
Flex Field Columns
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flex Field Columns
ORGN_NAME VARCHAR2 (40) Y Organization Name
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
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name for the new orgs created at discrete end
INVENTORY_ORG_IND VARCHAR2 (1)
Indicator for migrating Org as an inventory org. Y - Yes, N - No
ORGANIZATION_CODE VARCHAR2 (3)
Inventory Organization Code for the migrating organization
TEMPLATE_ORGANIZATION_ID NUMBER (15)
Template organization for copying the values for the new org
PROCESS_ENABLED_IND VARCHAR2 (1)
Process Enabled Indicator. Y- Yes, N- No
REGULATORY_ORG_IND VARCHAR2 (1)
Regulatory organization indicator
MIGRATED_IND NUMBER (5)
Organization migrated indicator. 0 - Not Migrated, 1 - Migrated
MASTER_ORGANIZATION_ID NUMBER (15)
Master Organization Id for the migrated organization
DEFAULT_STATUS VARCHAR2 (4)
Default status is added for R12.1 migration

[top of page]

APPS.SY_ORGN_MST_VL references the following:

APPS
SYNONYM - SY_ORGN_MST_B
SYNONYM - SY_ORGN_MST_TL
APPS.SY_ORGN_MST_VL is referenced by following:

APPS
SYNONYM - SY_ORGN_MST

[top of page]

View: SY_PARA_CDS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of all paragraph codes in SY_PARA_CDS_TL .

Columns
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

[top of page]

APPS.SY_PARA_CDS_VL references the following:

APPS
SYNONYM - SY_PARA_CDS_TL
APPS.SY_PARA_CDS_VL is referenced by following:

APPS
PACKAGE BODY - GMA_EDITEXT_ATTACH_MIG
TRIGGER - GMA_SY_PARA_CDS_T1
TRIGGER - GMA_SY_PARA_CDS_T2
TRIGGER - GMA_SY_PARA_CDS_T3
SYNONYM - SY_PARA_CDS

[top of page]

View: SY_REAS_CDS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

MLS enabled view of OPM Reason Codes.

Columns
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.

[top of page]

APPS.SY_REAS_CDS_VL references the following:

APPS
SYNONYM - SY_REAS_CDS_B
SYNONYM - SY_REAS_CDS_TL
APPS.SY_REAS_CDS_VL is referenced by following:

APPS
SYNONYM - SY_REAS_CDS
TRIGGER - SY_REAS_CDS_DL
TRIGGER - SY_REAS_CDS_IL
TRIGGER - SY_REAS_CDS_UL

[top of page]

View: SY_TEXT_TBL_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of all the Descriptive text in SY_TEXT_TBL_TL

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
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
PARAGRAPH_CODE VARCHAR2 (4) Y
SUB_PARACODE NUMBER (5) Y
LINE_NO NUMBER (5) Y
TEXT VARCHAR2 (70)
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.SY_TEXT_TBL_VL references the following:

APPS
SYNONYM - SY_TEXT_TBL_TL
APPS.SY_TEXT_TBL_VL is referenced by following:

APPS
TRIGGER - GMA_SY_TEXT_TBL_T1
TRIGGER - GMA_SY_TEXT_TBL_T2
TRIGGER - GMA_SY_TEXT_TBL_T3
SYNONYM - SY_TEXT_TBL

[top of page]

View: SY_TEXT_TKN_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

View of all Text Tokens in SY_TEXT_TKN_TL

Columns
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

[top of page]

APPS.SY_TEXT_TKN_VL references the following:

APPS
SYNONYM - SY_TEXT_TKN_TL
APPS.SY_TEXT_TKN_VL is referenced by following:

APPS
TRIGGER - GMA_SY_TEXT_TKN_T1
TRIGGER - GMA_SY_TEXT_TKN_T2
TRIGGER - GMA_SY_TEXT_TKN_T3
SYNONYM - SY_TEXT_TKN

[top of page]

View: SY_UOMS_MST_V

Comments
View Type

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

View of unit of measure master

Columns
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

[top of page]

APPS.SY_UOMS_MST_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - MTL_UOM_CONVERSIONS
APPS.SY_UOMS_MST_V is referenced by following:

APPS
PACKAGE BODY - OPI_DBI_RES_PKG
VIEW - PMITS_ITEM_LOT_UOM_CONV_V
SYNONYM - SY_UOMS_MST

[top of page]

View: SY_UOMS_TYP_V

Comments
View Type

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

View of unit of measure types

Columns
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

[top of page]

APPS.SY_UOMS_TYP_V references the following:

APPS
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - MTL_UOM_CLASSES
APPS.SY_UOMS_TYP_V is referenced by following:

APPS
VIEW - PMITS_ITEM_LOT_UOM_CONV_V
SYNONYM - SY_UOMS_TYP

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract