[Home] [Help] [Dependency Information]

VIEW: APPS.GMS_FUNDSCTL_RES_V

Object Details

Object Name:	GMS_FUNDSCTL_RES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMS.GMS_FUNDSCTL_RES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT PACKET_ID
,      BC_PACKET_ID
,      PARENT_BC_PACKET_ID
,      REQUEST_ID
,      PROJECT_ID
,      AWARD_ID
,      TASK_ID
,      TOP_TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      ACTUAL_FLAG
,      STATUS_CODE
,      SET_OF_BOOKS_ID
,      JE_CATEGORY_NAME
,      JE_SOURCE_NAME
,      DOCUMENT_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      BUDGET_VERSION_ID
,      ACCOUNT_TYPE
,      ENTERED_DR
,      ENTERED_CR
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      GL_ROW_NUMBER
,      RESOURCE_LIST_MEMBER_ID
,      PARENT_RESOURCE_ID
,      BUD_RESOURCE_LIST_MEMBER_ID
,      BUD_TASK_ID
,      FUNDING_PATTERN_ID
,      FUNDING_SEQUENCE
,      FP_STATUS
,      R_FUNDS_CONTROL_LEVEL_CODE
,      RG_FUNDS_CONTROL_LEVEL_CODE
,      T_FUNDS_CONTROL_LEVEL_CODE
,      TT_FUNDS_CONTROL_LEVEL_CODE
,      A_FUNDS_CONTROL_LEVEL_CODE
,      AWARD_BUDGET_POSTED
,      AWARD_BUDGET_APPROVED
,      AWARD_BUDGET_PENDING
,      TOTAL_AWARD_BUDGET
,      AWARD_ENC_POSTED
,      AWARD_ENC_APPROVED
,      AWARD_ENC_PENDING
,      TOTAL_AWARD_ENCUMBRANCE
,      AWARD_ACTUAL_POSTED
,      AWARD_ACTUAL_APPROVED
,      AWARD_ACTUAL_PENDING
,      TOTAL_AWARD_ACTUAL
,      AWARD_RESULT_CODE
,      TOP_TASK_BUDGET_POSTED
,      TOP_TASK_BUDGET_APPROVED
,      TOP_TASK_BUDGET_PENDING
,      TOTAL_TOP_TASK_BUDGET
,      TOP_TASK_ENC_POSTED
,      TOP_TASK_ENC_APPROVED
,      TOP_TASK_ENC_PENDING
,      TOTAL_TOP_TASK_ENCUMBRANCE
,      TOP_TASK_ACTUAL_POSTED
,      TOP_TASK_ACTUAL_APPROVED
,      TOP_TASK_ACTUAL_PENDING
,      TOTAL_TOP_TASK_ACTUAL
,      TOP_TASK_RESULT_CODE
,      TASK_BUDGET_POSTED
,      TASK_BUDGET_APPROVED
,      TASK_BUDGET_PENDING
,      TOTAL_TASK_BUDGET
,      TASK_ENC_POSTED
,      TASK_ENC_APPROVED
,      TASK_ENC_PENDING
,      TOTAL_TASK_ENCUMBRANCE
,      TASK_ACTUAL_POSTED
,      TASK_ACTUAL_APPROVED
,      TASK_ACTUAL_PENDING
,      TOTAL_TASK_ACTUAL
,      TASK_RESULT_CODE
,      RES_GRP_BUDGET_POSTED
,      RES_GRP_BUDGET_APPROVED
,      RES_GRP_BUDGET_PENDING
,      TOTAL_RES_GRP_BUDGET
,      RES_GRP_ENC_POSTED
,      RES_GRP_ENC_APPROVED
,      RES_GRP_ENC_PENDING
,      TOTAL_RES_GRP_ENC
,      RES_GRP_ACTUAL_POSTED
,      RES_GRP_ACTUAL_APPROVED
,      RES_GRP_ACTUAL_PENDING
,      TOTAL_RES_GRP_ACTUAL
,      RES_GRP_RESULT_CODE
,      RES_BUDGET_POSTED
,      RES_BUDGET_APPROVED
,      RES_BUDGET_PENDING
,      TOTAL_RES_BUDGET
,      RES_ENC_POSTED
,      RES_ENC_APPROVED
,      RES_ENC_PENDING
,      TOTAL_RES_ENC
,      RES_ACTUAL_POSTED
,      RES_ACTUAL_APPROVED
,      RES_ACTUAL_PENDING
,      TOTAL_RES_ACTUAL
,      RES_RESULT_CODE
,      AWARD_FA_POSTED
,      AWARD_FA_PENDING
,      AWARD_FA_APPROVED
,      TOP_TASK_FA_POSTED
,      TOP_TASK_FA_PENDING
,      TOP_TASK_FA_APPROVED
,      TASK_FA_POSTED
,      TASK_FA_PENDING
,      TASK_FA_APPROVED
,      RES_FA_POSTED
,      RES_FA_PENDING
,      RES_FA_APPROVED
,      RES_GRP_FA_POSTED
,      RES_GRP_FA_PENDING
,      RES_GRP_FA_APPROVED
,      TOTAL_AWARD_FA
,      TOTAL_TASK_FA
,      TOTAL_TOP_TASK_FA
,      TOTAL_RES_FA
,      TOTAL_RES_GRP_FA
,      PROJECT
,      TASK
,      AWARD_NUMBER
,      VERSION_NAME
,      GMS_RESULT_CODE_MEAN
,      AWARD_RESULT_CODE_MEAN
,      TASK_RESULT_CODE_MEAN
,      RES_RESULT_CODE_MEAN
,      RES_GRP_RESULT_CODE_MEAN
,      TOP_TASK_RESULT_CODE_MEAN
,      ORG_ID
FROM APPS.GMS_FUNDSCTL_RES_V;

Dependencies

[top of page]

APPS

GMS_AWARDS_ALL

GMS_BC_PACKETS

GMS_BUDGET_VERSIONS

GMS_IMPLEMENTATIONS_ALL

GMS_LOOKUPS

PA_PROJECTS_ALL

PA_PROJECT_TYPES_ALL

PA_TASKS

APPS.GMS_FUNDSCTL_RES_V is not referenced by any database object