[Home] [Help] [Dependency Information]
Object Name: | PA_FIN_PLAN_LINES_TMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
This is an internal table required in financial planning to store the various amount types and periods as rows before they are stored in PA_PROJECT_PERIODS_DENORM table
PA.PA_FIN_PLAN_LINES_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_FIN_PLAN_LINES_TMP_N1 | NORMAL | NONUNIQUE |
RESOURCE_ASSIGNMENT_ID
CURRENCY_TYPE OBJECT_TYPE_CODE OBJECT_ID CURRENCY_CODE START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | (15) | Yes | Stores the Object ID |
OBJECT_TYPE_CODE | VARCHAR2 | (30) | Yes | Stores the Object Type Code |
RESOURCE_ASSIGNMENT_ID | NUMBER | (15) | Stores the Resource Assignment ID | |
PERIOD_NAME | VARCHAR2 | (30) | Stores the Period Name, PA or GL period | |
START_DATE | DATE | Stores the Start Date | ||
END_DATE | DATE | Stores the End Date | ||
CURRENCY_TYPE | VARCHAR2 | (30) | Yes | Stores the Currency Type |
CURRENCY_CODE | VARCHAR2 | (30) | Yes | Stores the Currency Code |
QUANTITY | NUMBER | Stores the Quantity | ||
RAW_COST | NUMBER | Stores the Raw Cost amount | ||
BURDENED_COST | NUMBER | Stores the Burdened Cost amount | ||
REVENUE | NUMBER | Stores the Revenue amount | ||
OLD_QUANTITY | NUMBER | |||
OLD_RAW_COST | NUMBER | |||
OLD_BURDENED_COST | NUMBER | |||
OLD_REVENUE | NUMBER | |||
BORROWED_REVENUE | NUMBER | Stores the Borrowed Revenue amount | ||
TP_REVENUE_IN | NUMBER | Stores the Transfer Price Revenue amount coming into the Organization | ||
TP_REVENUE_OUT | NUMBER | Stores the Transfer Price Revenue amount going out of the Organization | ||
REVENUE_ADJ | NUMBER | Stores the Revenue Adjustment amount | ||
LENT_RESOURCE_COST | NUMBER | Stores the Cost amount of the Lending Resource | ||
TP_COST_IN | NUMBER | Stores the Transfer Price amount coming into the Organization | ||
TP_COST_OUT | NUMBER | Stores the Transfer Price amoung going out of the Organization | ||
COST_ADJ | NUMBER | Stores the adjustment Cost amount | ||
UNASSIGNED_TIME_COST | NUMBER | Stores the Cost amount of the Unassigned time | ||
UTILIZATION_PERCENT | NUMBER | Stores the Utilization Percentage | ||
UTILIZATION_ADJ | NUMBER | Stores the Utilization Adjustment value | ||
UTILIZATION_HOURS | NUMBER | Stores the Utilization Hours | ||
CAPACITY | NUMBER | Stores the Capacity | ||
HEAD_COUNT | NUMBER | Stores the Head Count | ||
HEAD_COUNT_ADJ | NUMBER | Stores the Head Count Adjustment | ||
MARGIN | NUMBER | Stores the Margin | ||
MARGIN_PERCENTAGE | NUMBER | Stores the Margin Percentage | ||
OLD_BORROWED_REVENUE | NUMBER | |||
OLD_TP_REVENUE_IN | NUMBER | |||
OLD_TP_REVENUE_OUT | NUMBER | |||
OLD_REVENUE_ADJ | NUMBER | |||
OLD_LENT_RESOURCE_COST | NUMBER | |||
OLD_TP_COST_IN | NUMBER | |||
OLD_TP_COST_OUT | NUMBER | |||
OLD_COST_ADJ | NUMBER | |||
OLD_UNASSIGNED_TIME_COST | NUMBER | |||
OLD_UTILIZATION_PERCENT | NUMBER | |||
OLD_UTILIZATION_ADJ | NUMBER | |||
OLD_UTILIZATION_HOURS | NUMBER | |||
OLD_CAPACITY | NUMBER | |||
OLD_HEAD_COUNT | NUMBER | |||
OLD_HEAD_COUNT_ADJ | NUMBER | |||
OLD_MARGIN | NUMBER | |||
OLD_MARGIN_PERCENTAGE | NUMBER | |||
BUCKETING_PERIOD_CODE | VARCHAR2 | (30) | Stores the Bucketing period code | |
PARENT_ASSIGNMENT_ID | NUMBER | |||
DELETE_FLAG | VARCHAR2 | (1) | ||
SOURCE_TXN_CURRENCY_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_ID
, OBJECT_TYPE_CODE
, RESOURCE_ASSIGNMENT_ID
, PERIOD_NAME
, START_DATE
, END_DATE
, CURRENCY_TYPE
, CURRENCY_CODE
, QUANTITY
, RAW_COST
, BURDENED_COST
, REVENUE
, OLD_QUANTITY
, OLD_RAW_COST
, OLD_BURDENED_COST
, OLD_REVENUE
, 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_ADJ
, UTILIZATION_HOURS
, CAPACITY
, HEAD_COUNT
, HEAD_COUNT_ADJ
, MARGIN
, MARGIN_PERCENTAGE
, OLD_BORROWED_REVENUE
, OLD_TP_REVENUE_IN
, OLD_TP_REVENUE_OUT
, OLD_REVENUE_ADJ
, OLD_LENT_RESOURCE_COST
, OLD_TP_COST_IN
, OLD_TP_COST_OUT
, OLD_COST_ADJ
, OLD_UNASSIGNED_TIME_COST
, OLD_UTILIZATION_PERCENT
, OLD_UTILIZATION_ADJ
, OLD_UTILIZATION_HOURS
, OLD_CAPACITY
, OLD_HEAD_COUNT
, OLD_HEAD_COUNT_ADJ
, OLD_MARGIN
, OLD_MARGIN_PERCENTAGE
, BUCKETING_PERIOD_CODE
, PARENT_ASSIGNMENT_ID
, DELETE_FLAG
, SOURCE_TXN_CURRENCY_CODE
FROM PA.PA_FIN_PLAN_LINES_TMP;
PA.PA_FIN_PLAN_LINES_TMP does not reference any database object
PA.PA_FIN_PLAN_LINES_TMP is referenced by following:
|
|
|