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]

TABLE: PA.PA_BUDGET_LINES_M_UPG_DTRANGE

Object Details

Object Name:	PA_BUDGET_LINES_M_UPG_DTRANGE
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_BUDGET_LINES_M_UPG_DTRANGE
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)		The identifier of the resource assignment of the budget line.
START_DATE	DATE			The start date of the budget line.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
CREATED_BY	NUMBER		Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column.
END_DATE	DATE			The end date of the budget line.
PERIOD_NAME	VARCHAR2	(30)		The period of the budget line.
QUANTITY	NUMBER			The quantity of the budget line.
RAW_COST	NUMBER			The raw cost of the budget line.
BURDENED_COST	NUMBER			The burdened cost of the budget line.
REVENUE	NUMBER			The revenue of the budget line.
CHANGE_REASON_CODE	VARCHAR2	(30)		The reason to create the budget line.
DESCRIPTION	VARCHAR2	(255)		Descriptive flexfield context field.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
RAW_COST_SOURCE	VARCHAR2	(2)		Currently not used.
BURDENED_COST_SOURCE	VARCHAR2	(2)		Currently not used.
QUANTITY_SOURCE	VARCHAR2	(2)		Currently not used.
REVENUE_SOURCE	VARCHAR2	(2)		Currently not used.
PM_PRODUCT_CODE	VARCHAR2	(30)		The identifier of the external project management system from which the budget was imported.
PM_BUDGET_LINE_REFERENCE	VARCHAR2	(25)		The identifier of the budget in the external project management system from which the budget was imported.
COST_REJECTION_CODE	VARCHAR2	(30)		This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of cost amounts.
REVENUE_REJECTION_CODE	VARCHAR2	(30)		This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of revenue amounts.
BURDEN_REJECTION_CODE	VARCHAR2	(30)		This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of burdened cost amounts.
OTHER_REJECTION_CODE	VARCHAR2	(30)		This column applies to generation of project forecasts. It stores the message code that is applicable whenever an unexpected error is encountered.
CODE_COMBINATION_ID	NUMBER	(15)		Accounting code identifier for the budget line.
CCID_GEN_STATUS_CODE	VARCHAR2	(1)		This indicates the following for accounting code generation : (P) Pending, (G) Generated, (E) Error in Generating Account.
CCID_GEN_REJ_MESSAGE	VARCHAR2	(2000)		Message for account generation failure reason.
REQUEST_ID	NUMBER			The concurrent request id of the budget line being processed.
BORROWED_REVENUE	NUMBER			The borrowed revenue of budget line.
TP_REVENUE_IN	NUMBER			The transfer-price revenue in of budget line.
TP_REVENUE_OUT	NUMBER			The transfer-price revenue out of budget line.
REVENUE_ADJ	NUMBER			The revenue adjustment of budget line.
LENT_RESOURCE_COST	NUMBER			The lent resource cost of budget line.
TP_COST_IN	NUMBER			The transfer-price cost in of budget line.
TP_COST_OUT	NUMBER			The transfer-price cost out of budget line.
COST_ADJ	NUMBER			The cost adjustment of budget line.
UNASSIGNED_TIME_COST	NUMBER			The unassigned time cost of budget line.
UTILIZATION_PERCENT	NUMBER			The utilization percent of budget line.
UTILIZATION_HOURS	NUMBER			The utilization hours of budget line.
UTILIZATION_ADJ	NUMBER			The utilization percent adjustment of budget line.
CAPACITY	NUMBER			The capacity of budget line.
HEAD_COUNT	NUMBER			The head count of budget line.
HEAD_COUNT_ADJ	NUMBER			The head count adjustment of budget line.
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		The project functional currency code.
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)		The project functional cost rate type .
PROJFUNC_COST_EXCHANGE_RATE	NUMBER			The project functional cost exchange rate.
PROJFUNC_COST_RATE_DATE_TYPE	VARCHAR2	(30)		The project functional cost rate date type.
PROJFUNC_COST_RATE_DATE	DATE			The cost rate date for project functional currency.
PROJFUNC_REV_RATE_TYPE	VARCHAR2	(30)		The project functional revenue rate type.
PROJFUNC_REV_EXCHANGE_RATE	NUMBER			The project functional revenue exchange rate.
PROJFUNC_REV_RATE_DATE_TYPE	VARCHAR2	(30)		The project functional revenue rate date type.
PROJFUNC_REV_RATE_DATE	DATE			The revenue rate date for project functional currency.
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		The project currency code.
PROJECT_COST_RATE_TYPE	VARCHAR2	(30)		The project cost rate type.
PROJECT_COST_EXCHANGE_RATE	NUMBER			The project cost exchange rate.
PROJECT_COST_RATE_DATE_TYPE	VARCHAR2	(30)		The project cost rate date type.
PROJECT_COST_RATE_DATE	DATE			The cost rate date for project currency.
PROJECT_RAW_COST	NUMBER			The project raw cost.
PROJECT_BURDENED_COST	NUMBER			The project burdened cost.
PROJECT_REV_RATE_TYPE	VARCHAR2	(30)		The project revenue rate type.
PROJECT_REV_EXCHANGE_RATE	NUMBER			The project revenue exchange rate.
PROJECT_REV_RATE_DATE_TYPE	VARCHAR2	(30)		The project revenue rate date type .
PROJECT_REV_RATE_DATE	DATE			The revenue rate date for project currency.
PROJECT_REVENUE	NUMBER			The project revenue.
TXN_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code of the amount.
TXN_RAW_COST	NUMBER			The raw cost in transaction currency.
TXN_BURDENED_COST	NUMBER			The burdened cost in transaction currency.
TXN_REVENUE	NUMBER			The revenue in transaction currency.
BUCKETING_PERIOD_CODE	VARCHAR2	(30)		Determines whether bucket is for preceding or succeeding periods.
BUDGET_LINE_ID	NUMBER	(15)		Unique identifier of budget line.
BUDGET_VERSION_ID	NUMBER	(15)		Unique identifier of budget version.
BUDGET_VERSION_ID_RUP	NUMBER	(15)		Unique identifier of budget version upgraded in the Optional upgrade
RESOURCE_ASSIGNMENT_ID_RUP	NUMBER	(15)		The identifier of the resource assignment of the budget line that is rolled up using optional upgrade

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 does not reference any database object

PA.PA_BUDGET_LINES_M_UPG_DTRANGE is referenced by following:

PA: PA_BUDGET_LINES_M_UPG_DTRANGE#