[Home] [Help] [Dependency Information]

VIEW: APPS.GHR_MT_INTERFACE_V

Object Details

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

Query Text

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

SELECT MT_NAME
,      MT_PROCESS_DATE
,      MT_EFFECTIVE_DATE
,      MT_SOURCE
,      MT_STATUS
,      MT_PERSON_ID
,      MT_INTER_BG_TRANSFER
,      DATE_OF_BIRTH
,      EFFECTIVE_END_DATE
,      EFFECTIVE_START_DATE
,      FIRST_NAME
,      FULL_NAME
,      LAST_NAME
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONAL_IDENTIFIER
,      EMPLOYEE_NUMBER
,      NATIONALITY
,      REHIRE_REASON
,      SEX
,      START_DATE
,      TITLE
,      WORK_TELEPHONE
,      CITIZENSHIP
,      VETERANS_PREFERENCE
,      VETERANS_PREFERENCE_FOR_RIF
,      VETERANS_STATUS
,      CITIZENSHIP_DESC
,      VETERANS_PREFERENCE_DESC
,      VETERANS_PREFERENCE_RIF_DESC
,      VETERANS_STATUS_DESC
,      APPOINTMENT_TYPE
,      FERS_COVERAGE
,      FERS_COVERAGE_DESC
,      TYPE_OF_EMPLOYMENT
,      RACE_OR_NATIONAL_ORIGIN
,      AGENCY_CODE_TRANSFER_FROM
,      ORIG_APPOINTMENT_AUTH_CODE_1
,      ORIG_APPOINTMENT_AUTH_CODE_2
,      HANDICAP_CODE
,      APPOINTMENT_TYPE_DESC
,      TYPE_OF_EMPLOYMENT_DESC
,      RACE_OR_NATIONAL_ORIGIN_DESC
,      AGENCY_CODE_TRANSFER_FROM_DESC
,      ORIG_APPT_AUTH_CODE_1_DESC
,      ORIG_APPT_AUTH_CODE_2_DESC
,      HANDICAP_CODE_DESC
,      SERVICE_COMP_DATE
,      PREVIOUS_RETIREMENT_COVERAGE
,      FROZEN_SERVICE
,      PREV_RETIREMENT_COVERAGE_DESC
,      CREDITABLE_MILITARY_SERVICE
,      FLSA_CATEGORY
,      BARGAINING_UNIT_STATUS
,      FUNCTIONAL_CLASS
,      POSITION_WORKING_TITLE
,      SUPERVISORY_STATUS
,      FLSA_CATEGORY_DESC
,      BARGAINING_UNIT_STATUS_DESC
,      FUNCTIONAL_CLASS_DESC
,      SUPERVISORY_STATUS_DESC
,      POSITION_OCCUPIED
,      APPROPRIATION_CODE1
,      APPROPRIATION_CODE2
,      POSITION_OCCUPIED_DESC
,      APPROPRIATION_CODE1_DESC
,      APPROPRIATION_CODE2_DESC
,      TOTAL_SALARY
,      BASIC_SALARY_RATE
,      LOCALITY_ADJUSTMENT
,      ADJUSTED_BASIC_PAY
,      OTHER_PAY
,      FEGLI
,      RETIREMENT_PLAN
,      RETENTION_ALLOWANCE
,      STAFFING_DIFFERENTIAL
,      SUPERVISORY_DIFFERENTIAL
,      WGI_DATE_DUE
,      FEGLI_DESC
,      RETIREMENT_PLAN_DESC
,      AU_OVERTIME
,      AVAILABILITY_PAY
,      AUO_PREMIUM_PAY_INDICATOR
,      AP_PREMIUM_PAY_INDICATOR
,      TO_POSITION_ID
,      FROM_GRADE_OR_LEVEL
,      FROM_PAY_PLAN
,      FROM_POSITION_TITLE
,      FROM_POSITION_SEQ_NUM
,      FROM_POSITION_DESC_NUM
,      DUTY_STATION_CODE
,      DUTY_STATION_DESC
,      FROM_STEP_OR_RATE
,      TENURE
,      ANNUITANT_INDICATOR
,      PAY_RATE_DETERMINANT
,      WORK_SCHEDULE
,      PART_TIME_HOURS
,      TENURE_DESC
,      ANNUITANT_INDICATOR_DESC
,      PAY_RATE_DETERMINANT_DESC
,      WORK_SCHEDULE_DESC
,      DATE_ARRIVED_PERSONNEL_OFFICE
,      NON_DISCLOSURE_AGMT_STATUS
,      PART_TIME_INDICATOR
,      QUALIF_STANDARDS_WAIVER
,      NON_DISCLOSURE_AGMT_STAT_DESC
,      PART_TIME_INDICATOR_DESC
,      QUALIF_STANDARDS_WAIVER_DESC
,      EDUCATIONAL_LEVEL
,      ACADEMIC_DISCIPLINE
,      YEAR_DEGREE_ATTAINED
,      EDUCATIONAL_LEVEL_DESC
,      ACADEMIC_DISCIPLINE_DESC
,      TO_RETENTION_ALLOW_PERCENTAGE
,      TO_SUPERVISORY_DIFF_PERCENTAGE
,      TO_STAFFING_DIFF_PERCENTAGE
,      TO_BASIC_SALARY_RATE
,      TO_ADJUSTED_BASIC_PAY
,      TO_TOTAL_SALARY
,      ASSIGNMENT_NTE_START_DATE
,      ASSIGNMENT_NTE
FROM APPS.GHR_MT_INTERFACE_V;

Dependencies

[top of page]

APPS

FND_DATE - show dependent code

GHR_MT_ANALYSIS_CRITERIA_V

GHR_MT_ASSIGNMENTS_F_V

GHR_MT_ASSIGNMENT_EI_V

GHR_MT_ELEMENT_ENTRIES_V

GHR_MT_MISC_V

GHR_MT_PEOPLE_EI_V

GHR_MT_PEOPLE_F_V

GHR_MT_POSITIONS_V

GHR_MT_POSITION_EI_V

APPS

GHR_MTI_APP - show dependent code