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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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