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

VIEW: APPS.PA_CI_COMMENTS_V

Object Details
Object Name: PA_CI_COMMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_CI_COMMENTS_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
CI_COMMENT_ID NUMBER (15)
CI_ID NUMBER (15)
CI_ACTION_ID NUMBER (15)
UPDATE_DATE DATE

COMMENT_CREATED_BY_NAME VARCHAR2 (360)
CREATED_BY NUMBER (15)
REQUESTOR_NAME VARCHAR2 (360)
COMMENT_TEXT VARCHAR2 (4000)
MESSAGE_TYPE_CODE VARCHAR2 (30)
ACTION_TYPE_CODE VARCHAR2 (30)
ACTION_TYPE VARCHAR2 (80)
STATUS_CODE VARCHAR2 (30)
CI_ACTION_NUMBER NUMBER

REASSIGN_CI_ACTION_ID NUMBER

REASSIGNEE_NAME VARCHAR2 (360)
ORDER_BY_DATE DATE

PROJECT_ID NUMBER (15)
CREATED_BY_USER_ID NUMBER (15)
SOURCE_CI_ACTION_ID NUMBER

ASSIGNEE_NAME VARCHAR2 (360)
CHILD_EXISTS VARCHAR2 (4000)
Query Text

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


SELECT CI_COMMENT_ID
,      CI_ID
,      CI_ACTION_ID
,      UPDATE_DATE
,      COMMENT_CREATED_BY_NAME
,      CREATED_BY
,      REQUESTOR_NAME
,      COMMENT_TEXT
,      MESSAGE_TYPE_CODE
,      ACTION_TYPE_CODE
,      ACTION_TYPE
,      STATUS_CODE
,      CI_ACTION_NUMBER
,      REASSIGN_CI_ACTION_ID
,      REASSIGNEE_NAME
,      ORDER_BY_DATE
,      PROJECT_ID
,      CREATED_BY_USER_ID
,      SOURCE_CI_ACTION_ID
,      ASSIGNEE_NAME
,      CHILD_EXISTS
FROM APPS.PA_CI_COMMENTS_V;

Dependencies

[top of page]

APPS.PA_CI_COMMENTS_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymPA_CI_ACTIONS
PL/SQL PackagePA_CI_ACTIONS_UTIL - show dependent code
SynonymPA_CI_COMMENTS
SynonymPA_CONTROL_ITEMS
ViewPA_LOOKUPS
PL/SQL PackagePA_UTILS - show dependent code

APPS.PA_CI_COMMENTS_V is not referenced by any database object