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

TABLE - GMS.GMS_269_HISTORY
TABLE - GMS.GMS_270_HISTORY
TABLE - GMS.GMS_272_HISTORY
TABLE - GMS.GMS_ALLOWABILITY_SCHEDULES
TABLE - GMS.GMS_ALLOWABLE_EXPENDITURES
TABLE - GMS.GMS_AWARDS_ALL
TABLE - GMS.GMS_AWARDS_CONTACTS
TABLE - GMS.GMS_AWARDS_TERMS_CONDITIONS
TABLE - GMS.GMS_AWARD_DISTRIBUTIONS
TABLE - GMS.GMS_AWARD_EXP_TYPE_ACT_COST
TABLE - GMS.GMS_BALANCES
TABLE - GMS.GMS_BC_PACKETS
TABLE - GMS.GMS_BC_PACKETS_BVID
TABLE - GMS.GMS_BC_PACKETS_SUMMARY
TABLE - GMS.GMS_BC_PACKET_ARRIVAL_ORDER
TABLE - GMS.GMS_BILLING_CANCELLATIONS
TABLE - GMS.GMS_BILLING_FORMS
TABLE - GMS.GMS_BUDGETARY_CONTROLS
TABLE - GMS.GMS_BUDGET_LINES
TABLE - GMS.GMS_BUDGET_VERSIONS
TABLE - GMS.GMS_BURDEN_ADJUSTMENTS_LOG
TABLE - GMS.GMS_BURDEN_COMPONENTS
TABLE - GMS.GMS_CONCURRENCY_CONTROL
TABLE - GMS.GMS_DEFAULT_REPORTS
TABLE - GMS.GMS_DISTRIBUTIONS
TABLE - GMS.GMS_DISTRIBUTION_DETAILS
TABLE - GMS.GMS_ENCUMBRANCES_ALL
TABLE - GMS.GMS_ENCUMBRANCE_GROUPS_ALL
TABLE - GMS.GMS_ENCUMBRANCE_ITEMS_ALL
TABLE - GMS.GMS_EVENT_ATTRIBUTE
TABLE - GMS.GMS_EVENT_INTERSECT
TABLE - GMS.GMS_FP_DISTRIBUTIONS
TABLE - GMS.GMS_FUNDING_PATTERNS_ALL
TABLE - GMS.GMS_IMPLEMENTATIONS_ALL
TABLE - GMS.GMS_IND_COST_CODES
TABLE - GMS.GMS_INSTALLMENTS
TABLE - GMS.GMS_NOTIFICATIONS
TABLE - GMS.GMS_OVERRIDE_SCHEDULES
TABLE - GMS.GMS_PERSONNEL
TABLE - GMS.GMS_PROJECT_FUNDINGS
TABLE - GMS.GMS_PROJECT_TYPES_ALL
TABLE - GMS.GMS_REFERENCE_NUMBERS
TABLE - GMS.GMS_REPORTS
TABLE - GMS.GMS_REPORT_TEMPLATES
TABLE - GMS.GMS_RESOURCE_ASSIGNMENTS
TABLE - GMS.GMS_SUMMARY_PROJECT_FUNDINGS
TABLE - GMS.GMS_TC_CATEGORIES
TABLE - GMS.GMS_TERMS_CONDITIONS
TABLE - GMS.GMS_TRANSACTION_INTERFACE_ALL
TABLE - GMS.GMS_UNIQUE_IDENTIFIER_CONTROL
TABLE - GMS.GMS_WF_PROCESSES
VIEW - APPS.GMS_1034_REPORT_V
VIEW - APPS.GMS_ACT_PROJECTS_BASIC_V
VIEW - APPS.GMS_AWARDS_BASIC_V
VIEW - APPS.GMS_AWARDS_SRS_V
VIEW - APPS.GMS_AWARDS_V
VIEW - APPS.GMS_AWARD_BAL_V
VIEW - APPS.GMS_AWARD_PROJECTS_V
VIEW - APPS.GMS_AWARD_STATUS_V
VIEW - APPS.GMS_AWD_V
VIEW - APPS.GMS_BILL_AWARD_PROJECTS_V
VIEW - APPS.GMS_BUDGETARY_CONTROL_AWARD_V
VIEW - APPS.GMS_BUDGETARY_CONTROL_PROJ_V
VIEW - APPS.GMS_BUDGETARY_CONTROL_TASK_V
VIEW - APPS.GMS_BUDGET_CHANGE_REASON_V
VIEW - APPS.GMS_BUDGET_LINES_V
VIEW - APPS.GMS_BUDGET_MATRIX_V
VIEW - APPS.GMS_BUDGET_VERSIONS_BASELND_V
VIEW - APPS.GMS_BUDGET_VERSIONS_DRAFT_V
VIEW - APPS.GMS_BUDG_CONTROL_RES_GRP_V
VIEW - APPS.GMS_CDL_BURDEN_DETAIL_V
VIEW - APPS.GMS_COMMITMENTS_OVERRIDE_V
VIEW - APPS.GMS_COMMITMENT_BURDEN_V
VIEW - APPS.GMS_COMMITMENT_ENCUMBERED_V
VIEW - APPS.GMS_COMMITMENT_TXNS_V
VIEW - APPS.GMS_CONTACTS_V
VIEW - APPS.GMS_DEFAULT_REPORTS_V
VIEW - APPS.GMS_DRAFT_INVOICES_V
VIEW - APPS.GMS_DRAFT_INV_LINE_DETAILS_V
VIEW - APPS.GMS_DRAFT_REVENUES_V
VIEW - APPS.GMS_DTRANGE_BAL_V
VIEW - APPS.GMS_EMPLOYEES
VIEW - APPS.GMS_ENCUMBRANCES_V
VIEW - APPS.GMS_ENCUMBRANCE_GROUPS_V
VIEW - APPS.GMS_ENCUMBRANCE_ITEMS_V
VIEW - APPS.GMS_ENC_PSI_V
VIEW - APPS.GMS_EVENTS_V
VIEW - APPS.GMS_EXPEND_ITEMS_ADJUST_V
VIEW - APPS.GMS_FP_DISTRIBUTIONS_V
VIEW - APPS.GMS_FUNDING_AWARDS_V
VIEW - APPS.GMS_FUNDING_PATTERNS_V
VIEW - APPS.GMS_FUNDSCTL_RES_V
VIEW - APPS.GMS_FUNDSCTL_V
VIEW - APPS.GMS_INSTALLMENTS_V
VIEW - APPS.GMS_IP_AWARD_LOV_V
VIEW - APPS.GMS_KEY_MEMBER_ROLE_V
VIEW - APPS.GMS_LOC_CONTACTS_V
VIEW - APPS.GMS_LOOKUPS
VIEW - APPS.GMS_NONE_BAL_V
VIEW - APPS.GMS_NOTIFICATIONS_V
VIEW - APPS.GMS_OPERATING_UNITS_V
VIEW - APPS.GMS_OVERRIDE_SCHEDULES_V
VIEW - APPS.GMS_PERSONNEL_V
VIEW - APPS.GMS_PHONE_CONTACTS_V
VIEW - APPS.GMS_PQH_AWARDS_V
VIEW - APPS.GMS_PQH_EXP_TYPES_V
VIEW - APPS.GMS_PQH_PROJECTS_V
VIEW - APPS.GMS_PROJECTS_BASIC_V
VIEW - APPS.GMS_PROJECTS_BURDEN_V
VIEW - APPS.GMS_PROJECTS_EXPEND_V
VIEW - APPS.GMS_PROJECTS_V
VIEW - APPS.GMS_PROJECT_FUNDINGS_V
VIEW - APPS.GMS_PROJECT_TYPES
VIEW - APPS.GMS_REFERENCE_NUMBERS_V
VIEW - APPS.GMS_REPORTS_V
VIEW - APPS.GMS_REPORT_TEMPLATES_V
VIEW - APPS.GMS_RESG_BAL_V
VIEW - APPS.GMS_RESG_BC_V
VIEW - APPS.GMS_RESG_V
VIEW - APPS.GMS_RES_V
VIEW - APPS.GMS_SSA_AWARDS_V
VIEW - APPS.GMS_SSA_AWARD_EXPTYPE_V
VIEW - APPS.GMS_STATUS_ACCUM_PROJECT_V
VIEW - APPS.GMS_STATUS_ACCUM_PROJ_BASE_V
VIEW - APPS.GMS_STATUS_ACCUM_TASK_BASE_V
VIEW - APPS.GMS_STATUS_ACTUALS_BASE1_V
VIEW - APPS.GMS_STATUS_ACTUALS_BASE2_V
VIEW - APPS.GMS_STATUS_ACTUALS_V
VIEW - APPS.GMS_STATUS_AWARD_ACCUM_BASE_V
VIEW - APPS.GMS_STATUS_AWARD_ACCUM_TASK_V
VIEW - APPS.GMS_STATUS_AWARD_ACCUM_V
VIEW - APPS.GMS_STATUS_COMMITMENTS_V
VIEW - APPS.GMS_STATUS_PROJ_GENERIC_V
VIEW - APPS.GMS_STATUS_RESOURCES_BASE_V
VIEW - APPS.GMS_STATUS_RESOURCES_V
VIEW - APPS.GMS_SUM_PRJ_FUNDINGS_V
VIEW - APPS.GMS_TASK_BAL_V
VIEW - APPS.GMS_TASK_BUDGETS2_V
VIEW - APPS.GMS_TASK_BUDGETS_V
VIEW - APPS.GMS_TASK_V
VIEW - APPS.GMS_TERMS_CONDITIONS_V
VIEW - APPS.GMS_XLA_AWARD_REF_V

Table: GMS_269_HISTORY

