[Home] [Help] [Dependency Information]

VIEW: APPS.PA_CI_CRPRJ_LIST_V

Object Details

Object Name:	PA_CI_CRPRJ_LIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_CI_CRPRJ_LIST_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

Query Text

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

SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_LONG_NAME
,      PROJECT_NAME_NUMBER
,      PROJECT_STATUS_CODE
,      PROJECT_START_DATE
,      CI_ID
,      CI_NUMBER
,      CI_TYPE_ID
,      SUMMARY
,      DESCRIPTION
,      STATUS_CODE
,      STATUS_DESCRIPTION
,      SYSTEM_STATUS_CODE
,      SYSTEM_STATUS_NAME
,      OWNER_ID
,      OWNER_NAME
,      OBJECT_TYPE
,      OBJECT_ID
,      OBJECT_NAME
,      OBJECT_NUMBER
,      OBJECT_NAME_NUMBER
,      DATE_REQUIRED
,      RESOLUTION_DESCRIPTION
,      RESOLUTION_COMMENT
,      RESOLUTION_CLASSIFICATION
,      STATUS_OVERVIEW
,      CLASSIFICATION_DESCRIPTION
,      REASON_DESCRIPTION
,      PRIORITY_CODE
,      PRIORITY_DESCRIPTION
,      PRIORITY_SORT
,      PRICE
,      PRICE_CURRENCY_CODE
,      PRICE_CURRENCY_DESCRIPTION
,      SOURCE_TYPE_CODE
,      SOURCE_TYPE_DESCRIPTION
,      SOURCE_COMMENT
,      SOURCE_NUMBER
,      SOURCE_DATE_RECEIVED
,      SOURCE_ORGANIZATION
,      SOURCE_PERSON
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      CI_TYPE_CLASS_CODE
,      CI_TYPE_NAME
,      CI_TYPE_SHORT_NAME
,      APPROVAL_REQUIRED_FLAG
,      HIGHLIGHTED_FLAG
,      DATE_CLOSED
,      CLOSED_BY_ID
,      CLOSED_BY_NAME
,      OPEN_ACTION_NUM
,      RECORD_VERSION_NUMBER
,      CREATE_ACTION_FLAG
,      UPDATE_FLAG
,      CI_TYPE_NUMBER
,      PROGRESS_STATUS_CODE
,      PROGRESS_STATUS_NAME
,      PROGRESS_AS_OF_DATE
,      PROGRESS_ACTIVE_ICON
,      EFFORT_LEVEL_CODE
,      EFFORT_LEVEL_NAME
,      DAYS_UNTIL_DUE
,      DAYS_SINCE_LAST_MODIFIED
,      EST_QUANTITY
,      LABOR_QUANTITY
,      EST_PROJECT_RAW_COST
,      TOTAL_PROJECT_RAW_COST
,      EST_PROJECT_BURDENED_COST
,      TOTAL_PROJECT_BURDENED_COST
,      EST_PROJECT_REVENUE
,      TOTAL_PROJECT_REVENUE
,      DERIVED_QUANTITY
,      DERIVED_COST
,      DERIVED_REVENUE
,      DERIVED_MARGIN
,      DERIVED_MARGIN_PERCENTAGE
,      EST_MARGIN
,      EST_MARGIN_PERCENTAGE
,      PLANNED_MARGIN
,      PLANNED_MARGIN_PERCENTAGE
,      PROJECT_CURRENCY_CODE
,      PROJECT_CURRENCY_NAME
,      LAST_MODIFIED_BY_ID
,      LAST_MODIFIED_BY_NAME
,      CLASSIFICATION_CODE_ID
,      REASON_CODE_ID
,      RESOLUTION_CODE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      HIGHLIGHTED_FLAG_CODE
FROM APPS.PA_CI_CRPRJ_LIST_V;

Dependencies

[top of page]

APPS

HZ_PARTIES

PA_CI_SECURED_V

PA_CI_SECURITY_PKG - show dependent code

PA_CI_TYPES_B

PA_CI_TYPES_TL

PA_CLASS_CODES

PA_CONTROL_ITEMS

PA_FP_CI_AMOUNTS_V

PA_LOOKUPS

PA_PROJECTS_ALL

PA_PROJECT_STATUSES

PA_PROJ_ELEMENTS_UTILS - show dependent code

APPS.PA_CI_CRPRJ_LIST_V is not referenced by any database object