[Home] [Help] [Dependency Information]
Object Name: | ENG_CHANGE_ROUTE_PEOPLE_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.ENG_CHANGE_ROUTE_PEOPLE_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
ROUTE_PEOPLE_ID | NUMBER | Yes | Route people identifier | |
STEP_ID | NUMBER | Yes | Route step identifier | |
ASSIGNEE_ID | NUMBER | Yes | Assignee id | |
ASSIGNEE_TYPE_CODE | VARCHAR2 | (30) | Yes | Assignee type code |
ADHOC_PEOPLE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the assignee was added to the workflow as an adhoc |
RESPONSE_DESCRIPTION | VARCHAR2 | (4000) | Response description | |
WF_NOTIFICATION_ID | NUMBER | Workflow notification id | ||
RESPONSE_CODE | VARCHAR2 | (30) | Response code | |
RESPONSE_DATE | DATE | Response date | ||
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
REQUEST_ID | NUMBER | Concurrent WHO column | ||
PROGRAM_ID | NUMBER | Concurrent WHO column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent WHO column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent WHO column | ||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | ORIGINAL_SYSTEM_REFERENCE | |
ORIGINAL_ASSIGNEE_ID | NUMBER | ORIGINAL_ASSIGNEE_ID | ||
ORIGINAL_ASSIGNEE_TYPE_CODE | VARCHAR2 | (30) | ORIGINAL_ASSIGNEE_TYPE_CODE | |
RESPONSE_CONDITION_CODE | VARCHAR2 | (30) | RESPONSE_CONDITION_CODE | |
PARENT_ROUTE_PEOPLE_ID | NUMBER | Parent Route People Id |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ROUTE_PEOPLE_ID
, STEP_ID
, ASSIGNEE_ID
, ASSIGNEE_TYPE_CODE
, ADHOC_PEOPLE_FLAG
, RESPONSE_DESCRIPTION
, WF_NOTIFICATION_ID
, RESPONSE_CODE
, RESPONSE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_ASSIGNEE_ID
, ORIGINAL_ASSIGNEE_TYPE_CODE
, RESPONSE_CONDITION_CODE
, PARENT_ROUTE_PEOPLE_ID
FROM APPS.ENG_CHANGE_ROUTE_PEOPLE_VL;
|
|
|