Description: Financial status report for an award
Primary Key: GMS_269_HISTORY_PK
  1. AWARD_ID
  2. VERSION
  3. STATUS_CODE

[top of page]

GMS.GMS_269_HISTORY does not reference any database object

GMS.GMS_269_HISTORY is referenced by following:

APPS
SYNONYM - GMS_269_HISTORY

[top of page]

Table: GMS_270_HISTORY

Description: Financial status report for an award

[top of page]

GMS.GMS_270_HISTORY does not reference any database object

GMS.GMS_270_HISTORY is referenced by following:

APPS
SYNONYM - GMS_270_HISTORY

[top of page]

Table: GMS_272_HISTORY

Description: Federal cash transaction report
Primary Key: GMS_272_HISTORY_PK
  1. AWARD_ID
  2. VERSION
  3. STATUS_CODE

[top of page]

GMS.GMS_272_HISTORY does not reference any database object

GMS.GMS_272_HISTORY is referenced by following:

APPS
SYNONYM - GMS_272_HISTORY

[top of page]

Table: GMS_ALLOWABILITY_SCHEDULES

Description: Cost allowability schedules

[top of page]

GMS.GMS_ALLOWABILITY_SCHEDULES does not reference any database object

GMS.GMS_ALLOWABILITY_SCHEDULES is referenced by following:

APPS
SYNONYM - GMS_ALLOWABILITY_SCHEDULES

[top of page]

Table: GMS_ALLOWABLE_EXPENDITURES

Description: Allowable expenditures of cost allowability schedule
Primary Key: GMS_ALLOWABLE_EXPENDITURES_PK
  1. ALLOWABILITY_SCHEDULE_ID
  2. EXPENDITURE_TYPE

[top of page]

GMS.GMS_ALLOWABLE_EXPENDITURES does not reference any database object

GMS.GMS_ALLOWABLE_EXPENDITURES is referenced by following:

APPS
SYNONYM - GMS_ALLOWABLE_EXPENDITURES

[top of page]

Table: GMS_AWARDS_ALL

Description: Information about awards
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_AWARDS_ALL.IDC_SCHEDULE_ID PA_IND_RATE_SCHEDULES_ALL_BG
GMS_AWARDS_ALL.AWARD_PROJECT_ID PA_PROJECTS_ALL

[top of page]

GMS.GMS_AWARDS_ALL does not reference any database object

GMS.GMS_AWARDS_ALL is referenced by following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_AWARDS_ALL

[top of page]

Table: GMS_AWARDS_CONTACTS

Description: Contacts of award

[top of page]

GMS.GMS_AWARDS_CONTACTS does not reference any database object

GMS.GMS_AWARDS_CONTACTS is referenced by following:

APPS
SYNONYM - GMS_AWARDS_CONTACTS

[top of page]

Table: GMS_AWARDS_TERMS_CONDITIONS

Description: Terms and conditions of award

[top of page]

GMS.GMS_AWARDS_TERMS_CONDITIONS does not reference any database object

GMS.GMS_AWARDS_TERMS_CONDITIONS is referenced by following:

APPS
SYNONYM - GMS_AWARDS_TERMS_CONDITIONS

[top of page]

Table: GMS_AWARD_DISTRIBUTIONS

Description: Distribution lines for requisitions, purchase orders, invoices, encumbrances, and Project expenditures charged to awards
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_AWARD_DISTRIBUTIONS.DISTRIBUTION_ID PO_REQ_DISTRIBUTIONS_ALL
GMS_AWARD_DISTRIBUTIONS.PO_DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL

[top of page]

GMS.GMS_AWARD_DISTRIBUTIONS does not reference any database object

GMS.GMS_AWARD_DISTRIBUTIONS is referenced by following:

APPS
SYNONYM - GMS_AWARD_DISTRIBUTIONS

[top of page]

Table: GMS_AWARD_EXP_TYPE_ACT_COST

Description: Actual expense incurred for an award by expenditure type
Primary Key: GMS_AWARD_EXP_TYPE_ACT_COST_PK
  1. AWARD_ID
  2. EXPENDITURE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_AWARD_EXP_TYPE_ACT_COST.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES

[top of page]

GMS.GMS_AWARD_EXP_TYPE_ACT_COST does not reference any database object

GMS.GMS_AWARD_EXP_TYPE_ACT_COST is referenced by following:

APPS
SYNONYM - GMS_AWARD_EXP_TYPE_ACT_COST

[top of page]

Table: GMS_BALANCES

Description: Balance of budgets, actual costs, and encumbrance costs
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BALANCES.PROJECT_ID PA_PROJECTS_ALL
GMS_BALANCES.TASK_ID PA_TASKS
GMS_BALANCES.RESOURCE_LIST_MEMBER_ID PA_RESOURCE_LIST_MEMBERS
GMS_BALANCES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
GMS_BALANCES.BUDGET_VERSION_ID PA_BUDGET_VERSIONS
GMS_BALANCES.PARENT_MEMBER_ID PA_RESOURCE_LIST_MEMBERS

[top of page]

GMS.GMS_BALANCES does not reference any database object

GMS.GMS_BALANCES is referenced by following:

APPS
SYNONYM - GMS_BALANCES

[top of page]

Table: GMS_BC_PACKETS

Description: Budgetary control packets for funds checking
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BC_PACKETS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
GMS_BC_PACKETS.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
GMS_BC_PACKETS.PROJECT_ID PA_PROJECTS_ALL
GMS_BC_PACKETS.TASK_ID PA_TASKS
GMS_BC_PACKETS.TOP_TASK_ID PA_TASKS

[top of page]

GMS.GMS_BC_PACKETS does not reference any database object

GMS.GMS_BC_PACKETS is referenced by following:

APPS
SYNONYM - GMS_BC_PACKETS

[top of page]

Table: GMS_BC_PACKETS_BVID

Description: This is a temporary summary table used in the funds check process to store distinct budget versions present in current packets. After the funds check process ends, records are deleted from this table.

[top of page]

GMS.GMS_BC_PACKETS_BVID does not reference any database object

GMS.GMS_BC_PACKETS_BVID is referenced by following:

APPS
SYNONYM - GMS_BC_PACKETS_BVID

[top of page]

Table: GMS_BC_PACKETS_SUMMARY

Description: This is a temporary summary table used in the funds check process to store actual and encumbrance amounts for current and previous packets. After the funds check process ends, records are deleted from this table.

[top of page]

GMS.GMS_BC_PACKETS_SUMMARY does not reference any database object

GMS.GMS_BC_PACKETS_SUMMARY is referenced by following:

APPS
SYNONYM - GMS_BC_PACKETS_SUMMARY

[top of page]

Table: GMS_BC_PACKET_ARRIVAL_ORDER

Description: This table stores the execution order for the packets. This table is populated during the funds check process, and the records are deleted once the GMS: Update actual and encumbrance balance process is run.

[top of page]

GMS.GMS_BC_PACKET_ARRIVAL_ORDER does not reference any database object

GMS.GMS_BC_PACKET_ARRIVAL_ORDER is referenced by following:

APPS
SYNONYM - GMS_BC_PACKET_ARRIVAL_ORDER

[top of page]

Table: GMS_BILLING_CANCELLATIONS

Description: Journal of deleted billing event distributions for deleted, cancelled revenue, or invoices

[top of page]

GMS.GMS_BILLING_CANCELLATIONS does not reference any database object

GMS.GMS_BILLING_CANCELLATIONS is referenced by following:

APPS
SYNONYM - GMS_BILLING_CANCELLATIONS

[top of page]

Table: GMS_BILLING_FORMS

Description: Implementation-defined billing forms

[top of page]

GMS.GMS_BILLING_FORMS does not reference any database object

GMS.GMS_BILLING_FORMS is referenced by following:

APPS
SYNONYM - GMS_BILLING_FORMS

[top of page]

Table: GMS_BUDGETARY_CONTROLS

Description: Budgetary control level for awards, tasks, resource groups, and resources
Primary Key: GMS_BUDGETARY_CONTROLS_PK
  1. BUDGETARY_CONTROLS_ID

[top of page]

GMS.GMS_BUDGETARY_CONTROLS does not reference any database object

GMS.GMS_BUDGETARY_CONTROLS is referenced by following:

APPS
SYNONYM - GMS_BUDGETARY_CONTROLS

[top of page]

Table: GMS_BUDGET_LINES

Description: Detail lines of project and task budgets
Primary Key: GMS_BUDGET_LINES_PK
  1. RESOURCE_ASSIGNMENT_ID
  2. START_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID GMS_RESOURCE_ASSIGNMENTS

[top of page]

GMS.GMS_BUDGET_LINES does not reference any database object

GMS.GMS_BUDGET_LINES is referenced by following:

APPS
SYNONYM - GMS_BUDGET_LINES

[top of page]

Table: GMS_BUDGET_VERSIONS

Description: Versions of award budgets
Primary Key: GMS_BUDGET_VERSIONS_PK
  1. BUDGET_VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BUDGET_VERSIONS.RESOURCE_LIST_ID PA_RESOURCE_LISTS_ALL_BG
GMS_BUDGET_VERSIONS.BUDGET_ENTRY_METHOD_CODE PA_BUDGET_ENTRY_METHODS
GMS_BUDGET_VERSIONS.BUDGET_TYPE_CODE PA_BUDGET_TYPES
GMS_BUDGET_VERSIONS.PROJECT_ID PA_PROJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMS_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID GMS_BUDGET_VERSIONS

[top of page]

GMS.GMS_BUDGET_VERSIONS does not reference any database object

GMS.GMS_BUDGET_VERSIONS is referenced by following:

APPS
SYNONYM - GMS_BUDGET_VERSIONS

[top of page]

Table: GMS_BURDEN_ADJUSTMENTS_LOG

