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

TABLE: PA.PA_RESOURCE_ASGN_CURR

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


This table stores the rate overrides, the average rate, and the rollup amounts by currency for the planning transaction level.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_RESOURCE_ASGN_CURR_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRA_TXN_ID
PA_RESOURCE_ASGN_CURR_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ASSIGNMENT_ID
ColumnTXN_CURRENCY_CODE
PA_RESOURCE_ASGN_CURR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_VERSION_ID
Columns
Name Datatype Length Mandatory Comments
RA_TXN_ID NUMBER (15) Yes Unique identifier
BUDGET_VERSION_ID NUMBER (15) Yes The identifier of the budget version to which the resource is assigned
RESOURCE_ASSIGNMENT_ID NUMBER (15) Yes The system-generated number that uniquely identifies the resource assignment
TXN_CURRENCY_CODE VARCHAR2 (15) Yes The currency code of the transaction amount
TOTAL_QUANTITY NUMBER

The total quantity at the planning transaction level
TOTAL_INIT_QUANTITY NUMBER

The total actual quantity at the planning transaction level
TXN_RAW_COST_RATE_OVERRIDE NUMBER

The overriding cost rate at the planning transaction level
TXN_BURDEN_COST_RATE_OVERRIDE NUMBER

The overriding burden cost rate at the planning transaction level
TXN_BILL_RATE_OVERRIDE NUMBER

The overriding bill rate at the planning transaction level
TXN_AVERAGE_RAW_COST_RATE NUMBER

The average raw cost rate at the planning transaction level
TXN_AVERAGE_BURDEN_COST_RATE NUMBER

The average burden cost rate at the planning transaction level
TXN_AVERAGE_BILL_RATE NUMBER

The average bill rate at the planning transaction level
TXN_ETC_RAW_COST_RATE NUMBER

The ETC raw cost rate at the planning transaction level
TXN_ETC_BURDEN_COST_RATE NUMBER

The ETC burden cost rate at the planning transaction level
TXN_ETC_BILL_RATE NUMBER

The ETC bill rate at the planning transaction level
TOTAL_TXN_RAW_COST NUMBER

The total raw cost in transaction currency at the planning transaction level
TOTAL_TXN_BURDENED_COST NUMBER

The total burdened cost in transaction currency at the planning transaction level
TOTAL_TXN_REVENUE NUMBER

The total revenue in transaction currency at the planning transaction level
TOTAL_TXN_INIT_RAW_COST NUMBER

The total actual raw cost in transaction currency at the planning transaction level
TOTAL_TXN_INIT_BURDENED_COST NUMBER

The total actual burdened cost in transaction currency at the planning transaction level
TOTAL_TXN_INIT_REVENUE NUMBER

The total actual revenue in transaction currency at the planning transaction level
TOTAL_PROJECT_RAW_COST NUMBER

The total raw cost in project currency at the planning transaction level
TOTAL_PROJECT_BURDENED_COST NUMBER

The total burdened cost in project currency at the planning transaction level
TOTAL_PROJECT_REVENUE NUMBER

The total revenue in project currency at the planning transaction level
TOTAL_PROJECT_INIT_RAW_COST NUMBER

The total actual raw cost in project currency at the planning transaction level
TOTAL_PROJECT_INIT_BD_COST NUMBER

The total actual burdened cost in project currency at the planning transaction level
TOTAL_PROJECT_INIT_REVENUE NUMBER

The total actual revenue in project currency at the planning transaction level
TOTAL_PROJFUNC_RAW_COST NUMBER

The total raw cost in project functional currency at the planning transaction level
TOTAL_PROJFUNC_BURDENED_COST NUMBER

The total burdened cost in project functional currency at the planning transaction level
TOTAL_PROJFUNC_REVENUE NUMBER

The total revenue in project functional currency at the planning transaction level
TOTAL_PROJFUNC_INIT_RAW_COST NUMBER

The total actual raw cost in project functional currency at the planning transaction level
TOTAL_PROJFUNC_INIT_BD_COST NUMBER

The total actual burdened cost in project functional currency at the planning transaction level
TOTAL_PROJFUNC_INIT_REVENUE NUMBER

The total actual revenue in project functional currency at the planning transaction level
TOTAL_DISPLAY_QUANTITY NUMBER

The total display quantity at the planning transaction level
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Column
RECORD_VERSION_NUMBER NUMBER
Yes Indicates the record version number
Query Text

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


SELECT RA_TXN_ID
,      BUDGET_VERSION_ID
,      RESOURCE_ASSIGNMENT_ID
,      TXN_CURRENCY_CODE
,      TOTAL_QUANTITY
,      TOTAL_INIT_QUANTITY
,      TXN_RAW_COST_RATE_OVERRIDE
,      TXN_BURDEN_COST_RATE_OVERRIDE
,      TXN_BILL_RATE_OVERRIDE
,      TXN_AVERAGE_RAW_COST_RATE
,      TXN_AVERAGE_BURDEN_COST_RATE
,      TXN_AVERAGE_BILL_RATE
,      TXN_ETC_RAW_COST_RATE
,      TXN_ETC_BURDEN_COST_RATE
,      TXN_ETC_BILL_RATE
,      TOTAL_TXN_RAW_COST
,      TOTAL_TXN_BURDENED_COST
,      TOTAL_TXN_REVENUE
,      TOTAL_TXN_INIT_RAW_COST
,      TOTAL_TXN_INIT_BURDENED_COST
,      TOTAL_TXN_INIT_REVENUE
,      TOTAL_PROJECT_RAW_COST
,      TOTAL_PROJECT_BURDENED_COST
,      TOTAL_PROJECT_REVENUE
,      TOTAL_PROJECT_INIT_RAW_COST
,      TOTAL_PROJECT_INIT_BD_COST
,      TOTAL_PROJECT_INIT_REVENUE
,      TOTAL_PROJFUNC_RAW_COST
,      TOTAL_PROJFUNC_BURDENED_COST
,      TOTAL_PROJFUNC_REVENUE
,      TOTAL_PROJFUNC_INIT_RAW_COST
,      TOTAL_PROJFUNC_INIT_BD_COST
,      TOTAL_PROJFUNC_INIT_REVENUE
,      TOTAL_DISPLAY_QUANTITY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
FROM PA.PA_RESOURCE_ASGN_CURR;

Dependencies

[top of page]

PA.PA_RESOURCE_ASGN_CURR does not reference any database object

PA.PA_RESOURCE_ASGN_CURR is referenced by following:

SchemaAPPS
SynonymPA_RESOURCE_ASGN_CURR