[Home] [Help] [Dependency Information]
Object Name: | PQH_ROUTING_HISTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PQH.PQH_ROUTING_HISTORY_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTING_HISTORY_ID | NUMBER | (15) | Yes | |
APPROVAL_CD | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (2000) | ||
PERSON_NAME_BY | VARCHAR2 | (4000) | ||
ROLE_NAME_BY | VARCHAR2 | (30) | ||
POSITION_NAME_BY | VARCHAR2 | (4000) | ||
USER_NAME_BY | VARCHAR2 | (100) | ||
PERSON_NAME_TO | VARCHAR2 | (4000) | ||
ROLE_NAME_TO | VARCHAR2 | (30) | ||
POSITION_NAME_TO | VARCHAR2 | (4000) | ||
USER_NAME_TO | VARCHAR2 | (100) | ||
NOTIFICATION_DATE | DATE | Yes | ||
POS_STRUCTURE_VERSION_ID | NUMBER | |||
ROUTING_CATEGORY_ID | NUMBER | (15) | ||
TRANSACTION_CATEGORY_ID | NUMBER | (15) | Yes | |
TRANSACTION_ID | NUMBER | (15) | Yes | |
USER_ACTION_CD | VARCHAR2 | (10) | Yes | |
FORWARDED_BY_USER_ID | NUMBER | (15) | ||
FORWARDED_BY_ASSIGNMENT_ID | NUMBER | (15) | ||
FORWARDED_BY_POSITION_ID | NUMBER | (15) | ||
FORWARDED_BY_MEMBER_ID | NUMBER | (15) | ||
FORWARDED_TO_USER_ID | NUMBER | (15) | ||
FORWARDED_TO_ASSIGNMENT_ID | NUMBER | (15) | ||
FORWARDED_TO_POSITION_ID | NUMBER | (15) | ||
FORWARDED_TO_MEMBER_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROUTING_HISTORY_ID
, APPROVAL_CD
, COMMENTS
, PERSON_NAME_BY
, ROLE_NAME_BY
, POSITION_NAME_BY
, USER_NAME_BY
, PERSON_NAME_TO
, ROLE_NAME_TO
, POSITION_NAME_TO
, USER_NAME_TO
, NOTIFICATION_DATE
, POS_STRUCTURE_VERSION_ID
, ROUTING_CATEGORY_ID
, TRANSACTION_CATEGORY_ID
, TRANSACTION_ID
, USER_ACTION_CD
, FORWARDED_BY_USER_ID
, FORWARDED_BY_ASSIGNMENT_ID
, FORWARDED_BY_POSITION_ID
, FORWARDED_BY_MEMBER_ID
, FORWARDED_TO_USER_ID
, FORWARDED_TO_ASSIGNMENT_ID
, FORWARDED_TO_POSITION_ID
, FORWARDED_TO_MEMBER_ID
FROM APPS.PQH_ROUTING_HISTORY_V;
|
|
|