Description: Journal of burdenable raw cost adjustments

[top of page]

GMS.GMS_BURDEN_ADJUSTMENTS_LOG does not reference any database object

GMS.GMS_BURDEN_ADJUSTMENTS_LOG is referenced by following:

APPS
SYNONYM - GMS_BURDEN_ADJUSTMENTS_LOG

[top of page]

Table: GMS_BURDEN_COMPONENTS

Description: Burden components of billing events
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BURDEN_COMPONENTS.EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL

[top of page]

GMS.GMS_BURDEN_COMPONENTS does not reference any database object

GMS.GMS_BURDEN_COMPONENTS is referenced by following:

APPS
SYNONYM - GMS_BURDEN_COMPONENTS

[top of page]

Table: GMS_CONCURRENCY_CONTROL

Description: Control table for concurrency control of transactions in Grants Accounting concurrent processes

[top of page]

GMS.GMS_CONCURRENCY_CONTROL does not reference any database object

GMS.GMS_CONCURRENCY_CONTROL is referenced by following:

APPS
SYNONYM - GMS_CONCURRENCY_CONTROL

[top of page]

Table: GMS_DEFAULT_REPORTS

Description: Default reports of award
Primary Key: GMS_DEFAULT_REPORTS_PK
  1. DEFAULT_REPORT_ID

[top of page]

GMS.GMS_DEFAULT_REPORTS does not reference any database object

GMS.GMS_DEFAULT_REPORTS is referenced by following:

APPS
SYNONYM - GMS_DEFAULT_REPORTS

[top of page]

Table: GMS_DISTRIBUTIONS

Description: Header information

[top of page]

GMS.GMS_DISTRIBUTIONS does not reference any database object

GMS.GMS_DISTRIBUTIONS is referenced by following:

APPS
SYNONYM - GMS_DISTRIBUTIONS

[top of page]

Table: GMS_DISTRIBUTION_DETAILS

Description: Details of distribution lines

[top of page]

GMS.GMS_DISTRIBUTION_DETAILS does not reference any database object

GMS.GMS_DISTRIBUTION_DETAILS is referenced by following:

APPS
SYNONYM - GMS_DISTRIBUTION_DETAILS

[top of page]

Table: GMS_ENCUMBRANCES_ALL

Description: Groups of encumbrance items incurred by employees or organizations in an encumbrance batch
Primary Key: GMS_ENCUMBRANCE_GROUPS_PK
  1. ENCUMBRANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_ENCUMBRANCES_ALL.VENDOR_ID PO_VENDORS

[top of page]

GMS.GMS_ENCUMBRANCES_ALL does not reference any database object

GMS.GMS_ENCUMBRANCES_ALL is referenced by following:

APPS
SYNONYM - GMS_ENCUMBRANCES
SYNONYM - GMS_ENCUMBRANCES_ALL

[top of page]

Table: GMS_ENCUMBRANCE_GROUPS_ALL

Description: Groups of pre-approved encumbrances
Primary Key: GMS_ENCUBMBRACE_GROUPS_PK
  1. ENCUMBRANCE_GROUP
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_ENCUMBRANCE_GROUPS_ALL.SYSTEM_LINKAGE_FUNCTION PA_SYSTEM_LINKAGES

[top of page]

GMS.GMS_ENCUMBRANCE_GROUPS_ALL does not reference any database object

GMS.GMS_ENCUMBRANCE_GROUPS_ALL is referenced by following:

APPS
SYNONYM - GMS_ENCUMBRANCE_GROUPS
SYNONYM - GMS_ENCUMBRANCE_GROUPS_ALL

[top of page]

Table: GMS_ENCUMBRANCE_ITEMS_ALL

Description: Manual encumbrance charged to sponsored projects
Primary Key: GMS_ENCUMBRANCE_ITEMS_ALL_PK
  1. ENCUMBRANCE_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_ENCUMBRANCE_ITEMS_ALL.PEL_EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL
GMS_ENCUMBRANCE_ITEMS_ALL.PET_PROJECT_ID
GMS_ENCUMBRANCE_ITEMS_ALL.PET_EVENT_NUM
PA_EVENTS

[top of page]

GMS.GMS_ENCUMBRANCE_ITEMS_ALL does not reference any database object

GMS.GMS_ENCUMBRANCE_ITEMS_ALL is referenced by following:

APPS
SYNONYM - GMS_ENCUMBRANCE_ITEMS
SYNONYM - GMS_ENCUMBRANCE_ITEMS_ALL

[top of page]

Table: GMS_EVENT_ATTRIBUTE

Description: Additional information on billing events for mapping billing event information maintained in PA_EVENTS table
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_EVENT_ATTRIBUTE.PROJECT_ID
GMS_EVENT_ATTRIBUTE.EVENT_NUM
PA_EVENTS

[top of page]

GMS.GMS_EVENT_ATTRIBUTE does not reference any database object

GMS.GMS_EVENT_ATTRIBUTE is referenced by following:

APPS
SYNONYM - GMS_EVENT_ATTRIBUTE

[top of page]

Table: GMS_EVENT_INTERSECT

Description: Relationship between expenditure items and events
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_EVENT_INTERSECT.AWARD_PROJECT_ID
GMS_EVENT_INTERSECT.EVENT_NUM
PA_EVENTS
GMS_EVENT_INTERSECT.EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL

[top of page]

GMS.GMS_EVENT_INTERSECT does not reference any database object

GMS.GMS_EVENT_INTERSECT is referenced by following:

APPS
SYNONYM - GMS_EVENT_INTERSECT

[top of page]

Table: GMS_FP_DISTRIBUTIONS

Description: Stores the funding pattern distribution details for a defined funding pattern
Primary Key: GMS_FP_DIST_PK
  1. FUNDING_PATTERN_ID
  2. AWARD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_FP_DISTRIBUTIONS.FUNDING_PATTERN_ID GMS_FUNDING_PATTERNS_ALL

[top of page]

GMS.GMS_FP_DISTRIBUTIONS does not reference any database object

GMS.GMS_FP_DISTRIBUTIONS is referenced by following:

APPS
SYNONYM - GMS_FP_DISTRIBUTIONS

[top of page]

Table: GMS_FUNDING_PATTERNS_ALL

Description: Rule definition for charging transactions of a sponsored project to funding awards
Primary Key: GMS_FUNDING_PATTERN_PK
  1. FUNDING_PATTERN_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMS_FP_DISTRIBUTIONS.FUNDING_PATTERN_ID GMS_FUNDING_PATTERNS_ALL

[top of page]

GMS.GMS_FUNDING_PATTERNS_ALL does not reference any database object

GMS.GMS_FUNDING_PATTERNS_ALL is referenced by following:

APPS
SYNONYM - GMS_FUNDING_PATTERNS
SYNONYM - GMS_FUNDING_PATTERNS_ALL

[top of page]

Table: GMS_IMPLEMENTATIONS_ALL

Description: Implementation options for award numbering method setup

[top of page]

GMS.GMS_IMPLEMENTATIONS_ALL does not reference any database object

GMS.GMS_IMPLEMENTATIONS_ALL is referenced by following:

APPS
SYNONYM - GMS_IMPLEMENTATIONS
SYNONYM - GMS_IMPLEMENTATIONS_ALL

[top of page]

Table: GMS_IND_COST_CODES

Description: Additional information related to indirect cost codes maintained in PA_IND_COST_CODES
Primary Key: GMS_IND_COST_CODES_U1
  1. IND_COST_CODE

[top of page]

GMS.GMS_IND_COST_CODES does not reference any database object

GMS.GMS_IND_COST_CODES is referenced by following:

APPS
SYNONYM - GMS_IND_COST_CODES

[top of page]

Table: GMS_INSTALLMENTS

Description: Information about installments

[top of page]

GMS.GMS_INSTALLMENTS does not reference any database object

GMS.GMS_INSTALLMENTS is referenced by following:

APPS
SYNONYM - GMS_INSTALLMENTS

[top of page]

Table: GMS_NOTIFICATIONS

Description: Record of notifications sent to users about award events
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_NOTIFICATIONS.USER_ID FND_USER

[top of page]

GMS.GMS_NOTIFICATIONS does not reference any database object

GMS.GMS_NOTIFICATIONS is referenced by following:

APPS
SYNONYM - GMS_NOTIFICATIONS

[top of page]

Table: GMS_OVERRIDE_SCHEDULES

Description: Information about Indirect Cost Rate Override Schedules defined on an award
Primary Key: GMS_OVERRIDE_SCHEDULES_PK
  1. AWARD_ID
  2. PROJECT_ID
Primary Key: GMS_OVERRIDE_SCHEDULES_UK
  1. AWARD_ID
  2. PROJECT_ID
  3. TASK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_OVERRIDE_SCHEDULES.PROJECT_ID PA_PROJECTS_ALL
GMS_OVERRIDE_SCHEDULES.TASK_ID PA_TASKS
GMS_OVERRIDE_SCHEDULES.IDC_SCHEDULE_ID PA_IND_RATE_SCHEDULES_ALL_BG

[top of page]

GMS.GMS_OVERRIDE_SCHEDULES does not reference any database object

GMS.GMS_OVERRIDE_SCHEDULES is referenced by following:

APPS
SYNONYM - GMS_OVERRIDE_SCHEDULES

[top of page]

Table: GMS_PERSONNEL

Description: Personnel of award

[top of page]

GMS.GMS_PERSONNEL does not reference any database object

GMS.GMS_PERSONNEL is referenced by following:

APPS
SYNONYM - GMS_PERSONNEL

[top of page]

Table: GMS_PROJECT_FUNDINGS

Description: Incremental amounts of allocated funds from installments to project and tasks

[top of page]

GMS.GMS_PROJECT_FUNDINGS does not reference any database object

