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: ViewGHR.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:

SchemaAPPS
SynonymGHR_FAMILIES
SynonymGHR_GROUPBOXES
SynonymGHR_NATURE_OF_ACTIONS
SynonymGHR_PA_ROUTING_HISTORY
SynonymGHR_ROUTING_LISTS

APPS.GHR_PA_ROUTING_HISTORY_V is not referenced by any database object