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

VIEW: APPS.GHR_MT_POSITIONS_V

Object Details
Object Name: GHR_MT_POSITIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_MT_POSITIONS_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 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)
MT Person ID
MT_TABLE_NAME VARCHAR2 (255)
Table Name
MT_INFORMATION_TYPE VARCHAR2 (255)
Information Type
MT_INTER_BG_TRANSFER VARCHAR2 (255)
Inter BG Transfer
POSITION_ID VARCHAR2 (255)
Position ID
BUSINESS_GROUP_ID VARCHAR2 (255)
Business Group of Record
JOB_ID VARCHAR2 (255)
Job ID
ORGANIZATION_ID VARCHAR2 (255)
Organization ID
SUCCESSOR_POSITION_ID VARCHAR2 (255)
Successor Position ID
RELIEF_POSITION_ID VARCHAR2 (255)
Relief Position ID
LOCATION_ID VARCHAR2 (255)
Location ID
POSITION_DEFINITION_ID VARCHAR2 (255)
Position Definition ID
DATE_EFFECTIVE VARCHAR2 (255)
Date Effective
COMMENTS VARCHAR2 (255)
Comments
DATE_END VARCHAR2 (255)
Date End
FREQUENCY VARCHAR2 (255)
Frequency
NAME VARCHAR2 (255)
Name
PROBATION_PERIOD VARCHAR2 (255)
Probation Period
PROBATION_PERIOD_UNITS VARCHAR2 (255)
Probation Period Units
REPLACEMENT_REQUIRED_FLAG VARCHAR2 (255)
Replacement Required Flag
TIME_NORMAL_FINISH VARCHAR2 (255)
Time Normal Finish
TIME_NORMAL_START VARCHAR2 (255)
Time Normal Start
WORKING_HOURS VARCHAR2 (255)
Working Hours
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
ATTRIBUTE_CATEGORY VARCHAR2 (255)
Attribute Category for Descriptive Flexfield Columns
ATTRIBUTE1 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE16 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE17 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE18 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE19 VARCHAR2 (255)
Descriptive Flexfield
ATTRIBUTE20 VARCHAR2 (255)
Descriptive Flexfield
OBJECT_VERSION_NUMBER VARCHAR2 (255)
Object Version Number
LAST_UPDATE_DATE VARCHAR2 (255)
Standard WHO Column
LAST_UPDATED_BY VARCHAR2 (255)
Standard WHO Column
LAST_UPDATE_LOGIN VARCHAR2 (255)
Standard WHO Column
CREATED_BY VARCHAR2 (255)
Standard WHO Column
CREATION_DATE VARCHAR2 (255)
Standard WHO Column
STATUS VARCHAR2 (255)
Status
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
,      POSITION_ID
,      BUSINESS_GROUP_ID
,      JOB_ID
,      ORGANIZATION_ID
,      SUCCESSOR_POSITION_ID
,      RELIEF_POSITION_ID
,      LOCATION_ID
,      POSITION_DEFINITION_ID
,      DATE_EFFECTIVE
,      COMMENTS
,      DATE_END
,      FREQUENCY
,      NAME
,      PROBATION_PERIOD
,      PROBATION_PERIOD_UNITS
,      REPLACEMENT_REQUIRED_FLAG
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      WORKING_HOURS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      STATUS
FROM APPS.GHR_MT_POSITIONS_V;

Dependencies

[top of page]

APPS.GHR_MT_POSITIONS_V references the following:

SchemaAPPS
SynonymGHR_INTERFACE
APPS.GHR_MT_POSITIONS_V is referenced by following:

SchemaAPPS
Package BodyGHR_MTO_INT - show dependent code
ViewGHR_MT_INTERFACE_V