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

VIEW: APPS.GHR_MT_ADDRESSES_V

Object Details
Object Name: GHR_MT_ADDRESSES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_MT_ADDRESSES_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)
Mass Action Criteria 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
MT_CONTACT_NAME VARCHAR2 (255)
Contact Name
MT_CONTACT_TYPE VARCHAR2 (255)
Contact Type
ADDRESS_ID VARCHAR2 (255)
Address ID
BUSINESS_GROUP_ID VARCHAR2 (255)
Business Group ID
PERSON_ID VARCHAR2 (255)
Person ID
DATE_FROM VARCHAR2 (255)
Date From
PRIMARY_FLAG VARCHAR2 (255)
Primary Flag
STYLE VARCHAR2 (255)
Style
ADDRESS_LINE1 VARCHAR2 (255)
Address Line1
ADDRESS_LINE2 VARCHAR2 (255)
Address Line2
ADDRESS_LINE3 VARCHAR2 (255)
Address Line3
ADDRESS_TYPE VARCHAR2 (255)
Address Type
COMMENTS VARCHAR2 (255)
Comments
COUNTRY VARCHAR2 (255)
Country
DATE_TO VARCHAR2 (255)
Date To
POSTAL_CODE VARCHAR2 (255)
Postal Code
REGION_1 VARCHAR2 (255)
Region1
REGION_2 VARCHAR2 (255)
Region2
REGION_3 VARCHAR2 (255)
Region3
TELEPHONE_NUMBER_1 VARCHAR2 (255)
Telephone number1
TELEPHONE_NUMBER_2 VARCHAR2 (255)
Telephone number2
TELEPHONE_NUMBER_3 VARCHAR2 (255)
Telephone number3
TOWN_OR_CITY VARCHAR2 (255)
Town or City
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
ADDR_ATTRIBUTE_CATEGORY VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE1 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE2 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE3 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE4 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE5 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE6 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE7 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE8 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE9 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE10 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE11 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE12 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE13 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE14 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE15 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE16 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE17 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE18 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE19 VARCHAR2 (255)
Descriptive Flex Field
ADDR_ATTRIBUTE20 VARCHAR2 (255)
Descriptive Flex Field
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
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
,      MT_CONTACT_NAME
,      MT_CONTACT_TYPE
,      ADDRESS_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      DATE_FROM
,      PRIMARY_FLAG
,      STYLE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_TYPE
,      COMMENTS
,      COUNTRY
,      DATE_TO
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      TOWN_OR_CITY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ADDR_ATTRIBUTE_CATEGORY
,      ADDR_ATTRIBUTE1
,      ADDR_ATTRIBUTE2
,      ADDR_ATTRIBUTE3
,      ADDR_ATTRIBUTE4
,      ADDR_ATTRIBUTE5
,      ADDR_ATTRIBUTE6
,      ADDR_ATTRIBUTE7
,      ADDR_ATTRIBUTE8
,      ADDR_ATTRIBUTE9
,      ADDR_ATTRIBUTE10
,      ADDR_ATTRIBUTE11
,      ADDR_ATTRIBUTE12
,      ADDR_ATTRIBUTE13
,      ADDR_ATTRIBUTE14
,      ADDR_ATTRIBUTE15
,      ADDR_ATTRIBUTE16
,      ADDR_ATTRIBUTE17
,      ADDR_ATTRIBUTE18
,      ADDR_ATTRIBUTE19
,      ADDR_ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM APPS.GHR_MT_ADDRESSES_V;

Dependencies

[top of page]

APPS.GHR_MT_ADDRESSES_V references the following:

SchemaAPPS
SynonymGHR_INTERFACE
APPS.GHR_MT_ADDRESSES_V is referenced by following:

SchemaAPPS
Package BodyGHR_MTI_INT - show dependent code
Package BodyGHR_MTO_INT - show dependent code
SchemaPUBLIC
SynonymGHR_MT_ADDRESSES_V