GMS.GMS_PROJECT_FUNDINGS is referenced by following:

APPS
SYNONYM - GMS_PROJECT_FUNDINGS

[top of page]

Table: GMS_PROJECT_TYPES_ALL

Description: Additional information on project types maintained in PA_PROJECT_TYPES

[top of page]

GMS.GMS_PROJECT_TYPES_ALL does not reference any database object

GMS.GMS_PROJECT_TYPES_ALL is referenced by following:

APPS
SYNONYM - GMS_PROJECT_TYPES_ALL

[top of page]

Table: GMS_REFERENCE_NUMBERS

Description: Reference numbers of award
Primary Key: GMS_REFERENCE_NUMBERS_PK
  1. AWARD_ID
  2. TYPE
  3. VALUE

[top of page]

GMS.GMS_REFERENCE_NUMBERS does not reference any database object

GMS.GMS_REFERENCE_NUMBERS is referenced by following:

APPS
SYNONYM - GMS_REFERENCE_NUMBERS

[top of page]

Table: GMS_REPORTS

Description: Reports of installment

[top of page]

GMS.GMS_REPORTS does not reference any database object

GMS.GMS_REPORTS is referenced by following:

APPS
SYNONYM - GMS_REPORTS

[top of page]

Table: GMS_REPORT_TEMPLATES

Description: Implementation-defined report templates

[top of page]

GMS.GMS_REPORT_TEMPLATES does not reference any database object

GMS.GMS_REPORT_TEMPLATES is referenced by following:

APPS
SYNONYM - GMS_REPORT_TEMPLATES

[top of page]

Table: GMS_RESOURCE_ASSIGNMENTS

Description: Resource assignments for a budget version at a branch of project's work breakdown
Primary Key: GMS_RESOURCE_ASSIGNMENTS_PK
  1. RESOURCE_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID GMS_BUDGET_VERSIONS
GMS_RESOURCE_ASSIGNMENTS.PROJECT_ID PA_PROJECTS_ALL
GMS_RESOURCE_ASSIGNMENTS.TASK_ID PA_TASKS
GMS_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID PA_RESOURCE_LIST_MEMBERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMS_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID GMS_RESOURCE_ASSIGNMENTS

[top of page]

GMS.GMS_RESOURCE_ASSIGNMENTS does not reference any database object

GMS.GMS_RESOURCE_ASSIGNMENTS is referenced by following:

APPS
SYNONYM - GMS_RESOURCE_ASSIGNMENTS

[top of page]

Table: GMS_SUMMARY_PROJECT_FUNDINGS

Description: Summary funding amounts allocated from installment to project and tasks

[top of page]

GMS.GMS_SUMMARY_PROJECT_FUNDINGS does not reference any database object

GMS.GMS_SUMMARY_PROJECT_FUNDINGS is referenced by following:

APPS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS

[top of page]

Table: GMS_TC_CATEGORIES

Description: Implementation-defined terms and conditions categories

[top of page]

GMS.GMS_TC_CATEGORIES does not reference any database object

GMS.GMS_TC_CATEGORIES is referenced by following:

APPS
SYNONYM - GMS_TC_CATEGORIES

[top of page]

Table: GMS_TERMS_CONDITIONS

Description: Implementation-defined terms and conditions

[top of page]

GMS.GMS_TERMS_CONDITIONS does not reference any database object

GMS.GMS_TERMS_CONDITIONS is referenced by following:

APPS
SYNONYM - GMS_TERMS_CONDITIONS

[top of page]

Table: GMS_TRANSACTION_INTERFACE_ALL

Description: Extension to PA_TRANSACTION_INTERFACE_ALL to maintain additional information
Primary Key: TXN_INTERFACE_ID_UK
  1. TXN_INTERFACE_ID

[top of page]

GMS.GMS_TRANSACTION_INTERFACE_ALL does not reference any database object

GMS.GMS_TRANSACTION_INTERFACE_ALL is referenced by following:

APPS
SYNONYM - GMS_TRANSACTION_INTERFACE
SYNONYM - GMS_TRANSACTION_INTERFACE_ALL

[top of page]

Table: GMS_UNIQUE_IDENTIFIER_CONTROL

Description: Next award number for automatic award numbering
Primary Key: GMS_UNIQUE_IDENTIFIER_CONT_PK
  1. TABLE_NAME

[top of page]

GMS.GMS_UNIQUE_IDENTIFIER_CONTROL does not reference any database object

GMS.GMS_UNIQUE_IDENTIFIER_CONTROL is referenced by following:

APPS
SYNONYM - GMS_UNIQUE_IDENTIFIER_CONTROL

[top of page]

Table: GMS_WF_PROCESSES

Description: Versions of award and budget workflows. There can be many workflows for an award or budget.

[top of page]

GMS.GMS_WF_PROCESSES does not reference any database object

GMS.GMS_WF_PROCESSES is referenced by following:

APPS
SYNONYM - GMS_WF_PROCESSES

[top of page]

View: GMS_1034_REPORT_V

[top of page]

APPS.GMS_1034_REPORT_V references the following:

APPS
VIEW - GMS_DRAFT_INV_LINE_DETAILS_V
SYNONYM - GMS_IND_COST_CODES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PA_EXPENDITURE_CATEGORIES
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_IND_COST_CODES
PACKAGE - PA_SECURITY
PACKAGE - PA_UTILS4

APPS.GMS_1034_REPORT_V is not referenced by any database object

[top of page]

View: GMS_ACT_PROJECTS_BASIC_V

[top of page]

APPS.GMS_ACT_PROJECTS_BASIC_V references the following:

APPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_PROJECT_TYPES
PACKAGE - PA_SECURITY

APPS.GMS_ACT_PROJECTS_BASIC_V is not referenced by any database object

[top of page]

View: GMS_AWARDS_BASIC_V

[top of page]

APPS.GMS_AWARDS_BASIC_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
APPS.GMS_AWARDS_BASIC_V is referenced by following:

APPS
VIEW - GMS_PQH_AWARDS_V
PACKAGE BODY - PON_CP_INTRFAC_TO_TRANSACTION
PACKAGE BODY - PON_NEGOTIATION_PUBLISH_PVT
PACKAGE BODY - PON_VALIDATE_ITEM_PRICES_INT
PACKAGE BODY - PON_VALIDATE_PAYMENTS_INT
PACKAGE BODY - PSP_POA_BUS
PACKAGE BODY - PSP_PSPENCDU_XMLP_PKG
PACKAGE BODY - PSP_PSPENCSC_XMLP_PKG

[top of page]

View: GMS_AWARDS_SRS_V

[top of page]

APPS.GMS_AWARDS_SRS_V references the following:

APPS
SYNONYM - GMS_AWARDS

APPS.GMS_AWARDS_SRS_V is not referenced by any database object

[top of page]

View: GMS_AWARDS_V

[top of page]

APPS.GMS_AWARDS_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_ALLOWABILITY_SCHEDULES
SYNONYM - GMS_AWARDS
VIEW - GMS_LOOKUPS
VIEW - GMS_OPERATING_UNITS_V
PACKAGE - GMS_SECURITY
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
PACKAGE - MO_GLOBAL
SYNONYM - PA_AGREEMENTS_ALL
VIEW - PA_IND_RATE_SCHEDULES
SYNONYM - PA_INVOICE_FORMATS
SYNONYM - PA_SUMMARY_PROJECT_FUNDINGS
PACKAGE - PA_UTILS
SYNONYM - RA_TERMS
SYS
TABLE - DUAL
APPS.GMS_AWARDS_V is referenced by following:

APPS
PACKAGE BODY - GMS_BUDGET_PUB

[top of page]

View: GMS_AWARD_BAL_V

[top of page]

APPS.GMS_AWARD_BAL_V references the following:

APPS
SYNONYM - GL_PERIOD_STATUSES
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
VIEW - GMS_DTRANGE_BAL_V
VIEW - GMS_NONE_BAL_V
SYNONYM - PA_BUDGET_ENTRY_METHODS
SYNONYM - PA_PERIODS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
APPS.GMS_AWARD_BAL_V is referenced by following:

APPS
VIEW - GMS_AWD_V
VIEW - GMS_RESG_V
VIEW - GMS_RES_V
VIEW - GMS_TASK_BAL_V
VIEW - GMS_TASK_V

[top of page]

View: GMS_AWARD_PROJECTS_V

[top of page]

APPS.GMS_AWARD_PROJECTS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - PA_PROJECTS_ALL

APPS.GMS_AWARD_PROJECTS_V is not referenced by any database object

[top of page]

View: GMS_AWARD_STATUS_V

[top of page]

APPS.GMS_AWARD_STATUS_V references the following:

APPS
VIEW - GMS_LOOKUPS

APPS.GMS_AWARD_STATUS_V is not referenced by any database object

[top of page]

View: GMS_AWD_V

[top of page]

APPS.GMS_AWD_V references the following:

APPS
SYNONYM - GMS_AWARDS
VIEW - GMS_AWARD_BAL_V

APPS.GMS_AWD_V is not referenced by any database object

[top of page]

View: GMS_BILL_AWARD_PROJECTS_V

[top of page]

APPS.GMS_BILL_AWARD_PROJECTS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - PA_PROJECTS_ALL
PACKAGE - PA_SECURITY

APPS.GMS_BILL_AWARD_PROJECTS_V is not referenced by any database object

[top of page]

View: GMS_BUDGETARY_CONTROL_AWARD_V

[top of page]

APPS.GMS_BUDGETARY_CONTROL_AWARD_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BUDGETARY_CONTROLS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
VIEW - PA_RESOURCE_LISTS

APPS.GMS_BUDGETARY_CONTROL_AWARD_V is not referenced by any database object

