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_LINES_M_UPG_DTRANGE#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)
START_DATE	DATE
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER		Yes
END_DATE	DATE
PERIOD_NAME	VARCHAR2	(30)
QUANTITY	NUMBER
RAW_COST	NUMBER
BURDENED_COST	NUMBER
REVENUE	NUMBER
CHANGE_REASON_CODE	VARCHAR2	(30)
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)
RAW_COST_SOURCE	VARCHAR2	(2)
BURDENED_COST_SOURCE	VARCHAR2	(2)
QUANTITY_SOURCE	VARCHAR2	(2)
REVENUE_SOURCE	VARCHAR2	(2)
PM_PRODUCT_CODE	VARCHAR2	(30)
PM_BUDGET_LINE_REFERENCE	VARCHAR2	(25)
COST_REJECTION_CODE	VARCHAR2	(30)
REVENUE_REJECTION_CODE	VARCHAR2	(30)
BURDEN_REJECTION_CODE	VARCHAR2	(30)
OTHER_REJECTION_CODE	VARCHAR2	(30)
CODE_COMBINATION_ID	NUMBER	(15)
CCID_GEN_STATUS_CODE	VARCHAR2	(1)
CCID_GEN_REJ_MESSAGE	VARCHAR2	(2000)
REQUEST_ID	NUMBER
BORROWED_REVENUE	NUMBER
TP_REVENUE_IN	NUMBER
TP_REVENUE_OUT	NUMBER
REVENUE_ADJ	NUMBER
LENT_RESOURCE_COST	NUMBER
TP_COST_IN	NUMBER
TP_COST_OUT	NUMBER
COST_ADJ	NUMBER
UNASSIGNED_TIME_COST	NUMBER
UTILIZATION_PERCENT	NUMBER
UTILIZATION_HOURS	NUMBER
UTILIZATION_ADJ	NUMBER
CAPACITY	NUMBER
HEAD_COUNT	NUMBER
HEAD_COUNT_ADJ	NUMBER
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_EXCHANGE_RATE	NUMBER
PROJFUNC_COST_RATE_DATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_RATE_DATE	DATE
PROJFUNC_REV_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_REV_EXCHANGE_RATE	NUMBER
PROJFUNC_REV_RATE_DATE_TYPE	VARCHAR2	(30)
PROJFUNC_REV_RATE_DATE	DATE
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_COST_RATE_TYPE	VARCHAR2	(30)
PROJECT_COST_EXCHANGE_RATE	NUMBER
PROJECT_COST_RATE_DATE_TYPE	VARCHAR2	(30)
PROJECT_COST_RATE_DATE	DATE
PROJECT_RAW_COST	NUMBER
PROJECT_BURDENED_COST	NUMBER
PROJECT_REV_RATE_TYPE	VARCHAR2	(30)
PROJECT_REV_EXCHANGE_RATE	NUMBER
PROJECT_REV_RATE_DATE_TYPE	VARCHAR2	(30)
PROJECT_REV_RATE_DATE	DATE
PROJECT_REVENUE	NUMBER
TXN_CURRENCY_CODE	VARCHAR2	(15)
TXN_RAW_COST	NUMBER
TXN_BURDENED_COST	NUMBER
TXN_REVENUE	NUMBER
BUCKETING_PERIOD_CODE	VARCHAR2	(30)
BUDGET_LINE_ID	NUMBER	(15)
BUDGET_VERSION_ID	NUMBER	(15)
BUDGET_VERSION_ID_RUP	NUMBER	(15)
RESOURCE_ASSIGNMENT_ID_RUP	NUMBER	(15)

Query Text

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


SELECT RESOURCE_ASSIGNMENT_ID
,      START_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      END_DATE
,      PERIOD_NAME
,      QUANTITY
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      CHANGE_REASON_CODE
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RAW_COST_SOURCE
,      BURDENED_COST_SOURCE
,      QUANTITY_SOURCE
,      REVENUE_SOURCE
,      PM_PRODUCT_CODE
,      PM_BUDGET_LINE_REFERENCE
,      COST_REJECTION_CODE
,      REVENUE_REJECTION_CODE
,      BURDEN_REJECTION_CODE
,      OTHER_REJECTION_CODE
,      CODE_COMBINATION_ID
,      CCID_GEN_STATUS_CODE
,      CCID_GEN_REJ_MESSAGE
,      REQUEST_ID
,      BORROWED_REVENUE
,      TP_REVENUE_IN
,      TP_REVENUE_OUT
,      REVENUE_ADJ
,      LENT_RESOURCE_COST
,      TP_COST_IN
,      TP_COST_OUT
,      COST_ADJ
,      UNASSIGNED_TIME_COST
,      UTILIZATION_PERCENT
,      UTILIZATION_HOURS
,      UTILIZATION_ADJ
,      CAPACITY
,      HEAD_COUNT
,      HEAD_COUNT_ADJ
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJFUNC_COST_RATE_DATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_REV_RATE_TYPE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_REV_RATE_DATE_TYPE
,      PROJFUNC_REV_RATE_DATE
,      PROJECT_CURRENCY_CODE
,      PROJECT_COST_RATE_TYPE
,      PROJECT_COST_EXCHANGE_RATE
,      PROJECT_COST_RATE_DATE_TYPE
,      PROJECT_COST_RATE_DATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_REV_RATE_DATE_TYPE
,      PROJECT_REV_RATE_DATE
,      PROJECT_REVENUE
,      TXN_CURRENCY_CODE
,      TXN_RAW_COST
,      TXN_BURDENED_COST
,      TXN_REVENUE
,      BUCKETING_PERIOD_CODE
,      BUDGET_LINE_ID
,      BUDGET_VERSION_ID
,      BUDGET_VERSION_ID_RUP
,      RESOURCE_ASSIGNMENT_ID_RUP
FROM PA.PA_BUDGET_LINES_M_UPG_DTRANGE#;

Dependencies

[top of page]

PA.PA_BUDGET_LINES_M_UPG_DTRANGE# references the following:

PA: PA_BUDGET_LINES_M_UPG_DTRANGE

PA.PA_BUDGET_LINES_M_UPG_DTRANGE# is referenced by following:

APPS: PA_BUDGET_LINES_M_UPG_DTRANGE