[Home] [Help] [Dependency Information]

VIEW: APPS.PQH_ROUTING_HISTORY_V

Object Details

Object Name:	PQH_ROUTING_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQH.PQH_ROUTING_HISTORY_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

APPS

FND_USER

HR_GENERAL - show dependent code

PQH_ROLES

PQH_ROUTING_HISTORY

PQH_ROUTING_LIST_MEMBERS

PQH_WF - show dependent code

APPS

PQH_BUDGET - show dependent code

PUBLIC

PQH_ROUTING_HISTORY_V