[top of page]

View: GMS_BUDGETARY_CONTROL_PROJ_V

[top of page]

APPS.GMS_BUDGETARY_CONTROL_PROJ_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_IMPLEMENTATIONS
SYNONYM - PA_PROJECTS_ALL
VIEW - PA_RESOURCE_LISTS

APPS.GMS_BUDGETARY_CONTROL_PROJ_V is not referenced by any database object

[top of page]

View: GMS_BUDGETARY_CONTROL_TASK_V

[top of page]

APPS.GMS_BUDGETARY_CONTROL_TASK_V references the following:

APPS
SYNONYM - GMS_BUDGETARY_CONTROLS
SYNONYM - PA_TASKS

APPS.GMS_BUDGETARY_CONTROL_TASK_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_CHANGE_REASON_V

[top of page]

APPS.GMS_BUDGET_CHANGE_REASON_V references the following:

APPS
VIEW - PA_LOOKUPS

APPS.GMS_BUDGET_CHANGE_REASON_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_LINES_V

[top of page]

APPS.GMS_BUDGET_LINES_V references the following:

APPS
SYNONYM - GMS_BUDGET_LINES
SYNONYM - GMS_RESOURCE_ASSIGNMENTS
VIEW - PA_LOOKUPS
SYNONYM - PA_RESOURCE_LIST_MEMBERS
APPS.GMS_BUDGET_LINES_V is referenced by following:

APPS
PACKAGE BODY - GMS_BUDGET_MATRIX

[top of page]

View: GMS_BUDGET_MATRIX_V

[top of page]

APPS.GMS_BUDGET_MATRIX_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - GMS_BUDGET_LINES
PACKAGE - GMS_BUDGET_MATRIX
SYNONYM - GMS_RESOURCE_ASSIGNMENTS
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_BUDGET_MATRIX_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_VERSIONS_BASELND_V

[top of page]

APPS.GMS_BUDGET_VERSIONS_BASELND_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGET_VERSIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
VIEW - PA_LOOKUPS
VIEW - PA_RESOURCE_LISTS
VIEW - PER_PEOPLE_F

APPS.GMS_BUDGET_VERSIONS_BASELND_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_VERSIONS_DRAFT_V

[top of page]

APPS.GMS_BUDGET_VERSIONS_DRAFT_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGET_VERSIONS
PACKAGE - GMS_SECURITY
SYNONYM - PA_BUDGET_ENTRY_METHODS
SYNONYM - PA_BUDGET_TYPES
PACKAGE - PA_CROSS_BUSINESS_GRP
VIEW - PA_LOOKUPS
VIEW - PA_RESOURCE_LISTS
SYS
TABLE - DUAL

APPS.GMS_BUDGET_VERSIONS_DRAFT_V is not referenced by any database object

[top of page]

View: GMS_BUDG_CONTROL_RES_GRP_V

[top of page]

APPS.GMS_BUDG_CONTROL_RES_GRP_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGETARY_CONTROLS
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_RESOURCES
VIEW - PA_RESOURCE_LISTS
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_BUDG_CONTROL_RES_GRP_V is not referenced by any database object

[top of page]

View: GMS_CDL_BURDEN_DETAIL_V

[top of page]

APPS.GMS_CDL_BURDEN_DETAIL_V references the following:

APPS
SYNONYM - GMS_AWARD_DISTRIBUTIONS
PACKAGE - GMS_BURDEN_COSTING
SYNONYM - PA_COMPILED_MULTIPLIERS
SYNONYM - PA_COST_BASES
SYNONYM - PA_COST_BASE_EXP_TYPES
SYNONYM - PA_COST_DISTRIBUTION_LINES_ALL
SYNONYM - PA_EXPENDITURES_ALL
SYNONYM - PA_EXPENDITURE_ITEMS_ALL
SYNONYM - PA_IND_COMPILED_SETS
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_IND_RATE_SCHEDULES_ALL_BG
SYNONYM - PA_IND_RATE_SCH_REVISIONS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_PROJECT_TYPES
SYNONYM - PA_TRANSACTION_SOURCES
APPS.GMS_CDL_BURDEN_DETAIL_V is referenced by following:

APPS
PACKAGE BODY - GMS_REPORT_SF269
PACKAGE BODY - GMS_REPORT_SF270
PACKAGE BODY - GMS_REPORT_SF272

[top of page]

View: GMS_COMMITMENTS_OVERRIDE_V

[top of page]

APPS.GMS_COMMITMENTS_OVERRIDE_V references the following:

APPS
PACKAGE - AP_INVOICES_PKG
SYNONYM - CST_PROJMFG_CMT_VIEW
PACKAGE - GMS_COST_PLUS_EXTN
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_ACCUM_UTILS
PACKAGE - PA_BURDEN_CMTS
PACKAGE - PA_CMT_UTILS
PACKAGE - PA_CURRENCY
PACKAGE - PA_MULTI_CURRENCY
PACKAGE - PA_PJC_CWK_UTILS
VIEW - PA_PROJ_AP_INV_DISTRIBUTIONS
VIEW - PA_PROJ_PO_DISTRIBUTIONS
VIEW - PA_PROJ_REQ_DISTRIBUTIONS
SYNONYM - PJM_PO_COMMITMENTS_V
SYNONYM - PJM_REQ_COMMITMENTS_V
APPS.GMS_COMMITMENTS_OVERRIDE_V is referenced by following:

APPS
VIEW - GMS_COMMITMENT_TXNS_V

[top of page]

View: GMS_COMMITMENT_BURDEN_V

[top of page]

APPS.GMS_COMMITMENT_BURDEN_V references the following:

APPS
PACKAGE - GMS_BUDGET_BALANCE
VIEW - GMS_COMMITMENT_ENCUMBERED_V
PACKAGE - PA_CMT_UTILS
SYNONYM - PA_COMPILED_MULTIPLIERS
SYNONYM - PA_COST_BASE_EXP_TYPES
SYNONYM - PA_IND_COMPILED_SETS
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_IND_RATE_SCH_REVISIONS
PACKAGE - PO_INTG_DOCUMENT_FUNDS_GRP
APPS.GMS_COMMITMENT_BURDEN_V is referenced by following:

APPS
VIEW - GMS_STATUS_COMMITMENTS_V

[top of page]

View: GMS_COMMITMENT_ENCUMBERED_V

[top of page]

APPS.GMS_COMMITMENT_ENCUMBERED_V references the following:

APPS
SYNONYM - AP_INVOICES_ALL
SYNONYM - AP_INVOICE_DISTRIBUTIONS_ALL
SYNONYM - GL_LEDGERS
SYNONYM - GMS_AWARD_DISTRIBUTIONS
PACKAGE - GMS_BUDGET_BALANCE
SYNONYM - GMS_ENCUMBRANCES_ALL
SYNONYM - GMS_ENCUMBRANCE_ITEMS_ALL
PACKAGE - PA_CMT_UTILS
SYNONYM - PA_PERIODS
SYNONYM - PA_TRANSACTION_SOURCES
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HEADERS_ALL
PACKAGE - PO_INTG_DOCUMENT_FUNDS_GRP
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_LINE_TYPES
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
SYNONYM - PO_REQ_DISTRIBUTIONS_ALL
VIEW - PO_VENDORS
APPS.GMS_COMMITMENT_ENCUMBERED_V is referenced by following:

APPS
VIEW - GMS_COMMITMENT_BURDEN_V
PACKAGE BODY - GMS_WF_PKG

[top of page]

View: GMS_COMMITMENT_TXNS_V

[top of page]

APPS.GMS_COMMITMENT_TXNS_V references the following:

APPS
PACKAGE - AP_INVOICES_PKG
VIEW - GMS_COMMITMENTS_OVERRIDE_V
PACKAGE - GMS_COST_PLUS_EXTN
VIEW - GMS_ENC_PSI_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_ACCUM_UTILS
PACKAGE - PA_BURDEN_CMTS
PACKAGE - PA_CMT_UTILS
SYNONYM - PA_COMPILED_MULTIPLIERS
SYNONYM - PA_COST_BASE_EXP_TYPES
PACKAGE - PA_CURRENCY
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_IND_COMPILED_SETS
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_IND_RATE_SCHEDULES_ALL_BG
SYNONYM - PA_IND_RATE_SCH_REVISIONS
PACKAGE - PA_MULTI_CURRENCY
PACKAGE - PA_PJC_CWK_UTILS

APPS.GMS_COMMITMENT_TXNS_V is not referenced by any database object

[top of page]

View: GMS_CONTACTS_V

[top of page]

APPS.GMS_CONTACTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_AWARDS_CONTACTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS

APPS.GMS_CONTACTS_V is not referenced by any database object

[top of page]

View: GMS_DEFAULT_REPORTS_V

[top of page]

APPS.GMS_DEFAULT_REPORTS_V references the following:

APPS
SYNONYM - GMS_DEFAULT_REPORTS
VIEW - GMS_LOOKUPS
SYNONYM - GMS_REPORT_TEMPLATES
SYNONYM - HZ_CUST_SITE_USES
APPS.GMS_DEFAULT_REPORTS_V is referenced by following:

APPS
PACKAGE BODY - GMS_NOTIFICATION_PKG

[top of page]

View: GMS_DRAFT_INVOICES_V

[top of page]

APPS.GMS_DRAFT_INVOICES_V references the following:

