[Home] [Help] [Dependency Information]
Object Name: | GHR_MT_MISC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GHR.GHR_MT_MISC_V |
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 |
---|---|---|---|---|
GHR_INTERFACE_ID | NUMBER | (15) | Yes | GHR Interface ID |
MT_PROCESS_DATE | DATE | Yes | Process Date | |
MT_SOURCE | VARCHAR2 | (30) | Source | |
MT_EFFECTIVE_DATE | DATE | Effective Date | ||
MT_NAME | VARCHAR2 | (255) | Name | |
MT_STATUS | VARCHAR2 | (255) | Status | |
MT_PERSON_ID | VARCHAR2 | (255) | Person ID | |
MT_TABLE_NAME | VARCHAR2 | (255) | Table Name | |
MT_INFORMATION_TYPE | VARCHAR2 | (255) | Information type | |
MT_INTER_BG_TRANSFER | VARCHAR2 | (255) | Internal Business Group transfer | |
FROM_GRADE_OR_LEVEL | VARCHAR2 | (255) | Grade Or Level | |
FROM_PAY_PLAN | VARCHAR2 | (255) | Pay plan | |
FROM_POSITION_TITLE | VARCHAR2 | (255) | Position title | |
FROM_POSITION_SEQ_NUM | VARCHAR2 | (255) | Position Sequence Number | |
FROM_POSITION_DESC_NUM | VARCHAR2 | (255) | Position Description number | |
FROM_POSITION_ID | VARCHAR2 | (255) | From Position ID | |
FROM_AGENCY_CODE | VARCHAR2 | (255) | Agency Code | |
OCC_SERIES | VARCHAR2 | (255) | Occupational Series | |
TO_POSITION_ID | VARCHAR2 | (255) | To Position ID | |
DUTY_STATION_DESC | VARCHAR2 | (255) | Duty Station Descriotion | |
DUTY_STATION_CODE | VARCHAR2 | (255) | Duty Station Code | |
FROM_AGENCY_CODE_DESC | VARCHAR2 | (255) | Agency Description |
Cut, paste (and edit) the following text to query this object:
SELECT GHR_INTERFACE_ID
, MT_PROCESS_DATE
, MT_SOURCE
, MT_EFFECTIVE_DATE
, MT_NAME
, MT_STATUS
, MT_PERSON_ID
, MT_TABLE_NAME
, MT_INFORMATION_TYPE
, MT_INTER_BG_TRANSFER
, FROM_GRADE_OR_LEVEL
, FROM_PAY_PLAN
, FROM_POSITION_TITLE
, FROM_POSITION_SEQ_NUM
, FROM_POSITION_DESC_NUM
, FROM_POSITION_ID
, FROM_AGENCY_CODE
, OCC_SERIES
, TO_POSITION_ID
, DUTY_STATION_DESC
, DUTY_STATION_CODE
, FROM_AGENCY_CODE_DESC
FROM APPS.GHR_MT_MISC_V;
|
|
|