eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
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®,
OracleDevConnect SM, Oracle® Discoverer,
Oracle® Expert, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile, Oracle Names®,
Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services, Oracle® SQL*TutorSM,
OracleSTERLING SM, 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
AWARD_ID
VERSION
STATUS_CODE
[top of page]
GMS.GMS_269_HISTORY does not reference any database object
GMS.GMS_269_HISTORY is referenced by following:
GMS
VIEW - 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:
GMS
VIEW - GMS_270_HISTORY#
[top of page]
Table: GMS_272_HISTORY
Description: Federal cash transaction report
Primary Key: GMS_272_HISTORY_PK
AWARD_ID
VERSION
STATUS_CODE
[top of page]
GMS.GMS_272_HISTORY does not reference any database object
GMS.GMS_272_HISTORY is referenced by following:
GMS
VIEW - 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:
GMS
VIEW - GMS_ALLOWABILITY_SCHEDULES#
[top of page]
Table: GMS_ALLOWABLE_EXPENDITURES
Description: Allowable expenditures of cost allowability schedule
Primary Key: GMS_ALLOWABLE_EXPENDITURES_PK
ALLOWABILITY_SCHEDULE_ID
EXPENDITURE_TYPE
[top of page]
GMS.GMS_ALLOWABLE_EXPENDITURES does not reference any database object
GMS.GMS_ALLOWABLE_EXPENDITURES is referenced by following:
GMS
VIEW - 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:
GMS
VIEW - GMS_AWARDS_ALL#
- 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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
AWARD_ID
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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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
BUDGETARY_CONTROLS_ID
[top of page]
GMS.GMS_BUDGETARY_CONTROLS does not reference any database object
GMS.GMS_BUDGETARY_CONTROLS is referenced by following:
GMS
VIEW - GMS_BUDGETARY_CONTROLS#
[top of page]
Table: GMS_BUDGET_LINES
Description: Detail lines of project and task budgets
Primary Key: GMS_BUDGET_LINES_PK
RESOURCE_ASSIGNMENT_ID
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:
GMS
VIEW - GMS_BUDGET_LINES#
[top of page]
Table: GMS_BUDGET_VERSIONS
Description: Versions of award budgets
Primary Key: GMS_BUDGET_VERSIONS_PK
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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - GMS_CONCURRENCY_CONTROL#
[top of page]
Table: GMS_DEFAULT_REPORTS
Description: Default reports of award
Primary Key: GMS_DEFAULT_REPORTS_PK
DEFAULT_REPORT_ID
[top of page]
GMS.GMS_DEFAULT_REPORTS does not reference any database object
GMS.GMS_DEFAULT_REPORTS is referenced by following:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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
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:
GMS
VIEW - GMS_ENCUMBRANCES_ALL#
[top of page]
Table: GMS_ENCUMBRANCE_GROUPS_ALL
Description: Groups of pre-approved encumbrances
Primary Key: GMS_ENCUBMBRACE_GROUPS_PK
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:
GMS
VIEW - 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
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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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
FUNDING_PATTERN_ID
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:
GMS
VIEW - 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
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:
GMS
VIEW - 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:
GMS
VIEW - 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
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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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
AWARD_ID
PROJECT_ID
Primary Key: GMS_OVERRIDE_SCHEDULES_UK
AWARD_ID
PROJECT_ID
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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - GMS_PROJECT_TYPES_ALL#
[top of page]
Table: GMS_REFERENCE_NUMBERS
Description: Reference numbers of award
Primary Key: GMS_REFERENCE_NUMBERS_PK
AWARD_ID
TYPE
VALUE
[top of page]
GMS.GMS_REFERENCE_NUMBERS does not reference any database object
GMS.GMS_REFERENCE_NUMBERS is referenced by following:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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
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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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:
GMS
VIEW - 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
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:
GMS
VIEW - 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
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:
GMS
VIEW - 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:
GMS
VIEW - GMS_WF_PROCESSES#
[top of page]
View: GMS_1034_REPORT_V
[top of page]
APPS.GMS_1034_REPORT_V references the following:
APPS
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
- GMS_DRAFT_INV_LINE_DETAILS_V
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
PACKAGE - PA_SECURITY
- PA_PROJECTS_ALL
- PA_PROJECT_TYPES
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_TASKS
- PA_PROJECTS_ALL
APPS.GMS_AWARDS_BASIC_V is referenced by following:
APPS
VIEW - GMS_PQH_AWARDS_V
[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
PACKAGE - GMS_SECURITY
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - PA_INVOICE_FORMATS
SYNONYM - PA_SUMMARY_PROJECT_FUNDINGS
PACKAGE - PA_UTILS
SYNONYM - RA_TERMS
SYS
TABLE - DUAL
- PA_AGREEMENTS_ALL
- PA_IND_RATE_SCHEDULES
- GMS_LOOKUPS
- GMS_OPERATING_UNITS_V
- MO_GLOBAL
APPS.GMS_AWARDS_V is not referenced by any database object
[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_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
SYNONYM - PA_TASKS
- PA_PROJECTS_ALL
- GMS_AWARDS
- GMS_NONE_BAL_V
- PA_PERIODS
- GMS_DTRANGE_BAL_V
APPS.GMS_AWARD_BAL_V is referenced by following:
APPS
VIEW - GMS_AWD_V
VIEW - GMS_RES_V
[top of page]
View: GMS_AWARD_PROJECTS_V
[top of page]
APPS.GMS_AWARD_PROJECTS_V references the following:
- GMS_AWARDS
- 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:
- 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
VIEW - GMS_AWARD_BAL_V
- GMS_AWARDS
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
PACKAGE - PA_SECURITY
- PA_PROJECTS_ALL
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_BUDGETARY_CONTROLS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
- PA_RESOURCE_LISTS
- GMS_AWARDS
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
- PA_PROJECTS_ALL
- PA_IMPLEMENTATIONS
- 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:
- 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
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_LOOKUPS
APPS.GMS_BUDGET_LINES_V is not referenced by any database object
[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
- PA_LOOKUPS
- PA_RESOURCE_LISTS
- 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
SYS
TABLE - DUAL
- PA_RESOURCE_LISTS
- PA_LOOKUPS
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
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_RESOURCE_LISTS
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_IND_COMPILED_SETS
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_IND_RATE_SCHEDULES_ALL_BG
SYNONYM - PA_IND_RATE_SCH_REVISIONS
SYNONYM - PA_TRANSACTION_SOURCES
- PA_PROJECT_TYPES
- PA_PROJECTS_ALL
- PA_EXPENDITURES_ALL
- PA_EXPENDITURE_ITEMS_ALL
- PA_COST_DISTRIBUTION_LINES_ALL
APPS.GMS_CDL_BURDEN_DETAIL_V is not referenced by any database object
[top of page]
View: GMS_COMMITMENTS_OVERRIDE_V
[top of page]
APPS.GMS_COMMITMENTS_OVERRIDE_V references the following:
APPS
SYNONYM - CST_PROJMFG_CMT_VIEW
PACKAGE - FND_PROFILE
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_FUNDS_CONTROL_UTILS
PACKAGE - PA_MULTI_CURRENCY
PACKAGE - PA_PJC_CWK_UTILS
VIEW - PA_PROJ_PO_DISTRIBUTIONS
VIEW - PA_PROJ_REQ_DISTRIBUTIONS
PACKAGE - PA_TASK_UTILS
PACKAGE - PA_UTILS4
SYNONYM - PJM_PO_COMMITMENTS_V
SYNONYM - PJM_REQ_COMMITMENTS_V
- PA_PROJ_AP_INV_DISTRIBUTIONS
- AP_INVOICES_PKG
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 not referenced by any database object
[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 - AP_SELF_ASSESSED_TAX_DIST_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_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_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
SYNONYM - PO_REQ_DISTRIBUTIONS_ALL
VIEW - PO_VENDORS
- PA_PERIODS
- PO_LINE_TYPES
APPS.GMS_COMMITMENT_ENCUMBERED_V is referenced by following:
APPS
VIEW - GMS_COMMITMENT_BURDEN_V
[top of page]
View: GMS_COMMITMENT_TXNS_V
[top of page]
APPS.GMS_COMMITMENT_TXNS_V references the following:
APPS
PACKAGE - FND_PROFILE
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
PACKAGE - PA_FUNDS_CONTROL_UTILS
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
PACKAGE - PA_TASK_UTILS
PACKAGE - PA_UTILS4
- AP_INVOICES_PKG
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_CONTACTS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
- GMS_AWARDS
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
SYNONYM - GMS_REPORT_TEMPLATES
SYNONYM - HZ_CUST_SITE_USES
- GMS_LOOKUPS
APPS.GMS_DEFAULT_REPORTS_V is not referenced by any database object
[top of page]
View: GMS_DRAFT_INVOICES_V
[top of page]
APPS.GMS_DRAFT_INVOICES_V references the following:
APPS
SYNONYM - FND_LANGUAGES
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_DISTRIBUTION_RULES
SYNONYM - PA_DRAFT_INV_ITEMS_BAS
PACKAGE - PA_MULTI_CURRENCY
PACKAGE - PA_OUTPUT_TAX
SYNONYM - PA_PROJECT_CUSTOMERS
SYNONYM - PA_PROJECT_PARTIES
SYNONYM - PA_PROJECT_ROLE_TYPES_B
SYNONYM - PA_PROJECT_STATUSES
SYNONYM - PA_ROLE_CONTROLS
PACKAGE - PA_SECURITY
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - RA_TERMS
SYS
TABLE - DUAL
- PA_PROJECT_TYPES
- PA_PROJECTS_ALL
- PA_AGREEMENTS_ALL
- PA_DRAFT_INVOICES_ALL
- PA_LOOKUPS
- PA_IMPLEMENTATIONS_ALL
- PA_CONVERSION_TYPES_V
- PA_DRAFT_INVOICES
- GL_SETS_OF_BOOKS
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
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PA_DRAFT_INVOICE_ITEMS
SYNONYM - PA_EXPENDITURE_COMMENTS
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_RBS_ELEMENTS
PACKAGE - PA_SECURITY
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
PACKAGE - PA_UTILS4
SYNONYM - PER_JOBS
VIEW - PO_VENDORS
- HR_ORGANIZATION_UNITS
- PA_LOOKUPS
- PA_CONVERSION_TYPES_V
- PA_DRAFT_INVOICES
- PA_EXPENDITURE_ITEMS_ALL
- PA_PROJECTS_ALL
- PA_EXPENDITURES_ALL
- PER_PEOPLE_F
- PA_COST_DISTRIBUTION_LINES_ALL
APPS.GMS_DRAFT_INV_LINE_DETAILS_V is not referenced by any database object
[top of page]
View: GMS_DRAFT_REVENUES_V
[top of page]
APPS.GMS_DRAFT_REVENUES_V references the following:
APPS
PACKAGE - GMS_SECURITY
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
PACKAGE - PA_CURRENCY
SYNONYM - PA_DISTRIBUTION_WARNINGS
SYNONYM - PA_DRAFT_REVENUE_ITEMS
SYNONYM - PA_PROJECT_STATUSES
PACKAGE - PA_SECURITY
SYS
TABLE - DUAL
- PA_LOOKUPS
- HR_ORGANIZATION_UNITS
- PA_AGREEMENTS_ALL
- PA_PROJECTS
- GMS_AWARDS
- PA_PROJECT_TYPES
- PA_DRAFT_REVENUES
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 not referenced by any database object
[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
- 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
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- HR_ORGANIZATION_UNITS
- 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
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TRANSACTION_SOURCES
- PA_LOOKUPS
- 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
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
- PA_PROJECTS_ALL
- PA_LOOKUPS
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
SYNONYM - GMS_AWARD_DISTRIBUTIONS
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
[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 not referenced by any database object
[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
SYNONYM - PA_EXPENDITURE_COMMENTS
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
SYNONYM - PER_JOBS
VIEW - PO_VENDORS
- PA_COST_DIST_LINES_ALL_BAS
- PER_PEOPLE_F
- PA_PROJECT_TYPES_ALL
- PA_EXPENDITURES_ALL
- PA_CONVERSION_TYPES_V
- PA_PROJECTS
- PA_EXPENDITURE_ITEMS_ALL
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_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
- GMS_AWARDS
- 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_TASKS
- PA_PROJECTS_ALL
- PA_PROJECT_TYPES_ALL
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_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_IMPLEMENTATIONS
SYNONYM - PA_TASKS
- PA_PROJECTS_ALL
- GMS_AWARDS
- GMS_LOOKUPS
- GMS_PROJECT_TYPES
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
- GMS_LOOKUPS
APPS.GMS_INSTALLMENTS_V is not referenced by any database object
[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_PERSONNEL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PER_PEOPLE_F
- GMS_AWARDS
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_CONTACTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
- GMS_AWARDS
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_FUNDSCTL_RES_V
[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 not referenced by any database object
[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
- PER_PEOPLE_X
APPS.GMS_NOTIFICATIONS_V is not referenced by any database object
[top of page]
View: GMS_OPERATING_UNITS_V
[top of page]
APPS.GMS_OPERATING_UNITS_V references the following:
APPS
SYNONYM - GMS_IMPLEMENTATIONS_ALL
- MO_GLOBAL
- HR_OPERATING_UNITS
APPS.GMS_OPERATING_UNITS_V is not referenced by any database object
[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
SYNONYM - PA_TASKS
PACKAGE - PA_UTILS
- PA_PROJECTS
- PA_IND_RATE_SCHEDULES
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
SYNONYM - GMS_PERSONNEL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- GMS_LOOKUPS
- 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 not referenced by any database object
[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
SYNONYM - PA_TASKS
- PA_PROJECTS_ALL
- PA_EXPENDITURE_TYPES_EXPEND_V
APPS.GMS_PQH_EXP_TYPES_V is not referenced by any database object
[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
- PA_PROJECT_UTILS
APPS.GMS_PQH_PROJECTS_V is not referenced by any database object
[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 - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_SECURITY
- MO_GLOBAL
- PA_PROJECTS_BASIC_V
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:
- GMS_PROJECT_TYPES
- PA_PROJECT_STUS_UTILS
- PA_PROJECTS
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
SYNONYM - PA_TASKS
- PA_PROJECT_TYPES
- PA_PROJECT_UTILS
- PA_PROJECTS_EXPEND_V
APPS.GMS_PROJECTS_EXPEND_V is not referenced by any database object
[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
- PA_PROJECTS_EXPEND_V
- 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
PACKAGE - PA_SECURITY
SYNONYM - PA_TASKS
- PA_PROJECT_TYPES
- PA_LOOKUPS
- PA_PROJECTS_ALL
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:
- PA_PROJECT_TYPES
APPS.GMS_PROJECT_TYPES is referenced by following:
APPS
VIEW - GMS_PQH_EXP_TYPES_V
[top of page]
View: GMS_REFERENCE_NUMBERS_V
[top of page]
APPS.GMS_REFERENCE_NUMBERS_V references the following:
APPS
SYNONYM - GMS_REFERENCE_NUMBERS
- GMS_LOOKUPS
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
SYNONYM - GMS_REPORTS
SYNONYM - GMS_REPORT_TEMPLATES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_SITE_USES
- GMS_LOOKUPS
- 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
SYNONYM - GMS_REPORT_TEMPLATES
- GMS_LOOKUPS
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
PACKAGE - GMS_BUDGET_UTILS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_RESOURCES
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_RESOURCE_LISTS
- GMS_AWARD_BAL_V
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
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_RESOURCE_LISTS
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
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
- 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
PACKAGE - PA_TASK_UTILS
- PA_TASKS_V
APPS.GMS_STATUS_ACCUM_TASK_BASE_V is not referenced by any database object
[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
- 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
PACKAGE - HR_SECURITY
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
- PA_LOOKUPS
- HR_ORGANIZATION_UNITS
- PA_PERIODS
- PA_PROJECTS_ALL
- PA_EXPENDITURES_ALL
- PA_EXPENDITURE_ITEMS_ALL
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
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_TASK_UTILS
- GMS_STATUS_ACCUM_TASK_BASE_V
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
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_CMT_UTILS
PACKAGE - PA_CURRENCY
SYNONYM - PA_TASKS
PACKAGE - PO_INTG_DOCUMENT_FUNDS_GRP
- PA_PROJECTS_ALL
- HR_ORGANIZATION_UNITS
- GMS_COMMITMENT_BURDEN_V
- PA_PERIODS
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
PACKAGE - PA_SECURITY
PACKAGE - PA_STATUS
- PA_STATUS_PROJ_GENERIC_V
- PA_PROJECTS
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_RESOURCES
SYNONYM - PA_RESOURCE_LISTS_ALL_BG
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_PROJECTS_ALL
APPS.GMS_STATUS_RESOURCES_BASE_V is not referenced by any database object
[top of page]
View: GMS_STATUS_RESOURCES_V
[top of page]
APPS.GMS_STATUS_RESOURCES_V references the following:
- 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_INSTALLMENTS
PACKAGE - GMS_SECURITY
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
PACKAGE - PA_SECURITY
SYNONYM - PA_TASKS
SYS
TABLE - DUAL
- PA_LOOKUPS
- GMS_AWARDS
- PA_PROJECTS_ALL
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
PACKAGE - GMS_BUDGET_UTILS
- GMS_AWARD_BAL_V
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
PACKAGE - GMS_BUDGET_UTILS
- GMS_AWARD_BAL_V
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 not referenced by any database object
[top of page]