[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_CI_BASIC_CTL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_CI_BASIC_CTL_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_NUMBER | VARCHAR2 | (25) | Yes | |
| PROJECT_NAME | VARCHAR2 | (57) | ||
| PROJECT_STATUS_CODE | VARCHAR2 | (30) | Yes | |
| PROJECT_START_DATE | DATE | |||
| CI_ID | NUMBER | (15) | Yes | |
| CI_NUMBER | VARCHAR2 | (100) | ||
| TYPE_ID | NUMBER | (15) | Yes | |
| SUBJECT | VARCHAR2 | (240) | Yes | |
| DESCRIPTION | VARCHAR2 | (2000) | ||
| STATUS_CODE | VARCHAR2 | (100) | Yes | |
| STATUS_DESCRIPTION | VARCHAR2 | (80) | ||
| SYSTEM_STATUS_CODE | VARCHAR2 | (30) | ||
| OWNER_ID | NUMBER | (15) | Yes | |
| OWNER_NAME | VARCHAR2 | (360) | ||
| OBJECT_TYPE | VARCHAR2 | (100) | ||
| OBJECT_ID | NUMBER | (15) | ||
| OBJECT_NAME | VARCHAR2 | (4000) | ||
| DATE_REQUIRED | DATE | |||
| RESOLUTION_CODE_ID | NUMBER | (15) | ||
| RESOLUTION_DESCRIPTION | VARCHAR2 | (30) | ||
| RESOLUTION_COMMENT | VARCHAR2 | (4000) | ||
| STATUS_OVERVIEW | VARCHAR2 | (4000) | ||
| CLASSIFICATION_CODE_ID | NUMBER | (15) | ||
| CLASSIFICATION_DESCRIPTION | VARCHAR2 | (30) | ||
| REASON_CODE_ID | NUMBER | (15) | ||
| REASON_DESCRIPTION | VARCHAR2 | (30) | ||
| PRIORITY_CODE | VARCHAR2 | (30) | ||
| PRIORITY_DESCRIPTION | VARCHAR2 | (80) | ||
| PRICE | NUMBER | |||
| PRICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
| PRICE_CURRENCY_DESCRIPTION | VARCHAR2 | (240) | ||
| SOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
| SOURCE_TYPE_DESCRIPTION | VARCHAR2 | (80) | ||
| SOURCE_COMMENT | VARCHAR2 | (2000) | ||
| SOURCE_NUMBER | VARCHAR2 | (100) | ||
| SOURCE_DATE_RECEIVED | DATE | |||
| SOURCE_ORGANIZATION | VARCHAR2 | (150) | ||
| SOURCE_PERSON_NAME | VARCHAR2 | (150) | ||
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| CREATED_BY_ID | NUMBER | (15) | Yes | |
| CREATED_BY_NAME | VARCHAR2 | (4000) | ||
| LAST_UPDATED_BY_ID | NUMBER | (15) | Yes | |
| LAST_UPDATED_BY_NAME | VARCHAR2 | (4000) | ||
| CI_TYPE_CLASS_CODE | VARCHAR2 | (30) | Yes | |
| CI_TYPE_NAME | VARCHAR2 | (150) | Yes | |
| CI_TYPE_SHORT_NAME | VARCHAR2 | (30) | Yes | |
| APPROVAL_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | |
| AUTO_NUMBER_FLAG | VARCHAR2 | (1) | Yes | |
| RESOLUTION_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | |
| SOURCE_ATTRS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| HIGHLIGHTED_FLAG | VARCHAR2 | (1) | Yes | |
| CLOSED_DATE | DATE | |||
| CLOSED_BY_ID | NUMBER | (15) | ||
| CLOSED_BY_NAME | VARCHAR2 | (360) | ||
| RECORD_VERSION_NUMBER | NUMBER | (15) | Yes | |
| OPEN_ACTION_NUM | NUMBER | (15) | ||
| EFFORT_LEVEL_CODE | VARCHAR2 | (30) | ||
| EFFORT_LEVEL_MEANING | VARCHAR2 | (80) | ||
| LAST_MODIFICATION_DATE | DATE | Yes | ||
| LAST_MODIFIED_BY_ID | NUMBER | (15) | Yes | |
| LAST_MODIFIED_BY_NAME | VARCHAR2 | (360) | ||
| PROGRESS_STATUS_CODE | VARCHAR2 | (30) | ||
| PROGRESS_STATUS_NAME | VARCHAR2 | (80) | ||
| STATUS_ICON_IND | VARCHAR2 | (80) | ||
| STATUS_ICON_ACTIVE_IND | VARCHAR2 | (80) | ||
| PROGRESS_AS_OF_DATE | DATE | Yes | ||
| CLOSE_ALLOWED | VARCHAR2 | (4000) | ||
| DELETE_ALLOWED | VARCHAR2 | (4000) | ||
| SUBMIT_ALLOWED | VARCHAR2 | (4000) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ROW_ID | ROWID | (10) | ||
| PCO_NUMBER | VARCHAR2 | (0) | ||
| VERSION_COMMENTS | VARCHAR2 | (4000) | ||
| PCO_STATUS_CODE | VARCHAR2 | (30) | ||
| PCO_STATUS | VARCHAR2 | (80) | ||
| APPROVAL_TYPE_CODE | VARCHAR2 | (30) | ||
| APPROVAL_TYPE | VARCHAR2 | (80) | ||
| LOCKED_FLAG | VARCHAR2 | (240) | ||
| CHANGE_DOC_STATUS | VARCHAR2 | (80) | ||
| IMPACT_BUDGET_TYPE_CODE | VARCHAR2 | (30) | ||
| CHANGE_APPROVER | VARCHAR2 | (50) | ||
| ORIGINAL_CI_ID | NUMBER | (15) | ||
| VERSION_NUMBER | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_STATUS_CODE
, PROJECT_START_DATE
, CI_ID
, CI_NUMBER
, TYPE_ID
, SUBJECT
, DESCRIPTION
, STATUS_CODE
, STATUS_DESCRIPTION
, SYSTEM_STATUS_CODE
, OWNER_ID
, OWNER_NAME
, OBJECT_TYPE
, OBJECT_ID
, OBJECT_NAME
, DATE_REQUIRED
, RESOLUTION_CODE_ID
, RESOLUTION_DESCRIPTION
, RESOLUTION_COMMENT
, STATUS_OVERVIEW
, CLASSIFICATION_CODE_ID
, CLASSIFICATION_DESCRIPTION
, REASON_CODE_ID
, REASON_DESCRIPTION
, PRIORITY_CODE
, PRIORITY_DESCRIPTION
, PRICE
, PRICE_CURRENCY_CODE
, PRICE_CURRENCY_DESCRIPTION
, SOURCE_TYPE_CODE
, SOURCE_TYPE_DESCRIPTION
, SOURCE_COMMENT
, SOURCE_NUMBER
, SOURCE_DATE_RECEIVED
, SOURCE_ORGANIZATION
, SOURCE_PERSON_NAME
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY_ID
, CREATED_BY_NAME
, LAST_UPDATED_BY_ID
, LAST_UPDATED_BY_NAME
, CI_TYPE_CLASS_CODE
, CI_TYPE_NAME
, CI_TYPE_SHORT_NAME
, APPROVAL_REQUIRED_FLAG
, AUTO_NUMBER_FLAG
, RESOLUTION_REQUIRED_FLAG
, SOURCE_ATTRS_ENABLED_FLAG
, HIGHLIGHTED_FLAG
, CLOSED_DATE
, CLOSED_BY_ID
, CLOSED_BY_NAME
, RECORD_VERSION_NUMBER
, OPEN_ACTION_NUM
, EFFORT_LEVEL_CODE
, EFFORT_LEVEL_MEANING
, LAST_MODIFICATION_DATE
, LAST_MODIFIED_BY_ID
, LAST_MODIFIED_BY_NAME
, PROGRESS_STATUS_CODE
, PROGRESS_STATUS_NAME
, STATUS_ICON_IND
, STATUS_ICON_ACTIVE_IND
, PROGRESS_AS_OF_DATE
, CLOSE_ALLOWED
, DELETE_ALLOWED
, SUBMIT_ALLOWED
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ROW_ID
, PCO_NUMBER
, VERSION_COMMENTS
, PCO_STATUS_CODE
, PCO_STATUS
, APPROVAL_TYPE_CODE
, APPROVAL_TYPE
, LOCKED_FLAG
, CHANGE_DOC_STATUS
, IMPACT_BUDGET_TYPE_CODE
, CHANGE_APPROVER
, ORIGINAL_CI_ID
, VERSION_NUMBER
FROM APPS.PA_CI_BASIC_CTL_V;
APPS
FND_CURRENCIES_TL
HZ_PARTIES
PA_CI_TYPES_VL
PA_CLASS_CODES
PA_CONTROL_ITEMS
PA_CONTROL_ITEMS_UTILS
- show dependent code
PA_LOOKUPS
PA_PROJECTS_ALL
PA_PROJECT_STATUSES
APPS.PA_CI_BASIC_CTL_V is not referenced by any database object
|
|
|
|