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#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)	Yes
START_DATE	DATE		Yes
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		Yes
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)	Yes
TXN_RAW_COST	NUMBER
TXN_BURDENED_COST	NUMBER
TXN_REVENUE	NUMBER
BUCKETING_PERIOD_CODE	VARCHAR2	(30)
BUDGET_LINE_ID	NUMBER	(15)	Yes
BUDGET_VERSION_ID	NUMBER	(15)	Yes
TXN_STANDARD_COST_RATE	NUMBER
TXN_COST_RATE_OVERRIDE	NUMBER
COST_IND_COMPILED_SET_ID	NUMBER	(15)
TXN_STANDARD_BILL_RATE	NUMBER
TXN_BILL_RATE_OVERRIDE	NUMBER
TXN_MARKUP_PERCENT	NUMBER
TXN_MARKUP_PERCENT_OVERRIDE	NUMBER
TXN_DISCOUNT_PERCENTAGE	NUMBER
TRANSFER_PRICE_RATE	NUMBER
INIT_QUANTITY	NUMBER
INIT_QUANTITY_SOURCE	VARCHAR2	(2)
INIT_RAW_COST	NUMBER
INIT_BURDENED_COST	NUMBER
INIT_REVENUE	NUMBER
INIT_RAW_COST_SOURCE	VARCHAR2	(2)
INIT_BURDENED_COST_SOURCE	VARCHAR2	(2)
INIT_REVENUE_SOURCE	VARCHAR2	(2)
PROJECT_INIT_RAW_COST	NUMBER
PROJECT_INIT_BURDENED_COST	NUMBER
PROJECT_INIT_REVENUE	NUMBER
TXN_INIT_RAW_COST	NUMBER
TXN_INIT_BURDENED_COST	NUMBER
TXN_INIT_REVENUE	NUMBER
BURDEN_COST_RATE	NUMBER
BURDEN_COST_RATE_OVERRIDE	NUMBER
PC_CUR_CONV_REJECTION_CODE	VARCHAR2	(30)
PFC_CUR_CONV_REJECTION_CODE	VARCHAR2	(30)
SYSTEM_REFERENCE_NUM1	NUMBER
SYSTEM_REFERENCE_NUM2	NUMBER
SYSTEM_REFERENCE_NUM3	NUMBER
SYSTEM_REFERENCE_VAR1	VARCHAR2	(150)
SYSTEM_REFERENCE_VAR2	VARCHAR2	(150)
SYSTEM_REFERENCE_VAR3	VARCHAR2	(150)
SYSTEM_REFERENCE_DAT1	DATE
SYSTEM_REFERENCE_DAT2	DATE
SYSTEM_REFERENCE_DAT3	DATE
BC_EVENT_ID	NUMBER	(15)
BC_REV_EVENT_ID	NUMBER	(15)
DISPLAY_QUANTITY	NUMBER

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
,      TXN_STANDARD_COST_RATE
,      TXN_COST_RATE_OVERRIDE
,      COST_IND_COMPILED_SET_ID
,      TXN_STANDARD_BILL_RATE
,      TXN_BILL_RATE_OVERRIDE
,      TXN_MARKUP_PERCENT
,      TXN_MARKUP_PERCENT_OVERRIDE
,      TXN_DISCOUNT_PERCENTAGE
,      TRANSFER_PRICE_RATE
,      INIT_QUANTITY
,      INIT_QUANTITY_SOURCE
,      INIT_RAW_COST
,      INIT_BURDENED_COST
,      INIT_REVENUE
,      INIT_RAW_COST_SOURCE
,      INIT_BURDENED_COST_SOURCE
,      INIT_REVENUE_SOURCE
,      PROJECT_INIT_RAW_COST
,      PROJECT_INIT_BURDENED_COST
,      PROJECT_INIT_REVENUE
,      TXN_INIT_RAW_COST
,      TXN_INIT_BURDENED_COST
,      TXN_INIT_REVENUE
,      BURDEN_COST_RATE
,      BURDEN_COST_RATE_OVERRIDE
,      PC_CUR_CONV_REJECTION_CODE
,      PFC_CUR_CONV_REJECTION_CODE
,      SYSTEM_REFERENCE_NUM1
,      SYSTEM_REFERENCE_NUM2
,      SYSTEM_REFERENCE_NUM3
,      SYSTEM_REFERENCE_VAR1
,      SYSTEM_REFERENCE_VAR2
,      SYSTEM_REFERENCE_VAR3
,      SYSTEM_REFERENCE_DAT1
,      SYSTEM_REFERENCE_DAT2
,      SYSTEM_REFERENCE_DAT3
,      BC_EVENT_ID
,      BC_REV_EVENT_ID
,      DISPLAY_QUANTITY
FROM PA.PA_BUDGET_LINES#;

Dependencies

[top of page]

PA.PA_BUDGET_LINES# references the following:

PA: PA_BUDGET_LINES

PA.PA_BUDGET_LINES# is referenced by following:

APPS: PA_BUDGET_LINES