[Home] [Help] [Dependency Information]
Object Name: | GHR_PA_REQUESTS_V1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GHR.GHR_PA_REQUESTS_V1 |
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 |
---|---|---|---|---|
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 |
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;
APPS.GHR_PA_REQUESTS_V1 is not referenced by any database object
|
|
|