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

TABLE: PA.PA_BUDGET_LINES

Object Details
Object Name: PA_BUDGET_LINES
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_BUDGET_LINES
Subobject Name:
Status: VALID


PA_ BUDGET_LINES stores the detail information of a project or task
budget, including the resource, time period and budget amounts
entered. The time period may be PA period, GL period, or any
user-defined period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_BUDGET_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ASSIGNMENT_ID
ColumnSTART_DATE
ColumnTXN_CURRENCY_CODE
PA_BUDGET_LINES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_LINE_ID
PA_BUDGET_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE
ColumnEND_DATE
PA_BUDGET_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ASSIGNMENT_ID
ColumnPERIOD_NAME
PA_BUDGET_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_VERSION_ID
ColumnSTART_DATE
PA_BUDGET_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBC_EVENT_ID
PA_BUDGET_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBC_REV_EVENT_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ASSIGNMENT_ID NUMBER (15) Yes The identifier of the resource assignment of the budget line
START_DATE DATE
Yes 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
Yes 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)
The description of the budget line
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
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) Yes 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) Yes Unique identifier of budget line
BUDGET_VERSION_ID NUMBER (15) Yes Unique identifier of budget version
TXN_STANDARD_COST_RATE NUMBER

It stores the standard cost rate
TXN_COST_RATE_OVERRIDE NUMBER

It stores the overriding cost rate of the assignment.
COST_IND_COMPILED_SET_ID NUMBER (15)
The identifier of the compiled set that is used to calculate the cost amount of the expenditure item
TXN_STANDARD_BILL_RATE NUMBER

The standard bill rate
TXN_BILL_RATE_OVERRIDE NUMBER

The override bill rate
TXN_MARKUP_PERCENT NUMBER

The markup percent.
TXN_MARKUP_PERCENT_OVERRIDE NUMBER

The override markup percent
TXN_DISCOUNT_PERCENTAGE NUMBER

The discount percentage
TRANSFER_PRICE_RATE NUMBER

It stores the transfer price rate
INIT_QUANTITY NUMBER

It stores the initial quantity
INIT_QUANTITY_SOURCE VARCHAR2 (2)
It stores the initial quantity source
INIT_RAW_COST NUMBER

It stores the initial raw cost in project functional currency
INIT_BURDENED_COST NUMBER

It stores the initial burdened cost in project functional currency
INIT_REVENUE NUMBER

It stores the initial revenue in project functional currency
INIT_RAW_COST_SOURCE VARCHAR2 (2)
It stores the initial raw cost source
INIT_BURDENED_COST_SOURCE VARCHAR2 (2)
It stores the initial burdened cost source
INIT_REVENUE_SOURCE VARCHAR2 (2)
It stores the initial revenue source
PROJECT_INIT_RAW_COST NUMBER

The initial raw cost in project currency
PROJECT_INIT_BURDENED_COST NUMBER

The initial burdened cost in project currency
PROJECT_INIT_REVENUE NUMBER

The initial revenue in project currency
TXN_INIT_RAW_COST NUMBER

The initial raw cost in transaction currency
TXN_INIT_BURDENED_COST NUMBER

The initial burdened cost in transaction currency
TXN_INIT_REVENUE NUMBER

The initial revenue in transaction currency
BURDEN_COST_RATE NUMBER

The burden cost rate in transaction currency
BURDEN_COST_RATE_OVERRIDE NUMBER

The burden cost rate override in transaction currency
PC_CUR_CONV_REJECTION_CODE VARCHAR2 (30)
Indicates the rejection code while trying to convert the transaction currency into project currency.
PFC_CUR_CONV_REJECTION_CODE VARCHAR2 (30)
Indicates the rejection code while trying to convert the transaction currency into project functional currency.
SYSTEM_REFERENCE_NUM1 NUMBER

Budget line reference column used for internal purpose
SYSTEM_REFERENCE_NUM2 NUMBER

Budget line reference column used for internal purpose
SYSTEM_REFERENCE_NUM3 NUMBER

Budget line reference column used for internal purpose
SYSTEM_REFERENCE_VAR1 VARCHAR2 (150)
Budget line reference column used for internal purpose
SYSTEM_REFERENCE_VAR2 VARCHAR2 (150)
Budget line reference column used for internal purpose
SYSTEM_REFERENCE_VAR3 VARCHAR2 (150)
Budget line reference column used for internal purpose
SYSTEM_REFERENCE_DAT1 DATE

Budget line reference column used for internal purpose
SYSTEM_REFERENCE_DAT2 DATE

Budget line reference column used for internal purpose
SYSTEM_REFERENCE_DAT3 DATE

Budget line reference column used for internal purpose
BC_EVENT_ID NUMBER (15)
Budgetary control event identifier
BC_REV_EVENT_ID NUMBER (15)
Budgetary control reversal event identifier
DISPLAY_QUANTITY NUMBER

"Used to display quantity for rate based planning resource"
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 does not reference any database object

PA.PA_BUDGET_LINES is referenced by following:

SchemaPA
ViewPA_BUDGET_LINES#