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 - GCS Tables and Views

TABLE - GCS.GCS_AD_TRANSACTIONS
TABLE - GCS.GCS_AD_TRIAL_BALANCES
TABLE - GCS.GCS_BAL_INTERFACE_T
TABLE - GCS.GCS_CATEGORIES_B
TABLE - GCS.GCS_CATEGORIES_TL
TABLE - GCS.GCS_CONS_DATA_STATUSES
TABLE - GCS.GCS_CONS_ENG_RUNS
TABLE - GCS.GCS_CONS_ENG_RUN_DTLS
TABLE - GCS.GCS_CONS_IMPACT_ANALYSES
TABLE - GCS.GCS_CONS_RELATIONSHIPS
TABLE - GCS.GCS_CURR_TREATMENTS_B
TABLE - GCS.GCS_CURR_TREATMENTS_TL
TABLE - GCS.GCS_DATASET_CODES
TABLE - GCS.GCS_DATA_SUB_DTLS
TABLE - GCS.GCS_DATA_TYPE_CODES_B
TABLE - GCS.GCS_DATA_TYPE_CODES_TL
TABLE - GCS.GCS_DIMENSION_MEMBERS_T
TABLE - GCS.GCS_DIMENSION_TEMPLATES
TABLE - GCS.GCS_ELIM_RULES_B
TABLE - GCS.GCS_ELIM_RULES_TL
TABLE - GCS.GCS_ELIM_RULE_RELS
TABLE - GCS.GCS_ELIM_RULE_STEPS_B
TABLE - GCS.GCS_ELIM_RULE_STEPS_TL
TABLE - GCS.GCS_ENTITIES_ATTR
TABLE - GCS.GCS_ENTITY_CCTR_ORGS
TABLE - GCS.GCS_ENTITY_CONS_ATTRS
TABLE - GCS.GCS_ENTITY_ORGANIZATIONS
TABLE - GCS.GCS_ENTRIES_GT
TABLE - GCS.GCS_ENTRY_HEADERS
TABLE - GCS.GCS_ENTRY_LINES
TABLE - GCS.GCS_ENTRY_LINES_GT
TABLE - GCS.GCS_EPB_DIM_MAPS
TABLE - GCS.GCS_FEM_POSTING_GT
TABLE - GCS.GCS_FLATTENED_RELNS
TABLE - GCS.GCS_HIERARCHIES_B
TABLE - GCS.GCS_HIERARCHIES_TL
TABLE - GCS.GCS_HIER_GRP_MEMBERS
TABLE - GCS.GCS_HIER_MEMBERS_T
TABLE - GCS.GCS_HISTORICAL_RATES
TABLE - GCS.GCS_INTERCO_ELM_TRX
TABLE - GCS.GCS_INTERCO_MAP_DTLS
TABLE - GCS.GCS_INTERCO_MEMBERS
TABLE - GCS.GCS_INTERCO_RULES_B
TABLE - GCS.GCS_INTERCO_RULES_TL
TABLE - GCS.GCS_LEX_MAP_COLUMNS
TABLE - GCS.GCS_LEX_MAP_CONDITIONS
TABLE - GCS.GCS_LEX_MAP_DERIVATIONS
TABLE - GCS.GCS_LEX_MAP_DRV_DETAILS
TABLE - GCS.GCS_LEX_MAP_PLSQL_FUNCS
TABLE - GCS.GCS_LEX_MAP_RULES
TABLE - GCS.GCS_LEX_MAP_RULE_SETS
TABLE - GCS.GCS_LEX_MAP_RULE_STAGES
TABLE - GCS.GCS_LEX_MAP_STRUCTS
TABLE - GCS.GCS_LOBS
TABLE - GCS.GCS_ROLE_ENTITY_RELNS
TABLE - GCS.GCS_ROLE_HIER_RELNS
TABLE - GCS.GCS_RULE_SCOPE_DIMS
TABLE - GCS.GCS_RULE_SCOPE_DTLS
TABLE - GCS.GCS_SYSTEM_OPTIONS
TABLE - GCS.GCS_SYSTEM_TASKS
TABLE - GCS.GCS_TRANSLATION_STATUSES
TABLE - GCS.GCS_TRANSLATION_TRACK_H
TABLE - GCS.GCS_TREATMENTS_B
TABLE - GCS.GCS_TREATMENTS_TL
TABLE - GCS.GCS_WRITEBACK_HEADERS
TABLE - GCS.GCS_WRITEBACK_LINES
TABLE - GCS.GCS_XML_FILES
VIEW - APPS.GCS_ACTIVE_DIMS_V
VIEW - APPS.GCS_CATEGORIES_VL
VIEW - APPS.GCS_CURR_TREATMENTS_VL
VIEW - APPS.GCS_DATA_TYPE_CODES_VL
VIEW - APPS.GCS_ELIM_RULES_VL
VIEW - APPS.GCS_ELIM_RULE_STEPS_VL
VIEW - APPS.GCS_FEM_ACTIVE_DIMS_V
VIEW - APPS.GCS_FINANCIAL_ITEMS_HIER_V
VIEW - APPS.GCS_FINANCIAL_ITEMS_V
VIEW - APPS.GCS_FIN_STMTS_V
VIEW - APPS.GCS_FIN_STMT_DTLS_V
VIEW - APPS.GCS_GL_JI_GROUPS_V
VIEW - APPS.GCS_HIERARCHIES_VL
VIEW - APPS.GCS_ITEMS_TO_NAT_ACCTS_V
VIEW - APPS.GCS_LEX_MAP_SEQUENCES_V
VIEW - APPS.GCS_NAT_ACCTS_HIER_V
VIEW - APPS.GCS_NAT_ACCTS_V
VIEW - APPS.GCS_TREATMENTS_VL

Table: GCS_AD_TRANSACTIONS

Description: GCS Acquisition and Disposal transaction control records that reflect the most current transaction states
Primary Key: GCS_AD_TRANSACTIONS_PK
  1. AD_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_AD_TRANSACTIONS.PRE_CONS_RELATIONSHIP_ID %
GCS_AD_TRANSACTIONS.POST_CONS_RELATIONSHIP_ID %
GCS_AD_TRANSACTIONS.ASSOC_ENTRY_ID %

[top of page]

GCS.GCS_AD_TRANSACTIONS does not reference any database object

GCS.GCS_AD_TRANSACTIONS is referenced by following:

