eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GHR_PA_ROUTING_HISTORY_V

Object Details

Object Name:	GHR_PA_ROUTING_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_PA_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

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
PA_ROUTING_HISTORY_ID	NUMBER	(15)	Yes	Personnel Action Routing History ID
PA_REQUEST_ID	NUMBER	(15)	Yes	Personnel Action Request ID
ATTACHMENT_MODIFIED_FLAG	VARCHAR2	(1)	Yes	Attachment Modified Flag
INITIATOR_FLAG	VARCHAR2	(1)	Yes	Initiator Flag
APPROVER_FLAG	VARCHAR2	(1)	Yes	Approver Flag
REVIEWER_FLAG	VARCHAR2	(1)	Yes	Reviewer Flag
REQUESTER_FLAG	VARCHAR2	(1)	Yes	Requester Flag
AUTHORIZER_FLAG	VARCHAR2	(1)	Yes	Authorizer Flag
PERSONNELIST_FLAG	VARCHAR2	(1)	Yes	Personnelist Flag
APPROVED_FLAG	VARCHAR2	(1)	Yes	Approved Flag
APPROVAL_STATUS	VARCHAR2	(30)		Approval Status
USER_NAME	VARCHAR2	(100)		WF User Name of the user who acted on the PA request
USER_NAME_EMPLOYEE_ID	NUMBER	(10)		Person ID of the User
USER_NAME_EMP_FIRST_NAME	VARCHAR2	(150)		WF User First Name
USER_NAME_EMP_LAST_NAME	VARCHAR2	(150)		WF User Last Name
USER_NAME_EMP_MIDDLE_NAMES	VARCHAR2	(60)		WF User Middle Name
USER_NAME_EMP_FULL_NAME	VARCHAR2	(362)		WF User Full Name
NOTEPAD	VARCHAR2	(2000)		Notepad
ACTION_TAKEN	VARCHAR2	(30)		Action Taken
GROUPBOX_ID	NUMBER	(15)		Group Box ID
GROUPBOX_NAME	VARCHAR2	(30)		Group Box Name
ROUTING_LIST_ID	NUMBER	(15)		Routing List ID
ROUTING_LIST_NAME	VARCHAR2	(100)		Routing List Name
ROUTING_SEQ_NUMBER	NUMBER	(15)		Routing Sequnce Number
NOA_FAMILY_CODE	VARCHAR2	(30)		NOA Family Code
FAMILY_NAME	VARCHAR2	(100)		Family Name
NATURE_OF_ACTION_ID	NUMBER	(15)		Nature of Action ID
NOA_CODE	VARCHAR2	(4)		Nature of Action Code
NOA_DESCRIPTION	VARCHAR2	(240)		Nature of action Description
SECOND_NATURE_OF_ACTION_ID	NUMBER	(15)		Second Nature of Action ID
SECOND_NOA_CODE	VARCHAR2	(4)		Second Nature of Action Code
SECOND_NOA_DESCRIPTION	VARCHAR2	(240)		Second Nature of action Description
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
DATE_NOTIFICATION_SENT	DATE			Date Notification Sent
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Columns
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns

Query Text

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


SELECT ROW_ID
,      PA_ROUTING_HISTORY_ID
,      PA_REQUEST_ID
,      ATTACHMENT_MODIFIED_FLAG
,      INITIATOR_FLAG
,      APPROVER_FLAG
,      REVIEWER_FLAG
,      REQUESTER_FLAG
,      AUTHORIZER_FLAG
,      PERSONNELIST_FLAG
,      APPROVED_FLAG
,      APPROVAL_STATUS
,      USER_NAME
,      USER_NAME_EMPLOYEE_ID
,      USER_NAME_EMP_FIRST_NAME
,      USER_NAME_EMP_LAST_NAME
,      USER_NAME_EMP_MIDDLE_NAMES
,      USER_NAME_EMP_FULL_NAME
,      NOTEPAD
,      ACTION_TAKEN
,      GROUPBOX_ID
,      GROUPBOX_NAME
,      ROUTING_LIST_ID
,      ROUTING_LIST_NAME
,      ROUTING_SEQ_NUMBER
,      NOA_FAMILY_CODE
,      FAMILY_NAME
,      NATURE_OF_ACTION_ID
,      NOA_CODE
,      NOA_DESCRIPTION
,      SECOND_NATURE_OF_ACTION_ID
,      SECOND_NOA_CODE
,      SECOND_NOA_DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      DATE_NOTIFICATION_SENT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.GHR_PA_ROUTING_HISTORY_V;

Dependencies

[top of page]

APPS.GHR_PA_ROUTING_HISTORY_V references the following:

APPS: GHR_FAMILIES; GHR_GROUPBOXES; GHR_NATURE_OF_ACTIONS; GHR_PA_ROUTING_HISTORY; GHR_ROUTING_LISTS

APPS.GHR_PA_ROUTING_HISTORY_V is referenced by following:

PUBLIC: GHR_PA_ROUTING_HISTORY_V