DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GHR_MT_ASSIGNMENTS_F_V

Object Details
Object Name: GHR_MT_ASSIGNMENTS_F_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_MT_ASSIGNMENTS_F_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
GHR_INTERFACE_ID NUMBER (15) Yes GHR Interface ID
MT_PROCESS_DATE DATE
Yes MT Process Date
MT_SOURCE VARCHAR2 (30)
MT Source
MT_EFFECTIVE_DATE DATE

MT Effective Date
MT_NAME VARCHAR2 (255)
MT Name
MT_STATUS VARCHAR2 (255)
MT Status
MT_PERSON_ID VARCHAR2 (255)
MT Person ID
MT_TABLE_NAME VARCHAR2 (255)
MT Table Name
MT_INFORMATION_TYPE VARCHAR2 (255)
MT Information Type
MT_INTER_BG_TRANSFER VARCHAR2 (255)
MT Inter BG Transfer
ASSIGNMENT_ID VARCHAR2 (255)
Assignment ID
EFFECTIVE_START_DATE VARCHAR2 (255)
Effective Start Date
EFFECTIVE_END_DATE VARCHAR2 (255)
Effective End Date
BUSINESS_GROUP_ID VARCHAR2 (255)
Bussing Group of Record
RECRUITER_ID VARCHAR2 (255)
Recruiter ID
GRADE_ID VARCHAR2 (255)
Grade ID
POSITION_ID VARCHAR2 (255)
Position ID
JOB_ID VARCHAR2 (255)
Job ID
ASSIGNMENT_STATUS_TYPE_ID VARCHAR2 (255)
Assignment Status Type ID
PAYROLL_ID VARCHAR2 (255)
Payroll ID
LOCATION_ID VARCHAR2 (255)
Location ID
PERSON_REFERRED_BY_ID VARCHAR2 (255)
Person Referred By ID
SUPERVISOR_ID VARCHAR2 (255)
Supervisor ID
SPECIAL_CEILING_STEP_ID VARCHAR2 (255)
Special Ceiling Step ID
PERSON_ID VARCHAR2 (255)
Person ID
RECRUITMENT_ACTIVITY_ID VARCHAR2 (255)
Recruitment Activity ID
SOURCE_ORGANIZATION_ID VARCHAR2 (255)
Source Organization ID
ORGANIZATION_ID VARCHAR2 (255)
Organization ID
PEOPLE_GROUP_ID VARCHAR2 (255)
People Group ID
SOFT_CODING_KEYFLEX_ID VARCHAR2 (255)
Soft Coding Keyflex ID
VACANCY_ID VARCHAR2 (255)
Vacancy ID
PAY_BASIS_ID VARCHAR2 (255)
Pay Basis ID
ASSIGNMENT_SEQUENCE VARCHAR2 (255)
Assignment Sequence
ASSIGNMENT_TYPE VARCHAR2 (255)
Assignment Type
PRIMARY_FLAG VARCHAR2 (255)
Primary Flag
APPLICATION_ID VARCHAR2 (255)
Application ID
ASSIGNMENT_NUMBER VARCHAR2 (255)
Assignment Number
CHANGE_REASON VARCHAR2 (255)
Change Reason
COMMENT_ID VARCHAR2 (255)
Comment ID
DATE_PROBATION_END VARCHAR2 (255)
Date Probation End
DEFAULT_CODE_COMB_ID VARCHAR2 (255)
Default Code Comb ID
EMPLOYMENT_CATEGORY VARCHAR2 (255)
Employment Category
FREQUENCY VARCHAR2 (255)
Frequency
INTERNAL_ADDRESS_LINE VARCHAR2 (255)
Internal Address Line
MANAGER_FLAG VARCHAR2 (255)
Manager Flag
NORMAL_HOURS VARCHAR2 (255)
Normal Hours
PERF_REVIEW_PERIOD VARCHAR2 (255)
Performance Review Period
PERF_REVIEW_PERIOD_FREQUENCY VARCHAR2 (255)
Performance Review Period Frequency
PERIOD_OF_SERVICE_ID VARCHAR2 (255)
Period of Service ID
PROBATION_PERIOD VARCHAR2 (255)
Probation Period
PROBATION_UNIT VARCHAR2 (255)
Probation Unit
SAL_REVIEW_PERIOD VARCHAR2 (255)
Salary Review Period
SAL_REVIEW_PERIOD_FREQUENCY VARCHAR2 (255)
Salry Review Period Frequency
SET_OF_BOOKS_ID VARCHAR2 (255)
Set of Books ID
SOURCE_TYPE VARCHAR2 (255)
Source Type
TIME_NORMAL_FINISH VARCHAR2 (255)
Time Normal Finish
TIME_NORMAL_START VARCHAR2 (255)
Time Normal Start
REQUEST_ID VARCHAR2 (255)
Request ID
PROGRAM_APPLICATION_ID VARCHAR2 (255)
Program Application ID
PROGRAM_ID VARCHAR2 (255)
Program ID
PROGRAM_UPDATE_DATE VARCHAR2 (255)
Program Update Date
ASS_ATTRIBUTE_CATEGORY VARCHAR2 (255)
Assignment Attribute Category for Descriptive Flexfield
ASS_ATTRIBUTE1 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE2 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE3 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE4 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE5 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE6 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE7 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE8 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE9 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE10 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE11 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE12 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE13 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE14 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE15 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE16 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE17 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE18 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE19 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE20 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE21 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE22 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE23 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE24 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE25 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE26 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE27 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE28 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE29 VARCHAR2 (255)
Descriptive Flexfield
ASS_ATTRIBUTE30 VARCHAR2 (255)
Descriptive Flexfield
LAST_UPDATE_DATE VARCHAR2 (255)
Who Column
LAST_UPDATED_BY VARCHAR2 (255)
Who Column
LAST_UPDATE_LOGIN VARCHAR2 (255)
Who Column
CREATED_BY VARCHAR2 (255)
Who Column
CREATION_DATE VARCHAR2 (255)
Who Column
TITLE VARCHAR2 (255)
Title
OBJECT_VERSION_NUMBER VARCHAR2 (255)
Object Version Number
Query Text

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
,      ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      RECRUITER_ID
,      GRADE_ID
,      POSITION_ID
,      JOB_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      PAYROLL_ID
,      LOCATION_ID
,      PERSON_REFERRED_BY_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      PERSON_ID
,      RECRUITMENT_ACTIVITY_ID
,      SOURCE_ORGANIZATION_ID
,      ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      VACANCY_ID
,      PAY_BASIS_ID
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_TYPE
,      PRIMARY_FLAG
,      APPLICATION_ID
,      ASSIGNMENT_NUMBER
,      CHANGE_REASON
,      COMMENT_ID
,      DATE_PROBATION_END
,      DEFAULT_CODE_COMB_ID
,      EMPLOYMENT_CATEGORY
,      FREQUENCY
,      INTERNAL_ADDRESS_LINE
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PERIOD_OF_SERVICE_ID
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      SET_OF_BOOKS_ID
,      SOURCE_TYPE
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASS_ATTRIBUTE_CATEGORY
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TITLE
,      OBJECT_VERSION_NUMBER
FROM APPS.GHR_MT_ASSIGNMENTS_F_V;

Dependencies

[top of page]

APPS.GHR_MT_ASSIGNMENTS_F_V references the following:

SchemaAPPS
SynonymGHR_INTERFACE
APPS.GHR_MT_ASSIGNMENTS_F_V is referenced by following:

SchemaAPPS
Package BodyGHR_MTO_INT - show dependent code
ViewGHR_MT_INTERFACE_V