APPS
SYNONYM - GCS_AD_TRANSACTIONS

[top of page]

Table: GCS_AD_TRIAL_BALANCES

Description: Acquisition and disposal transaction trial balances
Primary Key: GCS_AD_TRIAL_BALANCES_PK
  1. AD_TRANSACTION_ID
  2. TRIAL_BALANCE_SEQ
  3. COMPANY_COST_CENTER_ORG_ID
  4. INTERCOMPANY_ID
  5. LINE_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_AD_TRIAL_BALANCES.AD_TRANSACTION_ID %

[top of page]

GCS.GCS_AD_TRIAL_BALANCES does not reference any database object

GCS.GCS_AD_TRIAL_BALANCES is referenced by following:

APPS
SYNONYM - GCS_AD_TRIAL_BALANCES

[top of page]

Table: GCS_BAL_INTERFACE_T

Description: Stores line level information on data transferred to FEM_BALANCES
Primary Key: GCS_BAL_INTERFACE_T_PK
  1. LOAD_ID

[top of page]

GCS.GCS_BAL_INTERFACE_T does not reference any database object

GCS.GCS_BAL_INTERFACE_T is referenced by following:

APPS
SYNONYM - GCS_BAL_INTERFACE_T

[top of page]

Table: GCS_CATEGORIES_B

Description: Non-Translatable Information for the Processing Categories
Primary Key: GCS_CATEGORIES_B_PK
  1. CATEGORY_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_ENG_RUN_DTLS.CATEGORY_CODE GCS_CATEGORIES_B

[top of page]

GCS.GCS_CATEGORIES_B does not reference any database object

GCS.GCS_CATEGORIES_B is referenced by following:

APPS
SYNONYM - GCS_CATEGORIES_B

[top of page]

Table: GCS_CATEGORIES_TL

Description: Translatable Information for the Processing Categories
Primary Key: GCS_CATEGORIES_TL_PK
  1. CATEGORY_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CATEGORIES_TL.CATEGORY_CODE %
GCS_CATEGORIES_TL.SOURCE_LANG FND_LANGUAGES
GCS_CATEGORIES_TL.LANGUAGE FND_LANGUAGES

[top of page]

GCS.GCS_CATEGORIES_TL does not reference any database object

GCS.GCS_CATEGORIES_TL is referenced by following:

APPS
SYNONYM - GCS_CATEGORIES_TL

[top of page]

Table: GCS_CONS_DATA_STATUSES

Description: Stores data status for consolidation entities.
Primary Key: GCS_CONS_DATA_STATUSES_PK
  1. HIERARCHY_ID
  2. CONSOLIDATION_ENTITY_ID
  3. CAL_PERIOD_ID
  4. BALANCE_TYPE_CODE

[top of page]

GCS.GCS_CONS_DATA_STATUSES does not reference any database object

GCS.GCS_CONS_DATA_STATUSES is referenced by following:

APPS
SYNONYM - GCS_CONS_DATA_STATUSES

[top of page]

Table: GCS_CONS_ENG_RUNS

Description: Header level information for consolidation processes
Primary Key: GCS_CONS_ENG_RUNS_PK
  1. RUN_NAME
  2. HIERARCHY_ID
  3. RUN_ENTITY_ID
  4. PARENT_ENTITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CONS_ENG_RUNS.HIERARCHY_ID %
GCS_CONS_ENG_RUNS.REQUEST_ID FND_CONCURRENT_REQUESTS
GCS_CONS_ENG_RUNS.ANALYSIS_CYCLE_ID %

[top of page]

GCS.GCS_CONS_ENG_RUNS does not reference any database object

GCS.GCS_CONS_ENG_RUNS is referenced by following:

APPS
SYNONYM - GCS_CONS_ENG_RUNS

[top of page]

Table: GCS_CONS_ENG_RUN_DTLS

Description: Detail level information for consolidation processes
Primary Key: GCS_CONS_ENG_RUN_DTLS_PK
  1. RUN_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CONS_ENG_RUN_DTLS.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.PRE_PROP_STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.CATEGORY_CODE GCS_CATEGORIES_B
GCS_CONS_ENG_RUN_DTLS.ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.RULE_ID %
GCS_CONS_ENG_RUN_DTLS.CONS_RELATIONSHIP_ID %
GCS_CONS_ENG_RUN_DTLS.STAT_ENTRY_ID GCS_ENTRY_HEADERS

[top of page]

GCS.GCS_CONS_ENG_RUN_DTLS does not reference any database object

GCS.GCS_CONS_ENG_RUN_DTLS is referenced by following:

APPS
SYNONYM - GCS_CONS_ENG_RUN_DTLS

[top of page]

Table: GCS_CONS_IMPACT_ANALYSES

Description: Impact Analysis information for consolidation processes
Primary Key: GCS_CONS_IMPACT_ANALYSES_PK
  1. IMPACT_ANALYSIS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CONS_IMPACT_ANALYSES.PRE_RELATIONSHIP_ID GCS_CONS_RELATIONSHIPS
GCS_CONS_IMPACT_ANALYSES.STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.ORIGINAL_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.LOAD_ID GCS_DATA_SUB_DTLS

[top of page]

GCS.GCS_CONS_IMPACT_ANALYSES does not reference any database object

GCS.GCS_CONS_IMPACT_ANALYSES is referenced by following:

APPS
SYNONYM - GCS_CONS_IMPACT_ANALYSES

[top of page]

Table: GCS_CONS_RELATIONSHIPS

Description: GCS consolidation hierarchy relationship information
Primary Key: GCS_CONS_RELATIONSHIPS_PK
  1. CONS_RELATIONSHIP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CONS_RELATIONSHIPS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_CONS_RELATIONSHIPS.TREATMENT_ID GCS_TREATMENTS_B
GCS_CONS_RELATIONSHIPS.CURR_TREATMENT_ID GCS_CURR_TREATMENTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_IMPACT_ANALYSES.PRE_RELATIONSHIP_ID GCS_CONS_RELATIONSHIPS

[top of page]

GCS.GCS_CONS_RELATIONSHIPS does not reference any database object

GCS.GCS_CONS_RELATIONSHIPS is referenced by following:

APPS
SYNONYM - GCS_CONS_RELATIONSHIPS

[top of page]

Table: GCS_CURR_TREATMENTS_B

