DBA Data[Home] [Help] [Dependency Information]

VIEW: GMS.GMS_BUDGET_VERSIONS#

Object Details
Object Name: GMS_BUDGET_VERSIONS#
Object Type: VIEW
Owner: GMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUDGET_VERSION_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
AWARD_ID NUMBER (15) Yes
BUDGET_TYPE_CODE VARCHAR2 (30) Yes
VERSION_NUMBER NUMBER (15) Yes
BUDGET_STATUS_CODE VARCHAR2 (30) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
CURRENT_FLAG VARCHAR2 (1) Yes
ORIGINAL_FLAG VARCHAR2 (1) Yes
CURRENT_ORIGINAL_FLAG VARCHAR2 (1) Yes
RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1) Yes
RESOURCE_LIST_ID NUMBER (15) Yes
VERSION_NAME VARCHAR2 (60)
BUDGET_ENTRY_METHOD_CODE VARCHAR2 (30)
BASELINED_BY_PERSON_ID NUMBER (15)
BASELINED_DATE DATE

CHANGE_REASON_CODE VARCHAR2 (30)
LABOR_QUANTITY NUMBER

LABOR_UNIT_OF_MEASURE VARCHAR2 (30)
RAW_COST NUMBER

BURDENED_COST NUMBER

REVENUE NUMBER

DESCRIPTION VARCHAR2 (255)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
FIRST_BUDGET_PERIOD VARCHAR2 (30)
PM_PRODUCT_CODE VARCHAR2 (30)
PM_BUDGET_REFERENCE VARCHAR2 (25)
WF_STATUS_CODE VARCHAR2 (30)
ADW_NOTIFY_FLAG VARCHAR2 (1)
PRC_GENERATED_FLAG VARCHAR2 (1)
FC_REQUIRED_FLAG VARCHAR2 (1)
CONC_REQUEST_ID NUMBER (15)
Query Text

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


SELECT BUDGET_VERSION_ID
,      PROJECT_ID
,      AWARD_ID
,      BUDGET_TYPE_CODE
,      VERSION_NUMBER
,      BUDGET_STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CURRENT_FLAG
,      ORIGINAL_FLAG
,      CURRENT_ORIGINAL_FLAG
,      RESOURCE_ACCUMULATED_FLAG
,      RESOURCE_LIST_ID
,      VERSION_NAME
,      BUDGET_ENTRY_METHOD_CODE
,      BASELINED_BY_PERSON_ID
,      BASELINED_DATE
,      CHANGE_REASON_CODE
,      LABOR_QUANTITY
,      LABOR_UNIT_OF_MEASURE
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FIRST_BUDGET_PERIOD
,      PM_PRODUCT_CODE
,      PM_BUDGET_REFERENCE
,      WF_STATUS_CODE
,      ADW_NOTIFY_FLAG
,      PRC_GENERATED_FLAG
,      FC_REQUIRED_FLAG
,      CONC_REQUEST_ID
FROM GMS.GMS_BUDGET_VERSIONS#;

Dependencies

[top of page]

GMS.GMS_BUDGET_VERSIONS# references the following:

SchemaGMS
TableGMS_BUDGET_VERSIONS
GMS.GMS_BUDGET_VERSIONS# is referenced by following:

SchemaAPPS
SynonymGMS_BUDGET_VERSIONS