GMS Views (107)

GMS - Grants Accounting — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
GMS_1034_REPORT_V
GMS_ACT_PROJECTS_BASIC_V Actual projects that could potentially be funded by awards excluding the award projects
GMS_AWARDS
GMS_AWARDS_BASIC_V Awards funding a particular project or task
GMS_AWARDS_SRS_V
GMS_AWARDS_V Commented the allow_query in where clause as per bug 1538406
GMS_AWARD_BAL_V - Retrofitted
GMS_AWARD_PROJECTS_V View of award projects attached to the awards
GMS_AWARD_STATUS_V
GMS_AWD_V - Retrofitted
GMS_BILL_AWARD_PROJECTS_V
GMS_BIS_AWD_ACT_SRC_V
GMS_BIS_AWD_GR_RPT_V
GMS_BIS_AWD_ORG_RPT_V
GMS_BUDGETARY_CONTROL_AWARD_V
GMS_BUDGETARY_CONTROL_PROJ_V
GMS_BUDGETARY_CONTROL_TASK_V
GMS_BUDGET_CHANGE_REASON_V This view displays all the valid reason codes that can be specified when a budget is changed.
GMS_BUDGET_LINES_V 10SC Only
GMS_BUDGET_MATRIX_V - Retrofitted
GMS_BUDGET_VERSIONS_BASELND_V 10SC Only
GMS_BUDGET_VERSIONS_DRAFT_V - Retrofitted
GMS_BUDG_CONTROL_RES_GRP_V
GMS_CDL_BURDEN_DETAIL_V
GMS_COMMITMENTS_OVERRIDE_V
GMS_COMMITMENT_BURDEN_V
GMS_COMMITMENT_ENCUMBERED_V
GMS_COMMITMENT_TXNS_V A view of all oustanding project-related commitment costs.
GMS_CONTACTS_V
GMS_DEFAULT_REPORTS_V - Retrofitted - Retrofitted
GMS_DRAFT_INVOICES_V
GMS_DRAFT_INV_LINE_DETAILS_V
GMS_DRAFT_REVENUES_V - Retrofitted
GMS_DTRANGE_BAL_V - Retrofitted
GMS_EMPLOYEES
GMS_ENCUMBRANCES
GMS_ENCUMBRANCES_V
GMS_ENCUMBRANCE_GROUPS
GMS_ENCUMBRANCE_GROUPS_V
GMS_ENCUMBRANCE_ITEMS
GMS_ENCUMBRANCE_ITEMS_V
GMS_ENC_PSI_V
GMS_EVENTS_V
GMS_EXPEND_ITEMS_ADJUST_V
GMS_FP_DISTRIBUTIONS_V
GMS_FUNDING_AWARDS_V Projects that are funded by a particular award
GMS_FUNDING_PATTERNS
GMS_FUNDING_PATTERNS_V
GMS_FUNDSCTL_RES_V
GMS_FUNDSCTL_V - Retrofitted - Retrofitted
GMS_IMPLEMENTATIONS
GMS_INSTALLMENTS_V
GMS_IP_AWARD_LOV_V
GMS_KEY_MEMBER_ROLE_V view of key members for awards
GMS_LOC_CONTACTS_V
GMS_LOOKUPS
GMS_NONE_BAL_V - Retrofitted
GMS_NOTIFICATIONS_V
GMS_OPERATING_UNITS_V This view contains Operating Units defined in MO:Security Proifle and implemented Grants .
GMS_OVERRIDE_SCHEDULES_V
GMS_PERSONNEL_V
GMS_PHONE_CONTACTS_V
GMS_PQH_AWARDS_V
GMS_PQH_EXP_TYPES_V
GMS_PQH_PROJECTS_V
GMS_PROJECTS_BASIC_V
GMS_PROJECTS_BURDEN_V
GMS_PROJECTS_EXPEND_V Projects which expenditures can be charged to
GMS_PROJECTS_V
GMS_PROJECT_FUNDINGS_V
GMS_PROJECT_TYPES
GMS_REFERENCE_NUMBERS_V
GMS_REPORTS_V
GMS_REPORT_TEMPLATES_V
GMS_RESG_BAL_V - Retrofitted
GMS_RESG_BC_V - Retrofitted
GMS_RESG_V - Retrofitted
GMS_RES_V - Retrofitted
GMS_RXI_BURDEN_DETAIL_V
GMS_RXI_BURDEN_EXCEPTION_V
GMS_RXI_BURDEN_VARIANCE_SUM_V
GMS_RXI_BURDEN_VAR_RUNID_V
GMS_RXI_EXPENDITURES_INQ_V
GMS_RXI_EXP_DETAILS_V
GMS_SSA_AWARDS_V
GMS_SSA_AWARD_EXPTYPE_V
GMS_STATUS_ACCUM_PROJECT_V
GMS_STATUS_ACCUM_PROJ_BASE_V
GMS_STATUS_ACCUM_TASK_BASE_V
GMS_STATUS_ACTUALS_BASE1_V
GMS_STATUS_ACTUALS_BASE2_V
GMS_STATUS_ACTUALS_V
GMS_STATUS_AWARD_ACCUM_BASE_V
GMS_STATUS_AWARD_ACCUM_TASK_V
GMS_STATUS_AWARD_ACCUM_V
GMS_STATUS_COMMITMENTS_V
GMS_STATUS_PROJ_GENERIC_V
GMS_STATUS_RESOURCES_BASE_V
GMS_STATUS_RESOURCES_V
GMS_SUM_PRJ_FUNDINGS_V Commented the allow_query in where clause as per bug 1538406
GMS_TASK_BAL_V - Retrofitted
GMS_TASK_BUDGETS2_V
GMS_TASK_BUDGETS_V - Retrofitted
GMS_TASK_V - Retrofitted
GMS_TERMS_CONDITIONS_V
GMS_TRANSACTION_INTERFACE The view is obsolete
GMS_XLA_AWARD_REF_V