[Home] [Help] [Dependency Information]
Object Name: | PA_FP_ELIGIBLE_CI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_FP_ELIGIBLE_CI_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | Project id for which the control order is defined |
IMPACTED_TASK_ID | NUMBER | (15) | The task id of the task which will be impacted upon implementing the control order | |
FIN_PLAN_TYPE_ID | NUMBER | (15) | Yes | The finplan type id of the plan type to which the control order type is attached |
CI_VERSION_ID | NUMBER | (15) | Yes | The version id of the control order |
CI_VERSION_TYPE | VARCHAR2 | (30) | The version type of the control order | |
PT_CT_VERSION_TYPE | VARCHAR2 | (30) | Yes | The version type of the control order which can be implemented for the given plan type |
CI_ID | NUMBER | (15) | Yes | Control order item id |
CD_NUMBER | VARCHAR2 | (100) | Control order item number | |
CI_TYPE_ID | NUMBER | (15) | Yes | Control order type id |
CI_TYPE_NAME | VARCHAR2 | (150) | Yes | Control order type name |
SUMMARY | VARCHAR2 | (240) | Yes | Control order item summary |
TASK_NO | VARCHAR2 | (48) | The task identifier for the task which is impacted upon implementation of the control order | |
PROJECT_STATUS_NAME | VARCHAR2 | (80) | Yes | Current project status name of the control order |
PROJECT_SYSTEM_STATUS_CODE | VARCHAR2 | (30) | Yes | Current project system status code of the control order |
PEOPLE_EFFORT | NUMBER | The people quantity defined for the control order | ||
EQUIPMENT_EFFORT | NUMBER | The equipment quantity defined for the control order | ||
RAW_COST | NUMBER | The raw cost defined for the control order in Project Currency | ||
BURDENED_COST | NUMBER | The burdened cost defined for the control order in Project Currency | ||
REVENUE | NUMBER | The revenue defined for the control order in Project Currency | ||
PFC_RAW_COST | NUMBER | The raw cost defined for the control order in Project Functional Currency | ||
PFC_BURDENED_COST | NUMBER | The burdened cost defined for the control order in Project Functional Currency | ||
PFC_REVENUE | NUMBER | The revenue defined for the control order in Project Functional Currency | ||
REV_PARTIALLY_IMPL_FLAG | VARCHAR2 | (1) | Indicates that if a control has been partially implemented or not | |
OWNER_ID | NUMBER | (15) | Yes | The Owner Id of the Change Document |
OWNER | VARCHAR2 | (360) | Yes | The Owner Party Name of the Change Document |
REQUIRED_BY | DATE | The required by date of the Change Document | ||
PRIORITY_CODE | VARCHAR2 | (30) | The priority code of the Change Document | |
PRIORITY | VARCHAR2 | (80) | The priority of the Change Document | |
CI_TYPE_CLASS_CODE | VARCHAR2 | (30) | Yes | The Class Code of the Control Item Type |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, IMPACTED_TASK_ID
, FIN_PLAN_TYPE_ID
, CI_VERSION_ID
, CI_VERSION_TYPE
, PT_CT_VERSION_TYPE
, CI_ID
, CD_NUMBER
, CI_TYPE_ID
, CI_TYPE_NAME
, SUMMARY
, TASK_NO
, PROJECT_STATUS_NAME
, PROJECT_SYSTEM_STATUS_CODE
, PEOPLE_EFFORT
, EQUIPMENT_EFFORT
, RAW_COST
, BURDENED_COST
, REVENUE
, PFC_RAW_COST
, PFC_BURDENED_COST
, PFC_REVENUE
, REV_PARTIALLY_IMPL_FLAG
, OWNER_ID
, OWNER
, REQUIRED_BY
, PRIORITY_CODE
, PRIORITY
, CI_TYPE_CLASS_CODE
FROM APPS.PA_FP_ELIGIBLE_CI_V;
|
|
|