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_REQUESTS_V1

Object Details

Object Name:	GHR_PA_REQUESTS_V1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_PA_REQUESTS_V1
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
EFFECTIVE_DATE	DATE			Effective Date
NOA_CODE	VARCHAR2	(30)		Nature Of action Code
ROW_NUM	NUMBER			Record ROW Number
HIERARCHY_LEVEL	NUMBER			Hierarchy Level
PA_REQUEST_ID	NUMBER	(15)		Personnel Action Request ID
ROUTING_GROUP_ID	NUMBER	(15)		Routing Group ID
PA_NOTIFICATION_ID	NUMBER	(22)		Personnel Action Notification ID
APPROVAL_DATE	DATE			Approval Date
NOA_FAMILY_CODE	VARCHAR2	(30)		Nature of Action Family Code
NOA_ID	NUMBER			Nature OF Action ID
NOA_DESC	VARCHAR2	(240)		Nature OF Action ID Description
PERSON_ID	NUMBER	(10)		Person ID
REQUEST_NUMBER	VARCHAR2	(25)		Request Number
APPROVING_OFFICIAL_WORK_TITLE	VARCHAR2	(60)		Approving Official Work Title
FROM_ORGANIZATION_NAME	VARCHAR2	(40)		From Organization Name
TO_ORGANIZATION_NAME	VARCHAR2	(40)		To Organization Name
WHICH_NOA	NUMBER			Which Nature Of Action
ROW_ID	ROWID	(10)		Row ID
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number
ACTION_TYPE	VARCHAR2	(9)		Action Type
PERSONNEL_OFFICE_ID	VARCHAR2	(4)		Personnel Office ID
ALTERED_PA_REQUEST_ID	NUMBER	(15)		Original Personnel Action Request ID
FIRST_NOA_CANCEL_OR_CORRECT	VARCHAR2	(10)		First NOA Cancel / Correct
STATUS	VARCHAR2	(30)		Status
FIRST_NOA_PA_REQUEST_ID	NUMBER	(15)		First NOA Personnel Action Request ID
INDENT	VARCHAR2	(2)		Indent
CREATED_BY	NUMBER	(15)		Who Column
CREATION_DATE	DATE			Who Column
LAST_UPDATED_BY	NUMBER	(15)		Who Column
LAST_UPDATE_DATE	DATE			Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Who Column
ROUTING_GROUP_NAME	VARCHAR2	(30)	Yes	Routing Group Name
NOA_FAMILY_NAME	VARCHAR2	(100)	Yes	NOA Family Code
ORDER_OF_PROCESSING	NUMBER	(9)		Order of Processing

Query Text

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


SELECT EFFECTIVE_DATE
,      NOA_CODE
,      ROW_NUM
,      HIERARCHY_LEVEL
,      PA_REQUEST_ID
,      ROUTING_GROUP_ID
,      PA_NOTIFICATION_ID
,      APPROVAL_DATE
,      NOA_FAMILY_CODE
,      NOA_ID
,      NOA_DESC
,      PERSON_ID
,      REQUEST_NUMBER
,      APPROVING_OFFICIAL_WORK_TITLE
,      FROM_ORGANIZATION_NAME
,      TO_ORGANIZATION_NAME
,      WHICH_NOA
,      ROW_ID
,      OBJECT_VERSION_NUMBER
,      ACTION_TYPE
,      PERSONNEL_OFFICE_ID
,      ALTERED_PA_REQUEST_ID
,      FIRST_NOA_CANCEL_OR_CORRECT
,      STATUS
,      FIRST_NOA_PA_REQUEST_ID
,      INDENT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ROUTING_GROUP_NAME
,      NOA_FAMILY_NAME
,      ORDER_OF_PROCESSING
FROM APPS.GHR_PA_REQUESTS_V1;

Dependencies

[top of page]

APPS.GHR_PA_REQUESTS_V1 references the following:

APPS: GHR_FAMILIES; GHR_NATURE_OF_ACTIONS; GHR_PA_REQUESTS; GHR_ROUTING_GROUPS

APPS.GHR_PA_REQUESTS_V1 is not referenced by any database object