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

VIEW: APPS.PA_FP_ELIGIBLE_CI_V

Object Details
Object Name: PA_FP_ELIGIBLE_CI_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_FP_ELIGIBLE_CI_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.PA_FP_ELIGIBLE_CI_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymPA_BUDGET_VERSIONS
SynonymPA_CI_IMPACTS
ViewPA_CI_TYPES_VL
SynonymPA_CONTROL_ITEMS
ViewPA_LOOKUPS
SynonymPA_PROJECT_STATUSES
SynonymPA_PT_CO_IMPL_STATUSES
SynonymPA_TASKS
APPS.PA_FP_ELIGIBLE_CI_V is referenced by following:

SchemaAPPS
Package BodyPA_FIN_PLAN_PUB - show dependent code
Package BodyPA_FP_CONTROL_ITEMS_UTILS - show dependent code
Package BodyPA_FP_GEN_PUB - show dependent code