Description: Consolidation currency treatments
Primary Key: GCS_CURR_TREATMENTS_B_PK
  1. CURR_TREATMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CURR_TREATMENTS_B.ENDING_RATE_TYPE GL_DAILY_CONVERSION_TYPES
GCS_CURR_TREATMENTS_B.AVERAGE_RATE_TYPE GL_DAILY_CONVERSION_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_RELATIONSHIPS.CURR_TREATMENT_ID GCS_CURR_TREATMENTS_B

[top of page]

GCS.GCS_CURR_TREATMENTS_B does not reference any database object

GCS.GCS_CURR_TREATMENTS_B is referenced by following:

APPS
SYNONYM - GCS_CURR_TREATMENTS_B

[top of page]

Table: GCS_CURR_TREATMENTS_TL

Description: Translation table for GCS Currency treatments
Primary Key: GCS_CURR_TREATMENTS_TL_PK
  1. CURR_TREATMENT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CURR_TREATMENTS_TL.LANGUAGE FND_LANGUAGES
GCS_CURR_TREATMENTS_TL.SOURCE_LANG FND_LANGUAGES

[top of page]

GCS.GCS_CURR_TREATMENTS_TL does not reference any database object

GCS.GCS_CURR_TREATMENTS_TL is referenced by following:

APPS
SYNONYM - GCS_CURR_TREATMENTS_TL

[top of page]

Table: GCS_DATASET_CODES

Description: GCS hierarchy dataset code information
Primary Key: GCS_DATASET_CODES_PK
  1. HIERARCHY_ID
  2. BALANCE_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_DATASET_CODES.HIERARCHY_ID GCS_HIERARCHIES_B

[top of page]

GCS.GCS_DATASET_CODES does not reference any database object

GCS.GCS_DATASET_CODES is referenced by following:

APPS
SYNONYM - GCS_DATASET_CODES

[top of page]

Table: GCS_DATA_SUB_DTLS

Description: Stores tracking information on pristine data loads made to FEM_BALANCES
Primary Key: GCS_DATA_SUB_DTLS_PK
  1. LOAD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_DATA_SUB_DTLS.CURRENCY_CODE FND_CURRENCIES
GCS_DATA_SUB_DTLS.RULE_SET_ID GCS_LEX_MAP_RULE_SETS
GCS_DATA_SUB_DTLS.ASSOCIATED_REQUEST_ID FND_CONCURRENT_REQUESTS
GCS_DATA_SUB_DTLS.VALIDATION_RULE_SET_ID GCS_LEX_MAP_RULE_SETS
GCS_DATA_SUB_DTLS.BALANCES_RULE_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_IMPACT_ANALYSES.LOAD_ID GCS_DATA_SUB_DTLS

[top of page]

GCS.GCS_DATA_SUB_DTLS does not reference any database object

GCS.GCS_DATA_SUB_DTLS is referenced by following:

APPS
SYNONYM - GCS_DATA_SUB_DTLS

[top of page]

Table: GCS_DATA_TYPE_CODES_B

Description: Stores validate data types for Consolidation

[top of page]

GCS.GCS_DATA_TYPE_CODES_B does not reference any database object

GCS.GCS_DATA_TYPE_CODES_B is referenced by following:

APPS
SYNONYM - GCS_DATA_TYPE_CODES_B

[top of page]

Table: GCS_DATA_TYPE_CODES_TL

Description: Stores translatable information for data types

[top of page]

GCS.GCS_DATA_TYPE_CODES_TL does not reference any database object

GCS.GCS_DATA_TYPE_CODES_TL is referenced by following:

APPS
SYNONYM - GCS_DATA_TYPE_CODES_TL

[top of page]

Table: GCS_DIMENSION_MEMBERS_T

Description: FCH dimension members

[top of page]

GCS.GCS_DIMENSION_MEMBERS_T does not reference any database object

GCS.GCS_DIMENSION_MEMBERS_T is referenced by following:

APPS
SYNONYM - GCS_DIMENSION_MEMBERS_T

[top of page]

Table: GCS_DIMENSION_TEMPLATES

Description: GCS dimension templates for retained earnings and suspense handling
Primary Key: GCS_DIMENSION_TEMPLATES_PK
  1. HIERARCHY_ID
  2. TEMPLATE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_DIMENSION_TEMPLATES.HIERARCHY_ID GCS_HIERARCHIES_B

[top of page]

GCS.GCS_DIMENSION_TEMPLATES does not reference any database object

GCS.GCS_DIMENSION_TEMPLATES is referenced by following:

APPS
SYNONYM - GCS_DIMENSION_TEMPLATES

[top of page]

Table: GCS_ELIM_RULES_B

Description: GCS consolidation rules
Primary Key: GCS_ELIM_RULES_B_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULES_B.TO_TREATMENT_ID %
GCS_ELIM_RULES_B.FROM_TREATMENT_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULES_TL.RULE_ID GCS_ELIM_RULES_B
GCS_ELIM_RULE_RELS.RULE_ID GCS_ELIM_RULES_B
GCS_ELIM_RULE_STEPS_B.RULE_ID GCS_ELIM_RULES_B
GCS_ENTRY_HEADERS.RULE_ID GCS_ELIM_RULES_B

[top of page]

GCS.GCS_ELIM_RULES_B does not reference any database object

GCS.GCS_ELIM_RULES_B is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULES_B

[top of page]

Table: GCS_ELIM_RULES_TL

Description: Translation table for GCS_ELIM_RULES_B
Primary Key: GCS_ELIM_RULES_TL_PK
  1. RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULES_TL.RULE_ID GCS_ELIM_RULES_B
GCS_ELIM_RULES_TL.LANGUAGE FND_LANGUAGES
GCS_ELIM_RULES_TL.SOURCE_LANG FND_LANGUAGES

[top of page]

GCS.GCS_ELIM_RULES_TL does not reference any database object

GCS.GCS_ELIM_RULES_TL is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULES_TL

[top of page]

Table: GCS_ELIM_RULE_RELS

Description: GCS consolidation treatment and consolidation rules relationship information
Primary Key: GCS_ELIM_RULE_RELS_PK
  1. TREATMENT_ID
  2. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULE_RELS.TREATMENT_ID %
GCS_ELIM_RULE_RELS.RULE_ID GCS_ELIM_RULES_B

[top of page]

GCS.GCS_ELIM_RULE_RELS does not reference any database object

GCS.GCS_ELIM_RULE_RELS is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULE_RELS

[top of page]

Table: GCS_ELIM_RULE_STEPS_B

Description: GCS elimination rule steps
Primary Key: GCS_ELIM_RULE_STEPS_B_PK
  1. RULE_ID
  2. STEP_SEQ
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULE_STEPS_B.RULE_ID GCS_ELIM_RULES_B

[top of page]

GCS.GCS_ELIM_RULE_STEPS_B does not reference any database object

GCS.GCS_ELIM_RULE_STEPS_B is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULE_STEPS_B

[top of page]

Table: GCS_ELIM_RULE_STEPS_TL

Description: Translation table for GCS_ELIM_RULE_STEPS_B
Primary Key: GCS_ELIM_RULE_STEPS_TL_PK
  1. LANGUAGE
  2. RULE_STEP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULE_STEPS_TL.LANGUAGE FND_LANGUAGES
GCS_ELIM_RULE_STEPS_TL.SOURCE_LANG FND_LANGUAGES

[top of page]

GCS.GCS_ELIM_RULE_STEPS_TL does not reference any database object

GCS.GCS_ELIM_RULE_STEPS_TL is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULE_STEPS_TL

[top of page]

Table: GCS_ENTITIES_ATTR

Description: GCS entity additional data type information
Primary Key: GCS_ENTITIES_ATTR_PK
  1. ENTITY_ID
  2. DATA_TYPE_CODE

[top of page]

GCS.GCS_ENTITIES_ATTR does not reference any database object

GCS.GCS_ENTITIES_ATTR is referenced by following:

APPS
SYNONYM - GCS_ENTITIES_ATTR

[top of page]

Table: GCS_ENTITY_CCTR_ORGS

Description: Summary of all GCS entity organizations
Primary Key: GCS_ENTITY_CCTR_ORGS_PK
  1. ENTITY_ID
  2. COMPANY_COST_CENTER_ORG_ID

[top of page]

GCS.GCS_ENTITY_CCTR_ORGS does not reference any database object

GCS.GCS_ENTITY_CCTR_ORGS is referenced by following:

APPS
SYNONYM - GCS_ENTITY_CCTR_ORGS

[top of page]

Table: GCS_ENTITY_CONS_ATTRS

Description: GCS consolidation hierarchy node information
Primary Key: GCS_ENTITY_CONS_ATTRS_PK
  1. HIERARCHY_ID
  2. ENTITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ENTITY_CONS_ATTRS.CURRENCY_CODE FND_CURRENCIES
GCS_ENTITY_CONS_ATTRS.HIERARCHY_ID GCS_HIERARCHIES_B

[top of page]

GCS.GCS_ENTITY_CONS_ATTRS does not reference any database object

GCS.GCS_ENTITY_CONS_ATTRS is referenced by following:

APPS
SYNONYM - GCS_ENTITY_CONS_ATTRS

[top of page]

Table: GCS_ENTITY_ORGANIZATIONS

Description: GCS entity organization dimension filter information
Primary Key: GCS_ENTITY_ORGANIZATIONS_PK
  1. ENTITY_ID
  2. COMPANY_COST_CENTER_ORG_ID

[top of page]

GCS.GCS_ENTITY_ORGANIZATIONS does not reference any database object

GCS.GCS_ENTITY_ORGANIZATIONS is referenced by following:

APPS
SYNONYM - GCS_ENTITY_ORGANIZATIONS

[top of page]

Table: GCS_ENTRIES_GT

Description:

[top of page]

GCS.GCS_ENTRIES_GT does not reference any database object

GCS.GCS_ENTRIES_GT is referenced by following:

APPS
SYNONYM - GCS_ENTRIES_GT

[top of page]

Table: GCS_ENTRY_HEADERS

Description: GCS consolidation entry headers
Primary Key: GCS_ENTRY_HEADERS_PK
  1. ENTRY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ENTRY_HEADERS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_ENTRY_HEADERS.ASSOC_ENTRY_ID GCS_ENTRY_HEADERS
GCS_ENTRY_HEADERS.RULE_ID GCS_ELIM_RULES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_ENG_RUN_DTLS.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.PRE_PROP_STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.ORIGINAL_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_ENTRY_HEADERS.ASSOC_ENTRY_ID GCS_ENTRY_HEADERS

[top of page]

GCS.GCS_ENTRY_HEADERS does not reference any database object

GCS.GCS_ENTRY_HEADERS is referenced by following:

APPS
SYNONYM - GCS_ENTRY_HEADERS

[top of page]

Table: GCS_ENTRY_LINES

Description: GCS consolidation entry lines
Primary Key: GCS_ENTRY_LINES_PK
  1. ENTRY_ID
  2. COMPANY_COST_CENTER_ORG_ID
  3. INTERCOMPANY_ID
  4. LINE_ITEM_ID

[top of page]

GCS.GCS_ENTRY_LINES does not reference any database object

GCS.GCS_ENTRY_LINES is referenced by following:

APPS
SYNONYM - GCS_ENTRY_LINES

[top of page]

Table: GCS_ENTRY_LINES_GT

Description:

[top of page]

GCS.GCS_ENTRY_LINES_GT does not reference any database object

GCS.GCS_ENTRY_LINES_GT is referenced by following:

APPS
SYNONYM - GCS_ENTRY_LINES_GT

[top of page]

Table: GCS_EPB_DIM_MAPS

Description: Dimension mapping from FCH to EPB.
Primary Key: GCS_EPB_DIM_MAPS_PK
  1. GCS_COLUMN

[top of page]

GCS.GCS_EPB_DIM_MAPS does not reference any database object

GCS.GCS_EPB_DIM_MAPS is referenced by following:

APPS
SYNONYM - GCS_EPB_DIM_MAPS

[top of page]

Table: GCS_FEM_POSTING_GT

Description:

[top of page]

GCS.GCS_FEM_POSTING_GT does not reference any database object

GCS.GCS_FEM_POSTING_GT is referenced by following:

APPS
SYNONYM - GCS_FEM_POSTING_GT

[top of page]

Table: GCS_FLATTENED_RELNS

Description:

[top of page]

GCS.GCS_FLATTENED_RELNS does not reference any database object

GCS.GCS_FLATTENED_RELNS is referenced by following:

APPS
SYNONYM - GCS_FLATTENED_RELNS

[top of page]

Table: GCS_HIERARCHIES_B

Description: GCS hierarchy header information
Primary Key: GCS_HIERARCHIES_B_PK
  1. HIERARCHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_HIERARCHIES_B.THRESHOLD_CURRENCY FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_RELATIONSHIPS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_DATASET_CODES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_DIMENSION_TEMPLATES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_ENTITY_CONS_ATTRS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_ENTRY_HEADERS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_HIERARCHIES_TL.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_HISTORICAL_RATES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_INTERCO_ELM_TRX.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_ROLE_HIER_RELNS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_TRANSLATION_STATUSES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_TRANSLATION_TRACK_H.HIERARCHY_ID GCS_HIERARCHIES_B

[top of page]

GCS.GCS_HIERARCHIES_B does not reference any database object

GCS.GCS_HIERARCHIES_B is referenced by following:

APPS
SYNONYM - GCS_HIERARCHIES_B

[top of page]

Table: GCS_HIERARCHIES_TL

Description: GCS consolidation hierarchy header name and description information
Primary Key: GCS_HIERARCHIES_TL_PK
  1. HIERARCHY_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_HIERARCHIES_TL.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_HIERARCHIES_TL.LANGUAGE FND_LANGUAGES
GCS_HIERARCHIES_TL.SOURCE_LANG FND_LANGUAGES

[top of page]

GCS.GCS_HIERARCHIES_TL does not reference any database object

GCS.GCS_HIERARCHIES_TL is referenced by following:

APPS
SYNONYM - GCS_HIERARCHIES_TL

[top of page]

Table: GCS_HIER_GRP_MEMBERS

Description:
Primary Key: GCS_HIER_GRP_MEMBERS_PK
  1. HIERARCHY_GRP_ID
  2. HIERARCHY_ID

[top of page]

GCS.GCS_HIER_GRP_MEMBERS does not reference any database object

GCS.GCS_HIER_GRP_MEMBERS is referenced by following:

APPS
SYNONYM - GCS_HIER_GRP_MEMBERS

[top of page]

Table: GCS_HIER_MEMBERS_T

Description: FCH dimension hierarchy members

[top of page]

GCS.GCS_HIER_MEMBERS_T does not reference any database object

GCS.GCS_HIER_MEMBERS_T is referenced by following:

APPS
SYNONYM - GCS_HIER_MEMBERS_T

[top of page]

Table: GCS_HISTORICAL_RATES

Description: GCS historical rates information
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_HISTORICAL_RATES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_HISTORICAL_RATES.FROM_CURRENCY FND_CURRENCIES
GCS_HISTORICAL_RATES.TO_CURRENCY FND_CURRENCIES

[top of page]

GCS.GCS_HISTORICAL_RATES does not reference any database object

GCS.GCS_HISTORICAL_RATES is referenced by following:

APPS
SYNONYM - GCS_HISTORICAL_RATES

[top of page]

Table: GCS_INTERCO_ELM_TRX

Description: Intercompany transactions table.
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_INTERCO_ELM_TRX.HIERARCHY_ID GCS_HIERARCHIES_B

[top of page]

GCS.GCS_INTERCO_ELM_TRX does not reference any database object

GCS.GCS_INTERCO_ELM_TRX is referenced by following:

APPS
SYNONYM - GCS_INTERCO_ELM_TRX

[top of page]

Table: GCS_INTERCO_MAP_DTLS

Description: Intercompany Mapping information
Primary Key: GCS_INTERCO_MAP_DTLS_PK
  1. LINE_ITEM_ID
  2. LNITEM_VALUE_SET_ID
  3. INTERCOMPANY_ID
  4. INTERCOMPANY_VALUE_SET_ID

[top of page]

GCS.GCS_INTERCO_MAP_DTLS does not reference any database object

GCS.GCS_INTERCO_MAP_DTLS is referenced by following:

APPS
SYNONYM - GCS_INTERCO_MAP_DTLS

[top of page]

Table: GCS_INTERCO_MEMBERS

Description: Intercompany line item elimination sets
Primary Key: GCS-INTERCO_MEMBERS_PK
  1. RULE_ID
  2. LINE_ITEM_GROUP
  3. LINE_ITEM_ID

[top of page]

GCS.GCS_INTERCO_MEMBERS does not reference any database object

GCS.GCS_INTERCO_MEMBERS is referenced by following:

APPS
SYNONYM - GCS_INTERCO_MEMBERS

[top of page]

Table: GCS_INTERCO_RULES_B

Description: GCS intercompany rules header
Primary Key: GCS_INETRCO_RULES_B_PK
  1. RULE_ID

[top of page]

GCS.GCS_INTERCO_RULES_B does not reference any database object

GCS.GCS_INTERCO_RULES_B is referenced by following:

APPS
SYNONYM - GCS_INTERCO_RULES_B

[top of page]

Table: GCS_INTERCO_RULES_TL

Description: Translation table for GCS_INTERCO_RULES_B
Primary Key: GCS_INTERCO_RULES_TL_PK
  1. RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_INTERCO_RULES_TL.RULE_ID %
GCS_INTERCO_RULES_TL.LANGUAGE FND_LANGUAGES
GCS_INTERCO_RULES_TL.SOURCE_LANG FND_LANGUAGES

[top of page]

GCS.GCS_INTERCO_RULES_TL does not reference any database object

GCS.GCS_INTERCO_RULES_TL is referenced by following:

APPS
SYNONYM - GCS_INTERCO_RULES_TL

[top of page]

Table: GCS_LEX_MAP_COLUMNS

Description: Columns in an Interface Data Transformer staging table
Primary Key: GCS_LEX_MAP_COLUMNS_PK
  1. COLUMN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_COLUMNS.STRUCTURE_ID GCS_LEX_MAP_STRUCTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_CONDITIONS.SOURCE_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DERIVATIONS.LOOKUP_RESULT_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DRV_DETAILS.DETAIL_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DRV_DETAILS.LOOKUP_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_RULES.TARGET_COLUMN_ID GCS_LEX_MAP_COLUMNS

[top of page]

GCS.GCS_LEX_MAP_COLUMNS does not reference any database object

GCS.GCS_LEX_MAP_COLUMNS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_COLUMNS

[top of page]

Table: GCS_LEX_MAP_CONDITIONS

Description: Transformation Rule Set conditions
Primary Key: GCS_LEX_MAP_CONDITIONS_PK
  1. CONDITION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_CONDITIONS.DERIVATION_ID GCS_LEX_MAP_DERIVATIONS
GCS_LEX_MAP_CONDITIONS.SOURCE_COLUMN_ID GCS_LEX_MAP_COLUMNS

[top of page]

GCS.GCS_LEX_MAP_CONDITIONS does not reference any database object

GCS.GCS_LEX_MAP_CONDITIONS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_CONDITIONS

[top of page]

Table: GCS_LEX_MAP_DERIVATIONS

Description: Transformation Rule Set derivation
Primary Key: GCS_LEX_MAP_DERIVATIONS_PK
  1. DERIVATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_DERIVATIONS.RULE_ID GCS_LEX_MAP_RULES
GCS_LEX_MAP_DERIVATIONS.LOOKUP_TABLE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_DERIVATIONS.LOOKUP_RESULT_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DERIVATIONS.FUNCTION_NAME GCS_LEX_MAP_PLSQL_FUNCS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_CONDITIONS.DERIVATION_ID GCS_LEX_MAP_DERIVATIONS
GCS_LEX_MAP_DRV_DETAILS.DERIVATION_ID GCS_LEX_MAP_DERIVATIONS

[top of page]

GCS.GCS_LEX_MAP_DERIVATIONS does not reference any database object

GCS.GCS_LEX_MAP_DERIVATIONS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_DERIVATIONS

[top of page]

Table: GCS_LEX_MAP_DRV_DETAILS

Description: Transformation Rule Set derivation details
Primary Key: GCS_LEX_MAP_DRV_DETAILS_PK
  1. DERIVATION_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_DRV_DETAILS.DERIVATION_ID GCS_LEX_MAP_DERIVATIONS
GCS_LEX_MAP_DRV_DETAILS.DETAIL_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DRV_DETAILS.LOOKUP_COLUMN_ID GCS_LEX_MAP_COLUMNS

[top of page]

GCS.GCS_LEX_MAP_DRV_DETAILS does not reference any database object

GCS.GCS_LEX_MAP_DRV_DETAILS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_DRV_DETAILS

[top of page]

Table: GCS_LEX_MAP_PLSQL_FUNCS

Description: Transformation Rule Set PL/SQL Functions
Primary Key: GCS_LEX_MAP_PLSQL_FUNCS_PK
  1. FUNCTION_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_DERIVATIONS.FUNCTION_NAME GCS_LEX_MAP_PLSQL_FUNCS

[top of page]

GCS.GCS_LEX_MAP_PLSQL_FUNCS does not reference any database object

GCS.GCS_LEX_MAP_PLSQL_FUNCS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_PLSQL_FUNCS

[top of page]

Table: GCS_LEX_MAP_RULES

Description: Transformation Rule Set Rule
Primary Key: GCS_LEX_MAP_RULES_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_RULES.RULE_STAGE_ID GCS_LEX_MAP_RULE_STAGES
GCS_LEX_MAP_RULES.TARGET_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_RULES.LOOKUP_TABLE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_RULES.VALUE_SET_ID FND_FLEX_VALUE_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_DERIVATIONS.RULE_ID GCS_LEX_MAP_RULES

[top of page]

GCS.GCS_LEX_MAP_RULES does not reference any database object

GCS.GCS_LEX_MAP_RULES is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_RULES

[top of page]

Table: GCS_LEX_MAP_RULE_SETS

Description: Transformation Rule Set definition
Primary Key: GCS_LEX_MAP_RULE_SETS_PK
  1. RULE_SET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_RULE_SETS.STRUCTURE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_RULE_SETS.ASSOCIATED_OBJECT_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_DATA_SUB_DTLS.RULE_SET_ID GCS_LEX_MAP_RULE_SETS
GCS_DATA_SUB_DTLS.VALIDATION_RULE_SET_ID GCS_LEX_MAP_RULE_SETS
GCS_LEX_MAP_RULE_STAGES.RULE_SET_ID GCS_LEX_MAP_RULE_SETS

[top of page]

GCS.GCS_LEX_MAP_RULE_SETS does not reference any database object

GCS.GCS_LEX_MAP_RULE_SETS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_RULE_SETS

[top of page]

Table: GCS_LEX_MAP_RULE_STAGES

Description: Transformation Rule Set Stage
Primary Key: GCS_LEX_MAP_RULE_STAGES_PK
  1. RULE_STAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_RULE_STAGES.RULE_SET_ID GCS_LEX_MAP_RULE_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_RULES.RULE_STAGE_ID GCS_LEX_MAP_RULE_STAGES

[top of page]

GCS.GCS_LEX_MAP_RULE_STAGES does not reference any database object

GCS.GCS_LEX_MAP_RULE_STAGES is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_RULE_STAGES

[top of page]

Table: GCS_LEX_MAP_STRUCTS

Description: Overall structure of an Interface Data Transformer staging table
Primary Key: GCS_LEX_MAP_STRUCTS_PK
  1. STRUCTURE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_COLUMNS.STRUCTURE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_DERIVATIONS.LOOKUP_TABLE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_RULES.LOOKUP_TABLE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_RULE_SETS.STRUCTURE_ID GCS_LEX_MAP_STRUCTS

[top of page]

GCS.GCS_LEX_MAP_STRUCTS does not reference any database object

GCS.GCS_LEX_MAP_STRUCTS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_STRUCTS

[top of page]

Table: GCS_LOBS

Description: Image Repository for Global Consolidation System
Primary Key: GCS_LOBS_PK
  1. FILE_ID

[top of page]

GCS.GCS_LOBS does not reference any database object

GCS.GCS_LOBS is referenced by following:

APPS
SYNONYM - GCS_LOBS

[top of page]

Table: GCS_ROLE_ENTITY_RELNS

Description: Role and entity relationship information
Primary Key: GCS_ROLE_ENTITY_RELNS_PK
  1. ROLE_NAME
  2. ORIG_SYSTEM
  3. ORIG_SYSTEM_ID
  4. PARTITION_ID
  5. ENTITY_ID

[top of page]

GCS.GCS_ROLE_ENTITY_RELNS does not reference any database object

GCS.GCS_ROLE_ENTITY_RELNS is referenced by following:

APPS
SYNONYM - GCS_ROLE_ENTITY_RELNS

[top of page]

Table: GCS_ROLE_HIER_RELNS

Description: Role and hierarchy relationship information
Primary Key: GCS_ROLE_HIER_RELNS_PK
  1. ROLE_NAME
  2. ORIG_SYSTEM
  3. ORIG_SYSTEM_ID
  4. PARTITION_ID
  5. HIERARCHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ROLE_HIER_RELNS.HIERARCHY_ID GCS_HIERARCHIES_B

