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

VIEW: APPS.GHR_MT_POSITION_DEFINITIONS_V

Object Details
Object Name: GHR_MT_POSITION_DEFINITIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_MT_POSITION_DEFINITIONS_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 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)
MT 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_DEFINITION_ID VARCHAR2 (255)
Position Definition Id
ID_FLEX_NUM VARCHAR2 (255)
ID Flex Number
SUMMARY_FLAG VARCHAR2 (255)
Summary Flag
ENABLED_FLAG VARCHAR2 (255)
Enabled Flag
START_DATE_ACTIVE VARCHAR2 (255)
Start Date Active
END_DATE_ACTIVE VARCHAR2 (255)
End Date Active
SEGMENT1 VARCHAR2 (255)
Key Flexfield
SEGMENT2 VARCHAR2 (255)
Key Flexfield
SEGMENT3 VARCHAR2 (255)
Key Flexfield
SEGMENT4 VARCHAR2 (255)
Key Flexfield
SEGMENT5 VARCHAR2 (255)
Key Flexfield
SEGMENT6 VARCHAR2 (255)
Key Flexfield
SEGMENT7 VARCHAR2 (255)
Key Flexfield
SEGMENT8 VARCHAR2 (255)
Key Flexfield
SEGMENT9 VARCHAR2 (255)
Key Flexfield
SEGMENT10 VARCHAR2 (255)
Key Flexfield
SEGMENT11 VARCHAR2 (255)
Key Flexfield
SEGMENT12 VARCHAR2 (255)
Key Flexfield
SEGMENT13 VARCHAR2 (255)
Key Flexfield
SEGMENT14 VARCHAR2 (255)
Key Flexfield
SEGMENT15 VARCHAR2 (255)
Key Flexfield
SEGMENT16 VARCHAR2 (255)
Key Flexfield
SEGMENT17 VARCHAR2 (255)
Key Flexfield
SEGMENT18 VARCHAR2 (255)
Key Flexfield
SEGMENT19 VARCHAR2 (255)
Key Flexfield
SEGMENT20 VARCHAR2 (255)
Key Flexfield
SEGMENT21 VARCHAR2 (255)
Key Flexfield
SEGMENT22 VARCHAR2 (255)
Key Flexfield
SEGMENT23 VARCHAR2 (255)
Key Flexfield
SEGMENT24 VARCHAR2 (255)
Key Flexfield
SEGMENT25 VARCHAR2 (255)
Key Flexfield
SEGMENT26 VARCHAR2 (255)
Key Flexfield
SEGMENT27 VARCHAR2 (255)
Key Flexfield
SEGMENT28 VARCHAR2 (255)
Key Flexfield
SEGMENT29 VARCHAR2 (255)
Key Flexfield
SEGMENT30 VARCHAR2 (255)
Key Flexfield
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
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_DEFINITION_ID
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.GHR_MT_POSITION_DEFINITIONS_V;

Dependencies

[top of page]

APPS.GHR_MT_POSITION_DEFINITIONS_V references the following:

SchemaAPPS
SynonymGHR_INTERFACE
APPS.GHR_MT_POSITION_DEFINITIONS_V is referenced by following:

SchemaAPPS
Package BodyGHR_MTO_INT - show dependent code
SchemaPUBLIC
SynonymGHR_MT_POSITION_DEFINITIONS_V