APPS
SYNONYM - FND_LANGUAGES
VIEW - GL_SETS_OF_BOOKS
SYNONYM - GMS_AWARDS
PACKAGE - GMS_SECURITY
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_SITE_USES
SYNONYM - HZ_PARTIES
SYNONYM - PA_AGREEMENTS_ALL
VIEW - PA_CONVERSION_TYPES_V
SYNONYM - PA_DISTRIBUTION_RULES
SYNONYM - PA_DRAFT_INVOICES
SYNONYM - PA_DRAFT_INVOICES_ALL
SYNONYM - PA_DRAFT_INV_ITEMS_BAS
SYNONYM - PA_IMPLEMENTATIONS_ALL
VIEW - PA_LOOKUPS
PACKAGE - PA_MULTI_CURRENCY
PACKAGE - PA_OUTPUT_TAX
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_PROJECT_CUSTOMERS
SYNONYM - PA_PROJECT_STATUSES
SYNONYM - PA_PROJECT_TYPES
PACKAGE - PA_SECURITY
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - RA_TERMS
SYS
TABLE - DUAL

APPS.GMS_DRAFT_INVOICES_V is not referenced by any database object

[top of page]

View: GMS_DRAFT_INV_LINE_DETAILS_V

[top of page]

APPS.GMS_DRAFT_INV_LINE_DETAILS_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - GMS_AWARD_DISTRIBUTIONS
SYNONYM - GMS_BURDEN_COMPONENTS
SYNONYM - GMS_EVENT_INTERSECT
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PA_CONVERSION_TYPES_V
SYNONYM - PA_COST_DISTRIBUTION_LINES_ALL
SYNONYM - PA_DRAFT_INVOICES
SYNONYM - PA_DRAFT_INVOICE_ITEMS
SYNONYM - PA_EXPENDITURES_ALL
SYNONYM - PA_EXPENDITURE_COMMENTS
SYNONYM - PA_EXPENDITURE_ITEMS_ALL
SYNONYM - PA_EXPENDITURE_TYPES
VIEW - PA_LOOKUPS
SYNONYM - PA_PROJECTS_ALL
PACKAGE - PA_SECURITY
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
PACKAGE - PA_UTILS4
SYNONYM - PER_JOBS
VIEW - PER_PEOPLE_F
VIEW - PO_VENDORS
APPS.GMS_DRAFT_INV_LINE_DETAILS_V is referenced by following:

APPS
VIEW - GMS_1034_REPORT_V

[top of page]

View: GMS_DRAFT_REVENUES_V

[top of page]

APPS.GMS_DRAFT_REVENUES_V references the following:

APPS
SYNONYM - GMS_AWARDS
PACKAGE - GMS_SECURITY
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - PA_AGREEMENTS_ALL
PACKAGE - PA_CURRENCY
SYNONYM - PA_DISTRIBUTION_WARNINGS
SYNONYM - PA_DRAFT_REVENUES
SYNONYM - PA_DRAFT_REVENUE_ITEMS
VIEW - PA_LOOKUPS
SYNONYM - PA_PROJECTS
SYNONYM - PA_PROJECT_STATUSES
SYNONYM - PA_PROJECT_TYPES
PACKAGE - PA_SECURITY
SYS
TABLE - DUAL

APPS.GMS_DRAFT_REVENUES_V is not referenced by any database object

[top of page]

View: GMS_DTRANGE_BAL_V

[top of page]

APPS.GMS_DTRANGE_BAL_V references the following:

APPS
SYNONYM - GMS_BALANCES
APPS.GMS_DTRANGE_BAL_V is referenced by following:

APPS
VIEW - GMS_AWARD_BAL_V

[top of page]

View: GMS_EMPLOYEES

[top of page]

APPS.GMS_EMPLOYEES references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PA_EMPLOYEES

APPS.GMS_EMPLOYEES is not referenced by any database object

[top of page]

View: GMS_ENCUMBRANCES_V

[top of page]

APPS.GMS_ENCUMBRANCES_V references the following:

APPS
SYNONYM - GMS_ENCUMBRANCES
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_F

APPS.GMS_ENCUMBRANCES_V is not referenced by any database object

[top of page]

View: GMS_ENCUMBRANCE_GROUPS_V

[top of page]

APPS.GMS_ENCUMBRANCE_GROUPS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - GMS_ENCUMBRANCE_GROUPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PA_LOOKUPS
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TRANSACTION_SOURCES
VIEW - PER_PEOPLE_F

APPS.GMS_ENCUMBRANCE_GROUPS_V is not referenced by any database object

[top of page]

View: GMS_ENCUMBRANCE_ITEMS_V

[top of page]

APPS.GMS_ENCUMBRANCE_ITEMS_V references the following:

APPS
SYNONYM - GMS_ENCUMBRANCES
SYNONYM - GMS_ENCUMBRANCE_ITEMS_ALL
SYNONYM - PA_EXPENDITURE_TYPES
VIEW - PA_LOOKUPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES

APPS.GMS_ENCUMBRANCE_ITEMS_V is not referenced by any database object

[top of page]

View: GMS_ENC_PSI_V

[top of page]

APPS.GMS_ENC_PSI_V references the following:

APPS
PACKAGE - GMS_COST_PLUS_EXTN
SYNONYM - GMS_ENCUMBRANCES
SYNONYM - GMS_ENCUMBRANCE_ITEMS
SYNONYM - GMS_ENCUMBRANCE_ITEMS_ALL
PACKAGE - PA_ACCUM_UTILS
SYNONYM - PA_COMPILED_MULTIPLIERS
SYNONYM - PA_COST_BASE_COST_CODES
SYNONYM - PA_COST_BASE_EXP_TYPES
PACKAGE - PA_CURRENCY
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_TASKS
APPS.GMS_ENC_PSI_V is referenced by following:

APPS
VIEW - GMS_COMMITMENT_TXNS_V
PACKAGE BODY - GMS_PA_API3

[top of page]

View: GMS_EVENTS_V

[top of page]

APPS.GMS_EVENTS_V references the following:

APPS
SYNONYM - GMS_EVENT_ATTRIBUTE
SYNONYM - PA_EVENTS
APPS.GMS_EVENTS_V is referenced by following:

APPS
PACKAGE BODY - GMS_BILLING_ADJUSTMENTS
PACKAGE BODY - GMS_EVT_BILLING

[top of page]

View: GMS_EXPEND_ITEMS_ADJUST_V

[top of page]

APPS.GMS_EXPEND_ITEMS_ADJUST_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - GMS_AWARD_DISTRIBUTIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PA_CONVERSION_TYPES_V
SYNONYM - PA_COST_DIST_LINES_ALL_BAS
SYNONYM - PA_EXPENDITURES_ALL
SYNONYM - PA_EXPENDITURE_COMMENTS
SYNONYM - PA_EXPENDITURE_ITEMS_ALL
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_PROJECTS
SYNONYM - PA_PROJECT_TYPES_ALL
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
SYNONYM - PER_JOBS
VIEW - PER_PEOPLE_F
VIEW - PO_VENDORS

APPS.GMS_EXPEND_ITEMS_ADJUST_V is not referenced by any database object

[top of page]

View: GMS_FP_DISTRIBUTIONS_V

[top of page]

APPS.GMS_FP_DISTRIBUTIONS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_FP_DISTRIBUTIONS

APPS.GMS_FP_DISTRIBUTIONS_V is not referenced by any database object

[top of page]

View: GMS_FUNDING_AWARDS_V

[top of page]

APPS.GMS_FUNDING_AWARDS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
SYNONYM - PA_PROJECTS_ALL

APPS.GMS_FUNDING_AWARDS_V is not referenced by any database object

[top of page]

View: GMS_FUNDING_PATTERNS_V

[top of page]

APPS.GMS_FUNDING_PATTERNS_V references the following:

APPS
SYNONYM - GMS_FUNDING_PATTERNS

APPS.GMS_FUNDING_PATTERNS_V is not referenced by any database object

[top of page]

View: GMS_FUNDSCTL_RES_V

[top of page]

APPS.GMS_FUNDSCTL_RES_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_IMPLEMENTATIONS_ALL
VIEW - GMS_LOOKUPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_PROJECT_TYPES_ALL
SYNONYM - PA_TASKS

APPS.GMS_FUNDSCTL_RES_V is not referenced by any database object

[top of page]

View: GMS_FUNDSCTL_V

[top of page]

APPS.GMS_FUNDSCTL_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_IMPLEMENTATIONS
VIEW - GMS_LOOKUPS
VIEW - GMS_PROJECT_TYPES
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS

APPS.GMS_FUNDSCTL_V is not referenced by any database object

[top of page]

View: GMS_INSTALLMENTS_V

[top of page]

APPS.GMS_INSTALLMENTS_V references the following:

APPS
SYNONYM - GMS_INSTALLMENTS
VIEW - GMS_LOOKUPS
APPS.GMS_INSTALLMENTS_V is referenced by following:

APPS
PACKAGE BODY - GMS_SUMM_FUNDING_PKG

[top of page]

View: GMS_IP_AWARD_LOV_V

[top of page]

APPS.GMS_IP_AWARD_LOV_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_IMPLEMENTATIONS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
SYNONYM - PA_TASKS

APPS.GMS_IP_AWARD_LOV_V is not referenced by any database object

[top of page]

View: GMS_KEY_MEMBER_ROLE_V

[top of page]

APPS.GMS_KEY_MEMBER_ROLE_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_PERSONNEL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_F

APPS.GMS_KEY_MEMBER_ROLE_V is not referenced by any database object

[top of page]

View: GMS_LOC_CONTACTS_V

[top of page]

APPS.GMS_LOC_CONTACTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_AWARDS_CONTACTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS

APPS.GMS_LOC_CONTACTS_V is not referenced by any database object

[top of page]

View: GMS_LOOKUPS

[top of page]

APPS.GMS_LOOKUPS references the following:

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