[top of page]

GCS.GCS_ROLE_HIER_RELNS does not reference any database object

GCS.GCS_ROLE_HIER_RELNS is referenced by following:

APPS
SYNONYM - GCS_ROLE_HIER_RELNS

[top of page]

Table: GCS_RULE_SCOPE_DIMS

Description:
Primary Key: GCS_RULE_SCOPE_DIMS_PK
  1. RULE_STEP_ID
  2. COLUMN_NAME

[top of page]

GCS.GCS_RULE_SCOPE_DIMS does not reference any database object

GCS.GCS_RULE_SCOPE_DIMS is referenced by following:

APPS
SYNONYM - GCS_RULE_SCOPE_DIMS

[top of page]

Table: GCS_RULE_SCOPE_DTLS

Description:
Primary Key: GCS_RULE_SCOPE_DTLS_PK
  1. RULE_STEP_ID
  2. COLUMN_NAME
  3. SOURCE_MEMBER_ID

[top of page]

GCS.GCS_RULE_SCOPE_DTLS does not reference any database object

GCS.GCS_RULE_SCOPE_DTLS is referenced by following:

APPS
SYNONYM - GCS_RULE_SCOPE_DTLS

[top of page]

Table: GCS_SYSTEM_OPTIONS

Description: Stores system level setup for Financial Consolidation Hub.

[top of page]

GCS.GCS_SYSTEM_OPTIONS does not reference any database object

GCS.GCS_SYSTEM_OPTIONS is referenced by following:

APPS
SYNONYM - GCS_SYSTEM_OPTIONS

[top of page]

Table: GCS_SYSTEM_TASKS

Description: Stores system level tasks.
Primary Key: GCS_SYSTEM_TASKS_PK
  1. TASK_CODE

[top of page]

GCS.GCS_SYSTEM_TASKS does not reference any database object

GCS.GCS_SYSTEM_TASKS is referenced by following:

APPS
SYNONYM - GCS_SYSTEM_TASKS

[top of page]

Table: GCS_TRANSLATION_STATUSES

Description: GCS translation status information
Primary Key: GCS_TRANSLATION_STATUSES_PK
  1. HIERARCHY_ID
  2. ENTITY_ID
  3. CURRENCY_CODE
  4. CAL_PERIOD_ID
  5. DATASET_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_TRANSLATION_STATUSES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_TRANSLATION_STATUSES.CURRENCY_CODE FND_CURRENCIES

[top of page]

GCS.GCS_TRANSLATION_STATUSES does not reference any database object

GCS.GCS_TRANSLATION_STATUSES is referenced by following:

APPS
SYNONYM - GCS_TRANSLATION_STATUSES

[top of page]

Table: GCS_TRANSLATION_TRACK_H

Description: GCS translation tracking information
Primary Key: GCS_TRANSLATION_TRACK_H_PK
  1. HIERARCHY_ID
  2. ENTITY_ID
  3. CURRENCY_CODE
  4. DATASET_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_TRANSLATION_TRACK_H.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_TRANSLATION_TRACK_H.CURRENCY_CODE FND_CURRENCIES

[top of page]

GCS.GCS_TRANSLATION_TRACK_H does not reference any database object

GCS.GCS_TRANSLATION_TRACK_H is referenced by following:

APPS
SYNONYM - GCS_TRANSLATION_TRACK_H

[top of page]

Table: GCS_TREATMENTS_B

Description: Consolidation treatments
Primary Key: GCS_TREATMENTS_B_PK
  1. TREATMENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_RELATIONSHIPS.TREATMENT_ID GCS_TREATMENTS_B

[top of page]

GCS.GCS_TREATMENTS_B does not reference any database object

GCS.GCS_TREATMENTS_B is referenced by following:

APPS
SYNONYM - GCS_TREATMENTS_B

[top of page]

Table: GCS_TREATMENTS_TL

Description: Translation table for consolidation treatments
Primary Key: GCS_TREATMENTS_TL_PK
  1. TREATMENT_ID
  2. LANGUAGE

[top of page]

GCS.GCS_TREATMENTS_TL does not reference any database object

GCS.GCS_TREATMENTS_TL is referenced by following:

APPS
SYNONYM - GCS_TREATMENTS_TL

[top of page]

Table: GCS_WRITEBACK_HEADERS

Description: Stores header information for General Ledger writeback

[top of page]

GCS.GCS_WRITEBACK_HEADERS does not reference any database object

GCS.GCS_WRITEBACK_HEADERS is referenced by following:

APPS
SYNONYM - GCS_WRITEBACK_HEADERS

[top of page]

Table: GCS_WRITEBACK_LINES

Description: Stores line level detail information for General Ledger writeback

[top of page]

GCS.GCS_WRITEBACK_LINES does not reference any database object

GCS.GCS_WRITEBACK_LINES is referenced by following:

APPS
SYNONYM - GCS_WRITEBACK_LINES

[top of page]

Table: GCS_XML_FILES

Description: XML generated for XML Publisher reporting
Primary Key: GCS_XML_FILES_PK
  1. XML_FILE_ID
  2. XML_FILE_TYPE
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_XML_FILES.LANGUAGE FND_LANGUAGES

[top of page]

GCS.GCS_XML_FILES does not reference any database object

GCS.GCS_XML_FILES is referenced by following:

APPS
SYNONYM - GCS_XML_FILES

[top of page]

View: GCS_ACTIVE_DIMS_V

[top of page]

APPS.GCS_ACTIVE_DIMS_V references the following:

APPS
SYNONYM - FEM_APP_GRP_COL_EXCLSNS
SYNONYM - FEM_TAB_COLUMNS_TL
SYNONYM - FEM_TAB_COLUMN_PROP

APPS.GCS_ACTIVE_DIMS_V is not referenced by any database object

[top of page]

View: GCS_CATEGORIES_VL

[top of page]

APPS.GCS_CATEGORIES_VL references the following:

APPS
SYNONYM - GCS_CATEGORIES_B
SYNONYM - GCS_CATEGORIES_TL

APPS.GCS_CATEGORIES_VL is not referenced by any database object

[top of page]

View: GCS_CURR_TREATMENTS_VL

[top of page]

APPS.GCS_CURR_TREATMENTS_VL references the following:

APPS
SYNONYM - GCS_CURR_TREATMENTS_B
SYNONYM - GCS_CURR_TREATMENTS_TL

APPS.GCS_CURR_TREATMENTS_VL is not referenced by any database object

[top of page]

View: GCS_DATA_TYPE_CODES_VL

[top of page]

APPS.GCS_DATA_TYPE_CODES_VL references the following:

APPS
SYNONYM - GCS_DATA_TYPE_CODES_B
SYNONYM - GCS_DATA_TYPE_CODES_TL
APPS.GCS_DATA_TYPE_CODES_VL is referenced by following:

APPS
PACKAGE BODY - GCS_XML_DT_UTILITY_PKG

[top of page]

View: GCS_ELIM_RULES_VL

[top of page]

APPS.GCS_ELIM_RULES_VL references the following:

APPS
SYNONYM - GCS_ELIM_RULES_B
SYNONYM - GCS_ELIM_RULES_TL
APPS.GCS_ELIM_RULES_VL is referenced by following:

APPS
PACKAGE BODY - GCS_AD_ENGINE
PACKAGE BODY - GCS_ENTRY_PKG

[top of page]

View: GCS_ELIM_RULE_STEPS_VL

[top of page]

APPS.GCS_ELIM_RULE_STEPS_VL references the following:

APPS
SYNONYM - GCS_ELIM_RULE_STEPS_B
SYNONYM - GCS_ELIM_RULE_STEPS_TL
APPS.GCS_ELIM_RULE_STEPS_VL is referenced by following:

APPS
PACKAGE BODY - GCS_RULES_PROCESSOR

[top of page]

View: GCS_FEM_ACTIVE_DIMS_V

[top of page]

APPS.GCS_FEM_ACTIVE_DIMS_V references the following:

APPS
SYNONYM - FEM_TAB_COLUMNS_TL
SYNONYM - FEM_TAB_COLUMN_PROP

APPS.GCS_FEM_ACTIVE_DIMS_V is not referenced by any database object

[top of page]

View: GCS_FINANCIAL_ITEMS_HIER_V

[top of page]

APPS.GCS_FINANCIAL_ITEMS_HIER_V references the following:

APPS
SYNONYM - GCS_HIERARCHIES_B

APPS.GCS_FINANCIAL_ITEMS_HIER_V is not referenced by any database object

[top of page]

View: GCS_FINANCIAL_ITEMS_V

[top of page]

APPS.GCS_FINANCIAL_ITEMS_V references the following:

APPS
SYNONYM - FND_NEW_MESSAGES
SYNONYM - GCS_HIERARCHIES_B

APPS.GCS_FINANCIAL_ITEMS_V is not referenced by any database object

[top of page]

View: GCS_FIN_STMTS_V

[top of page]

APPS.GCS_FIN_STMTS_V references the following:

APPS
SYNONYM - GCS_HIERARCHIES_B

APPS.GCS_FIN_STMTS_V is not referenced by any database object

[top of page]

View: GCS_FIN_STMT_DTLS_V

[top of page]

APPS.GCS_FIN_STMT_DTLS_V references the following:

APPS
SYNONYM - GCS_HIERARCHIES_B
SYNONYM - GCS_HIERARCHIES_TL

APPS.GCS_FIN_STMT_DTLS_V is not referenced by any database object

[top of page]

View: GCS_GL_JI_GROUPS_V

[top of page]

APPS.GCS_GL_JI_GROUPS_V references the following:

APPS
SYNONYM - GL_INTERFACE
SYNONYM - GL_INTERFACE_CONTROL
SYNONYM - GL_JE_SOURCES

APPS.GCS_GL_JI_GROUPS_V is not referenced by any database object

[top of page]

View: GCS_HIERARCHIES_VL

[top of page]

APPS.GCS_HIERARCHIES_VL references the following:

APPS
SYNONYM - GCS_HIERARCHIES_B
SYNONYM - GCS_HIERARCHIES_TL
APPS.GCS_HIERARCHIES_VL is referenced by following:

APPS
PACKAGE BODY - GCS_FEM_HIER_SYNC_PKG

[top of page]

View: GCS_ITEMS_TO_NAT_ACCTS_V

[top of page]

APPS.GCS_ITEMS_TO_NAT_ACCTS_V references the following:

APPS
SYNONYM - FEM_GLOBAL_VS_COMBO_DEFS
SYNONYM - FEM_LN_ITEMS_B
SYNONYM - FEM_LN_ITEMS_HIER
SYNONYM - FEM_OBJECT_DEFINITION_B
SYNONYM - GCS_HIERARCHIES_B
SYNONYM - GCS_SYSTEM_OPTIONS

APPS.GCS_ITEMS_TO_NAT_ACCTS_V is not referenced by any database object

[top of page]

View: GCS_LEX_MAP_SEQUENCES_V

[top of page]

APPS.GCS_LEX_MAP_SEQUENCES_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - GCS_LEX_MAP_DERIVATIONS
PACKAGE - GCS_LEX_MAP_PKG

APPS.GCS_LEX_MAP_SEQUENCES_V is not referenced by any database object

[top of page]

View: GCS_NAT_ACCTS_HIER_V

[top of page]

APPS.GCS_NAT_ACCTS_HIER_V references the following:

APPS
SYNONYM - FEM_GLOBAL_VS_COMBO_DEFS
SYNONYM - FEM_LN_ITEMS_B
SYNONYM - FEM_LN_ITEMS_HIER
SYNONYM - FEM_OBJECT_DEFINITION_B
SYNONYM - GCS_SYSTEM_OPTIONS

APPS.GCS_NAT_ACCTS_HIER_V is not referenced by any database object

[top of page]

View: GCS_NAT_ACCTS_V

[top of page]

APPS.GCS_NAT_ACCTS_V references the following:

APPS
SYNONYM - FEM_GLOBAL_VS_COMBO_DEFS
SYNONYM - FEM_LN_ITEMS_TL
SYNONYM - GCS_SYSTEM_OPTIONS

APPS.GCS_NAT_ACCTS_V is not referenced by any database object

[top of page]

View: GCS_TREATMENTS_VL

[top of page]

APPS.GCS_TREATMENTS_VL references the following:

APPS
SYNONYM - GCS_TREATMENTS_B
SYNONYM - GCS_TREATMENTS_TL

APPS.GCS_TREATMENTS_VL is not referenced by any database object

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