[Home] [Help] [Dependency Information]
Object Name: | PA_FP_ELEMENTS |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_FP_ELEMENTS |
Subobject Name: | |
Status: | VALID |
This table stores plannable elements for a project. The plannable elements defined at a project level default to every plan type added to the project. The plannable elements defined for a plan type on a project default to every plan version created with that plan type
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_FP_ELEMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PROJ_FP_ELEMENTS_ID |
PA_FP_ELEMENTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROJ_FP_OPTIONS_ID
ELEMENT_TYPE TASK_ID RESOURCE_LIST_MEMBER_ID |
PA_FP_ELEMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RESOURCE_LIST_MEMBER_ID |
PA_FP_ELEMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TASK_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJ_FP_ELEMENTS_ID | NUMBER | (15) | Yes | System generated unique identifier which identifies each element. |
PROJ_FP_OPTIONS_ID | NUMBER | (15) | Yes | The identifier of the planning option to which the element belongs to |
PROJECT_ID | NUMBER | (15) | Yes | Unique identifier of the project |
FIN_PLAN_TYPE_ID | NUMBER | (15) | Unique identifier of the plan type | |
ELEMENT_TYPE | VARCHAR2 | (30) | Yes | Determines the type of planning elements. Can be any of COST/REVENUE/ALL |
FIN_PLAN_VERSION_ID | NUMBER | (15) | Unique identifier of the Plan Version. | |
TASK_ID | NUMBER | (15) | Yes | Unique identifier of the Task |
TOP_TASK_ID | NUMBER | (15) | Yes | Unique identifier of the top task |
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Yes | Unique identifier of the resource list member. |
TOP_TASK_PLANNING_LEVEL | VARCHAR2 | (30) | Indicates the planning level of the top task | |
RESOURCE_PLANNING_LEVEL | VARCHAR2 | (30) | Indicates the resource planning level for each task. | |
PLANNABLE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the element is planned for or not. |
RESOURCES_PLANNED_FOR_TASK | VARCHAR2 | (1) | Indicates whether the resources are planned for the task | |
PLAN_AMOUNT_EXISTS_FLAG | VARCHAR2 | (1) | Indicates whether plan amount exists for that element | |
TMP_PLANNABLE_FLAG | VARCHAR2 | (1) | Yes | Column used for internal processing |
TMP_TOP_TASK_PLANNING_LEVEL | VARCHAR2 | (30) | Column used for internal processing | |
RECORD_VERSION_NUMBER | NUMBER | (15) | Yes | Internally generated number used for record locking |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT PROJ_FP_ELEMENTS_ID
, PROJ_FP_OPTIONS_ID
, PROJECT_ID
, FIN_PLAN_TYPE_ID
, ELEMENT_TYPE
, FIN_PLAN_VERSION_ID
, TASK_ID
, TOP_TASK_ID
, RESOURCE_LIST_MEMBER_ID
, TOP_TASK_PLANNING_LEVEL
, RESOURCE_PLANNING_LEVEL
, PLANNABLE_FLAG
, RESOURCES_PLANNED_FOR_TASK
, PLAN_AMOUNT_EXISTS_FLAG
, TMP_PLANNABLE_FLAG
, TMP_TOP_TASK_PLANNING_LEVEL
, RECORD_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM PA.PA_FP_ELEMENTS;
PA.PA_FP_ELEMENTS does not reference any database object
PA.PA_FP_ELEMENTS is referenced by following:
|
|
|