APPS
VIEW - GMS_AWARDS_V
PACKAGE BODY - GMS_AWARD_PVT
VIEW - GMS_AWARD_STATUS_V
VIEW - GMS_DEFAULT_REPORTS_V
PACKAGE BODY - GMS_ERROR_PKG
VIEW - GMS_FUNDSCTL_RES_V
VIEW - GMS_FUNDSCTL_V
VIEW - GMS_INSTALLMENTS_V
VIEW - GMS_PERSONNEL_V
VIEW - GMS_REFERENCE_NUMBERS_V
VIEW - GMS_REPORTS_V
VIEW - GMS_REPORT_TEMPLATES_V
PACKAGE BODY - GMS_WF_PKG
PACKAGE BODY - IGW_INSTALLMENTS_PVT
PACKAGE BODY - PA_FUNDS_CONTROL_UTILS

[top of page]

View: GMS_NONE_BAL_V

[top of page]

APPS.GMS_NONE_BAL_V references the following:

APPS
SYNONYM - GMS_BALANCES
APPS.GMS_NONE_BAL_V is referenced by following:

APPS
VIEW - GMS_AWARD_BAL_V

[top of page]

View: GMS_NOTIFICATIONS_V

[top of page]

APPS.GMS_NOTIFICATIONS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_NOTIFICATIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_X
APPS.GMS_NOTIFICATIONS_V is referenced by following:

APPS
PACKAGE BODY - GMS_CLIENT_EXTN_BUDGET_WF
PACKAGE BODY - GMS_WF_PKG

[top of page]

View: GMS_OPERATING_UNITS_V

[top of page]

APPS.GMS_OPERATING_UNITS_V references the following:

APPS
SYNONYM - GMS_IMPLEMENTATIONS_ALL
VIEW - HR_OPERATING_UNITS
PACKAGE - MO_GLOBAL
APPS.GMS_OPERATING_UNITS_V is referenced by following:

APPS
VIEW - GMS_AWARDS_V

[top of page]

View: GMS_OVERRIDE_SCHEDULES_V

[top of page]

APPS.GMS_OVERRIDE_SCHEDULES_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_OVERRIDE_SCHEDULES
VIEW - PA_IND_RATE_SCHEDULES
SYNONYM - PA_PROJECTS
SYNONYM - PA_TASKS
PACKAGE - PA_UTILS

APPS.GMS_OVERRIDE_SCHEDULES_V is not referenced by any database object

[top of page]

View: GMS_PERSONNEL_V

[top of page]

APPS.GMS_PERSONNEL_V references the following:

APPS
VIEW - GMS_LOOKUPS
SYNONYM - GMS_PERSONNEL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_X

APPS.GMS_PERSONNEL_V is not referenced by any database object

[top of page]

View: GMS_PHONE_CONTACTS_V

[top of page]

APPS.GMS_PHONE_CONTACTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES

APPS.GMS_PHONE_CONTACTS_V is not referenced by any database object

[top of page]

View: GMS_PQH_AWARDS_V

[top of page]

APPS.GMS_PQH_AWARDS_V references the following:

APPS
VIEW - GMS_AWARDS_BASIC_V
APPS.GMS_PQH_AWARDS_V is referenced by following:

APPS
PACKAGE BODY - PQH_UTILITY

[top of page]

View: GMS_PQH_EXP_TYPES_V

[top of page]

APPS.GMS_PQH_EXP_TYPES_V references the following:

APPS
SYNONYM - GMS_ALLOWABLE_EXPENDITURES
SYNONYM - GMS_AWARDS
VIEW - GMS_PROJECT_TYPES
VIEW - PA_EXPENDITURE_TYPES_EXPEND_V
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
APPS.GMS_PQH_EXP_TYPES_V is referenced by following:

APPS
PACKAGE BODY - PQH_UTILITY

[top of page]

View: GMS_PQH_PROJECTS_V

[top of page]

APPS.GMS_PQH_PROJECTS_V references the following:

APPS
PACKAGE - FND_PROFILE
VIEW - GMS_PROJECTS_V
PACKAGE - PA_CROSS_BUSINESS_GRP
PACKAGE - PA_PROJECT_UTILS
APPS.GMS_PQH_PROJECTS_V is referenced by following:

APPS
PACKAGE BODY - PQH_UTILITY

[top of page]

View: GMS_PROJECTS_BASIC_V

[top of page]

APPS.GMS_PROJECTS_BASIC_V references the following:

APPS
PACKAGE - GMS_COMMON_PKG
PACKAGE - MO_GLOBAL
VIEW - PA_PROJECTS_BASIC_V
PACKAGE - PA_SECURITY

APPS.GMS_PROJECTS_BASIC_V is not referenced by any database object

[top of page]

View: GMS_PROJECTS_BURDEN_V

[top of page]

APPS.GMS_PROJECTS_BURDEN_V references the following:

APPS
VIEW - GMS_PROJECT_TYPES
SYNONYM - PA_PROJECTS
PACKAGE - PA_PROJECT_STUS_UTILS

APPS.GMS_PROJECTS_BURDEN_V is not referenced by any database object

[top of page]

View: GMS_PROJECTS_EXPEND_V

[top of page]

APPS.GMS_PROJECTS_EXPEND_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - PA_CROSS_BUSINESS_GRP
VIEW - PA_PROJECTS_EXPEND_V
SYNONYM - PA_PROJECT_TYPES
PACKAGE - PA_PROJECT_UTILS
SYNONYM - PA_TASKS
APPS.GMS_PROJECTS_EXPEND_V is referenced by following:

APPS
PACKAGE BODY - PSP_POA_BUS
PACKAGE BODY - PSP_PSPENCDU_XMLP_PKG
PACKAGE BODY - PSP_PSPENCSC_XMLP_PKG
PACKAGE BODY - PSP_PSPLSODL_XMLP_PKG

[top of page]

View: GMS_PROJECTS_V

[top of page]

APPS.GMS_PROJECTS_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - PA_CROSS_BUSINESS_GRP
VIEW - PA_PROJECTS_EXPEND_V
PACKAGE - PA_PROJECT_UTILS
APPS.GMS_PROJECTS_V is referenced by following:

APPS
VIEW - GMS_PQH_PROJECTS_V

[top of page]

View: GMS_PROJECT_FUNDINGS_V

[top of page]

APPS.GMS_PROJECT_FUNDINGS_V references the following:

APPS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_PROJECT_FUNDINGS
VIEW - PA_LOOKUPS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_PROJECT_TYPES
PACKAGE - PA_SECURITY
SYNONYM - PA_TASKS

APPS.GMS_PROJECT_FUNDINGS_V is not referenced by any database object

[top of page]

View: GMS_PROJECT_TYPES

[top of page]

APPS.GMS_PROJECT_TYPES references the following:

APPS
SYNONYM - PA_PROJECT_TYPES
APPS.GMS_PROJECT_TYPES is referenced by following:

APPS
PACKAGE BODY - GMS_AP_API
PACKAGE BODY - GMS_AP_API2
PACKAGE BODY - GMS_AWARDS_DIST_PKG
PACKAGE BODY - GMS_AWARD_DIST_ENG
PACKAGE BODY - GMS_COST_PLUS_EXTN
PACKAGE BODY - GMS_FC_SYS
VIEW - GMS_FUNDSCTL_V
PACKAGE BODY - GMS_FUNDS_CONTROL_PKG
PACKAGE BODY - GMS_FUNDS_POSTING_PKG
PACKAGE BODY - GMS_OIE_INT_PKG
PACKAGE BODY - GMS_PA_API
PACKAGE BODY - GMS_PA_API3
PACKAGE BODY - GMS_PA_XFACE
PACKAGE BODY - GMS_POR_API
PACKAGE BODY - GMS_POR_API2
PACKAGE BODY - GMS_PO_API_GRP
VIEW - GMS_PQH_EXP_TYPES_V
VIEW - GMS_PROJECTS_BURDEN_V
PACKAGE BODY - GMS_TRANSACTIONS_PUB
PACKAGE BODY - IGW_PROJECT_FUNDINGS_PVT
PACKAGE BODY - PA_BURDEN_COSTING
PACKAGE BODY - PSP_GENERAL
PACKAGE BODY - PSP_XMLGEN

[top of page]

View: GMS_REFERENCE_NUMBERS_V

[top of page]

APPS.GMS_REFERENCE_NUMBERS_V references the following:

APPS
VIEW - GMS_LOOKUPS
SYNONYM - GMS_REFERENCE_NUMBERS

APPS.GMS_REFERENCE_NUMBERS_V is not referenced by any database object

[top of page]

View: GMS_REPORTS_V

[top of page]

APPS.GMS_REPORTS_V references the following:

APPS
VIEW - GMS_LOOKUPS
SYNONYM - GMS_REPORTS
SYNONYM - GMS_REPORT_TEMPLATES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_SITE_USES
VIEW - PER_PEOPLE_X

APPS.GMS_REPORTS_V is not referenced by any database object

[top of page]

View: GMS_REPORT_TEMPLATES_V

[top of page]

APPS.GMS_REPORT_TEMPLATES_V references the following:

APPS
VIEW - GMS_LOOKUPS
SYNONYM - GMS_REPORT_TEMPLATES

APPS.GMS_REPORT_TEMPLATES_V is not referenced by any database object

[top of page]

View: GMS_RESG_BAL_V

[top of page]

APPS.GMS_RESG_BAL_V references the following:

APPS
SYNONYM - GMS_BALANCES
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_RESG_BAL_V is not referenced by any database object

[top of page]

View: GMS_RESG_BC_V

[top of page]

APPS.GMS_RESG_BC_V references the following:

APPS
SYNONYM - GMS_BC_PACKETS
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_RESG_BC_V is not referenced by any database object

[top of page]

View: GMS_RESG_V

[top of page]

APPS.GMS_RESG_V references the following:

