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.

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

VIEW: PA.PA_BUDGET_VERSIONS#

Object Details

Object Name:	PA_BUDGET_VERSIONS#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUDGET_VERSION_ID	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)	Yes
BUDGET_TYPE_CODE	VARCHAR2	(30)
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)
PLAN_RUN_DATE	DATE
PLAN_PROCESSING_CODE	VARCHAR2	(30)
RECORD_VERSION_NUMBER	NUMBER
PERIOD_PROFILE_ID	NUMBER	(15)
FIN_PLAN_TYPE_ID	NUMBER	(15)
PARENT_PLAN_VERSION_ID	NUMBER	(15)
PROJECT_STRUCTURE_VERSION_ID	NUMBER	(15)
TOTAL_BORROWED_REVENUE	NUMBER
TOTAL_TP_REVENUE_IN	NUMBER
TOTAL_TP_REVENUE_OUT	NUMBER
TOTAL_REVENUE_ADJ	NUMBER
TOTAL_LENT_RESOURCE_COST	NUMBER
TOTAL_TP_COST_IN	NUMBER
TOTAL_TP_COST_OUT	NUMBER
TOTAL_COST_ADJ	NUMBER
TOTAL_UNASSIGNED_TIME_COST	NUMBER
TOTAL_UTILIZATION_PERCENT	NUMBER
TOTAL_UTILIZATION_HOURS	NUMBER
TOTAL_UTILIZATION_ADJ	NUMBER
TOTAL_CAPACITY	NUMBER
TOTAL_HEAD_COUNT	NUMBER
TOTAL_HEAD_COUNT_ADJ	NUMBER
CURRENT_WORKING_FLAG	VARCHAR2	(1)
VERSION_TYPE	VARCHAR2	(30)
REQUEST_ID	NUMBER
TOTAL_PROJECT_RAW_COST	NUMBER
TOTAL_PROJECT_BURDENED_COST	NUMBER
TOTAL_PROJECT_REVENUE	NUMBER
LOCKED_BY_PERSON_ID	NUMBER	(15)
APPROVED_COST_PLAN_TYPE_FLAG	VARCHAR2	(1)
APPROVED_REV_PLAN_TYPE_FLAG	VARCHAR2	(1)
EST_PROJECT_RAW_COST	NUMBER
EST_PROJECT_BURDENED_COST	NUMBER
EST_PROJECT_REVENUE	NUMBER
EST_QUANTITY	NUMBER
EST_PROJFUNC_RAW_COST	NUMBER
EST_PROJFUNC_BURDENED_COST	NUMBER
EST_PROJFUNC_REVENUE	NUMBER
CI_ID	NUMBER	(15)
AGREEMENT_ID	NUMBER	(15)
PROCESS_UPDATE_WBS_FLAG	VARCHAR2	(1)
OBJECT_TYPE_CODE	VARCHAR2	(30)
OBJECT_ID	NUMBER	(15)
PRIMARY_COST_FORECAST_FLAG	VARCHAR2	(1)
PRIMARY_REV_FORECAST_FLAG	VARCHAR2	(1)
REV_PARTIALLY_IMPL_FLAG	VARCHAR2	(1)
EQUIPMENT_QUANTITY	NUMBER
PJI_SUMMARIZED_FLAG	VARCHAR2	(1)
WP_VERSION_FLAG	VARCHAR2	(1)
CURRENT_PLANNING_PERIOD	VARCHAR2	(15)
PERIOD_MASK_ID	NUMBER	(15)
LAST_AMT_GEN_DATE	DATE
ACTUAL_AMTS_THRU_PERIOD	VARCHAR2	(30)
EST_EQUIPMENT_QUANTITY	NUMBER
ETC_START_DATE	DATE
PURGED_FLAG	VARCHAR2	(2)
OLAP_CHANGE_FLAG	VARCHAR2	(1)

Query Text

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


SELECT BUDGET_VERSION_ID
,      PROJECT_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
,      PLAN_RUN_DATE
,      PLAN_PROCESSING_CODE
,      RECORD_VERSION_NUMBER
,      PERIOD_PROFILE_ID
,      FIN_PLAN_TYPE_ID
,      PARENT_PLAN_VERSION_ID
,      PROJECT_STRUCTURE_VERSION_ID
,      TOTAL_BORROWED_REVENUE
,      TOTAL_TP_REVENUE_IN
,      TOTAL_TP_REVENUE_OUT
,      TOTAL_REVENUE_ADJ
,      TOTAL_LENT_RESOURCE_COST
,      TOTAL_TP_COST_IN
,      TOTAL_TP_COST_OUT
,      TOTAL_COST_ADJ
,      TOTAL_UNASSIGNED_TIME_COST
,      TOTAL_UTILIZATION_PERCENT
,      TOTAL_UTILIZATION_HOURS
,      TOTAL_UTILIZATION_ADJ
,      TOTAL_CAPACITY
,      TOTAL_HEAD_COUNT
,      TOTAL_HEAD_COUNT_ADJ
,      CURRENT_WORKING_FLAG
,      VERSION_TYPE
,      REQUEST_ID
,      TOTAL_PROJECT_RAW_COST
,      TOTAL_PROJECT_BURDENED_COST
,      TOTAL_PROJECT_REVENUE
,      LOCKED_BY_PERSON_ID
,      APPROVED_COST_PLAN_TYPE_FLAG
,      APPROVED_REV_PLAN_TYPE_FLAG
,      EST_PROJECT_RAW_COST
,      EST_PROJECT_BURDENED_COST
,      EST_PROJECT_REVENUE
,      EST_QUANTITY
,      EST_PROJFUNC_RAW_COST
,      EST_PROJFUNC_BURDENED_COST
,      EST_PROJFUNC_REVENUE
,      CI_ID
,      AGREEMENT_ID
,      PROCESS_UPDATE_WBS_FLAG
,      OBJECT_TYPE_CODE
,      OBJECT_ID
,      PRIMARY_COST_FORECAST_FLAG
,      PRIMARY_REV_FORECAST_FLAG
,      REV_PARTIALLY_IMPL_FLAG
,      EQUIPMENT_QUANTITY
,      PJI_SUMMARIZED_FLAG
,      WP_VERSION_FLAG
,      CURRENT_PLANNING_PERIOD
,      PERIOD_MASK_ID
,      LAST_AMT_GEN_DATE
,      ACTUAL_AMTS_THRU_PERIOD
,      EST_EQUIPMENT_QUANTITY
,      ETC_START_DATE
,      PURGED_FLAG
,      OLAP_CHANGE_FLAG
FROM PA.PA_BUDGET_VERSIONS#;

Dependencies

[top of page]

PA.PA_BUDGET_VERSIONS# references the following:

PA: PA_BUDGET_VERSIONS

PA.PA_BUDGET_VERSIONS# is referenced by following:

APPS: PA_BUDGET_VERSIONS