APPS
PACKAGE - FND_PROFILE
VIEW - GMS_AWARD_BAL_V
PACKAGE - GMS_BUDGET_UTILS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_RESOURCES
VIEW - PA_RESOURCE_LISTS
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_RESG_V is not referenced by any database object

[top of page]

View: GMS_RES_V

[top of page]

APPS.GMS_RES_V references the following:

APPS
PACKAGE - FND_PROFILE
VIEW - GMS_AWARD_BAL_V
PACKAGE - GMS_BUDGET_UTILS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_RESOURCES
VIEW - PA_RESOURCE_LISTS
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_RES_V is not referenced by any database object

[top of page]

View: GMS_SSA_AWARDS_V

[top of page]

APPS.GMS_SSA_AWARDS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
APPS.GMS_SSA_AWARDS_V is referenced by following:

APPS
VIEW - AP_WEB_PA_PROJECTS_TASKS_V
PACKAGE BODY - GMS_OIE_INT_PKG
VIEW - ICX_AP_EXPENSE_LINES_V

[top of page]

View: GMS_SSA_AWARD_EXPTYPE_V

[top of page]

APPS.GMS_SSA_AWARD_EXPTYPE_V references the following:

APPS
SYNONYM - GMS_ALLOWABLE_EXPENDITURES
SYNONYM - GMS_AWARDS

APPS.GMS_SSA_AWARD_EXPTYPE_V is not referenced by any database object

[top of page]

View: GMS_STATUS_ACCUM_PROJECT_V

[top of page]

APPS.GMS_STATUS_ACCUM_PROJECT_V references the following:

APPS
VIEW - GMS_STATUS_ACCUM_PROJ_BASE_V

APPS.GMS_STATUS_ACCUM_PROJECT_V is not referenced by any database object

[top of page]

View: GMS_STATUS_ACCUM_PROJ_BASE_V

[top of page]

APPS.GMS_STATUS_ACCUM_PROJ_BASE_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_EVENT_ATTRIBUTE
SYNONYM - PA_EVENTS
SYNONYM - PA_PROJECTS_ALL
APPS.GMS_STATUS_ACCUM_PROJ_BASE_V is referenced by following:

APPS
VIEW - GMS_STATUS_ACCUM_PROJECT_V

[top of page]

View: GMS_STATUS_ACCUM_TASK_BASE_V

[top of page]

APPS.GMS_STATUS_ACCUM_TASK_BASE_V references the following:

APPS
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - PA_TASKS_V
PACKAGE - PA_TASK_UTILS
APPS.GMS_STATUS_ACCUM_TASK_BASE_V is referenced by following:

APPS
VIEW - GMS_STATUS_AWARD_ACCUM_TASK_V

[top of page]

View: GMS_STATUS_ACTUALS_BASE1_V

[top of page]

APPS.GMS_STATUS_ACTUALS_BASE1_V references the following:

APPS
SYNONYM - GMS_AWARD_DISTRIBUTIONS
SYNONYM - GMS_BURDEN_COMPONENTS
SYNONYM - PA_COST_DISTRIBUTION_LINES_ALL
APPS.GMS_STATUS_ACTUALS_BASE1_V is referenced by following:

APPS
VIEW - GMS_STATUS_ACTUALS_BASE2_V
VIEW - GMS_STATUS_ACTUALS_V

[top of page]

View: GMS_STATUS_ACTUALS_BASE2_V

[top of page]

APPS.GMS_STATUS_ACTUALS_BASE2_V references the following:

APPS
VIEW - GMS_STATUS_ACTUALS_BASE1_V

APPS.GMS_STATUS_ACTUALS_BASE2_V is not referenced by any database object

[top of page]

View: GMS_STATUS_ACTUALS_V

[top of page]

APPS.GMS_STATUS_ACTUALS_V references the following:

APPS
SYNONYM - AP_INVOICES_ALL
VIEW - GMS_STATUS_ACTUALS_BASE1_V
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PA_EXPENDITURES_ALL
SYNONYM - PA_EXPENDITURE_ITEMS_ALL
SYNONYM - PA_EXPENDITURE_TYPES
VIEW - PA_LOOKUPS
SYNONYM - PA_PERIODS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES

APPS.GMS_STATUS_ACTUALS_V is not referenced by any database object

[top of page]

View: GMS_STATUS_AWARD_ACCUM_BASE_V

[top of page]

APPS.GMS_STATUS_AWARD_ACCUM_BASE_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_EVENTS
APPS.GMS_STATUS_AWARD_ACCUM_BASE_V is referenced by following:

APPS
VIEW - GMS_STATUS_AWARD_ACCUM_V

[top of page]

View: GMS_STATUS_AWARD_ACCUM_TASK_V

[top of page]

APPS.GMS_STATUS_AWARD_ACCUM_TASK_V references the following:

APPS
VIEW - GMS_STATUS_ACCUM_TASK_BASE_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_TASK_UTILS

APPS.GMS_STATUS_AWARD_ACCUM_TASK_V is not referenced by any database object

[top of page]

View: GMS_STATUS_AWARD_ACCUM_V

[top of page]

APPS.GMS_STATUS_AWARD_ACCUM_V references the following:

APPS
VIEW - GMS_STATUS_AWARD_ACCUM_BASE_V

APPS.GMS_STATUS_AWARD_ACCUM_V is not referenced by any database object

[top of page]

View: GMS_STATUS_COMMITMENTS_V

[top of page]

APPS.GMS_STATUS_COMMITMENTS_V references the following:

APPS
PACKAGE - GMS_BUDGET_BALANCE
VIEW - GMS_COMMITMENT_BURDEN_V
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
PACKAGE - PA_CMT_UTILS
PACKAGE - PA_CURRENCY
SYNONYM - PA_PERIODS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
PACKAGE - PO_INTG_DOCUMENT_FUNDS_GRP

APPS.GMS_STATUS_COMMITMENTS_V is not referenced by any database object

[top of page]

View: GMS_STATUS_PROJ_GENERIC_V

[top of page]

APPS.GMS_STATUS_PROJ_GENERIC_V references the following:

APPS
SYNONYM - PA_PROJECTS
PACKAGE - PA_SECURITY
PACKAGE - PA_STATUS
VIEW - PA_STATUS_PROJ_GENERIC_V

APPS.GMS_STATUS_PROJ_GENERIC_V is not referenced by any database object

[top of page]

View: GMS_STATUS_RESOURCES_BASE_V

[top of page]

APPS.GMS_STATUS_RESOURCES_BASE_V references the following:

APPS
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_RESOURCES
SYNONYM - PA_RESOURCE_LISTS_ALL_BG
SYNONYM - PA_RESOURCE_LIST_MEMBERS
APPS.GMS_STATUS_RESOURCES_BASE_V is referenced by following:

APPS
VIEW - GMS_STATUS_RESOURCES_V

[top of page]

View: GMS_STATUS_RESOURCES_V

[top of page]

APPS.GMS_STATUS_RESOURCES_V references the following:

APPS
VIEW - GMS_STATUS_RESOURCES_BASE_V

APPS.GMS_STATUS_RESOURCES_V is not referenced by any database object

[top of page]

View: GMS_SUM_PRJ_FUNDINGS_V

[top of page]

APPS.GMS_SUM_PRJ_FUNDINGS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_INSTALLMENTS
PACKAGE - GMS_SECURITY
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
VIEW - PA_LOOKUPS
SYNONYM - PA_PROJECTS_ALL
PACKAGE - PA_SECURITY
SYNONYM - PA_TASKS
SYS
TABLE - DUAL

APPS.GMS_SUM_PRJ_FUNDINGS_V is not referenced by any database object

[top of page]

View: GMS_TASK_BAL_V

[top of page]

APPS.GMS_TASK_BAL_V references the following:

APPS
VIEW - GMS_AWARD_BAL_V
PACKAGE - GMS_BUDGET_UTILS

APPS.GMS_TASK_BAL_V is not referenced by any database object

[top of page]

View: GMS_TASK_BUDGETS2_V

[top of page]

APPS.GMS_TASK_BUDGETS2_V references the following:

APPS
SYNONYM - GMS_BUDGET_LINES
PACKAGE - GMS_BUDGET_UTILS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_RESOURCE_ASSIGNMENTS
SYNONYM - PA_TASKS
APPS.GMS_TASK_BUDGETS2_V is referenced by following:

APPS
VIEW - GMS_TASK_BUDGETS_V

[top of page]

View: GMS_TASK_BUDGETS_V

[top of page]

APPS.GMS_TASK_BUDGETS_V references the following:

APPS
PACKAGE - GMS_BUDGET_UTILS
VIEW - GMS_TASK_BUDGETS2_V
PACKAGE - PA_TASK_UTILS

APPS.GMS_TASK_BUDGETS_V is not referenced by any database object

[top of page]

View: GMS_TASK_V

[top of page]

APPS.GMS_TASK_V references the following:

APPS
VIEW - GMS_AWARD_BAL_V
PACKAGE - GMS_BUDGET_UTILS

APPS.GMS_TASK_V is not referenced by any database object

[top of page]

View: GMS_TERMS_CONDITIONS_V

[top of page]

APPS.GMS_TERMS_CONDITIONS_V references the following:

APPS
SYNONYM - GMS_AWARDS_TERMS_CONDITIONS
SYNONYM - GMS_TC_CATEGORIES
SYNONYM - GMS_TERMS_CONDITIONS

APPS.GMS_TERMS_CONDITIONS_V is not referenced by any database object

[top of page]

View: GMS_XLA_AWARD_REF_V

[top of page]

APPS.GMS_XLA_AWARD_REF_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_AWARD_DISTRIBUTIONS
APPS.GMS_XLA_AWARD_REF_V is referenced by following:

APPS
PACKAGE BODY - XLA_00275_AAD_S_000015_PKG

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract