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

TABLE: GR.GR_ORGANIZATION_CONTACTS

Object Details
Object Name: GR_ORGANIZATION_CONTACTS
Object Type: TABLE
Owner: GR
FND Design Data: TableGR.GR_ORGANIZATION_CONTACTS
Subobject Name:
Status: VALID


Contains the contact information for the organization


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_ORGANIZAITON_CONTACTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGN_CODE
Columns
Name Datatype Length Mandatory Comments
ORGN_CODE VARCHAR2 (4) Yes The Organization Code that produces the substance.
DAYTIME_CONTACT_NAME VARCHAR2 (100)
Contact Name available during the day.
DAYTIME_TELEPHONE VARCHAR2 (25)
Contact daytime telephone number.
DAYTIME_EXTENSION VARCHAR2 (20)
Contact daytime telephone number extension.
DAYTIME_AREA_CODE VARCHAR2 (10)
Contact daytime area code.
EVENING_CONTACT_NAME VARCHAR2 (100)
Contact Name available after hours.
EVENING_TELEPHONE VARCHAR2 (20)
Contact evening telephone number.
EVENING_EXTENSION VARCHAR2 (20)
Contact evening telephone number extension.
EVENING_AREA_CODE VARCHAR2 (10)
Contact evening area code.
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
DAYTIME_EMAIL VARCHAR2 (80)
normal hours e-mail address
EVENING_EMAIL VARCHAR2 (80)
outside hours e-mail address
EVENING_FAX_NO VARCHAR2 (80)
outside hours fax number
DAYTIME_FAX_NO VARCHAR2 (80)
normal hours fax number
Query Text

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


SELECT ORGN_CODE
,      DAYTIME_CONTACT_NAME
,      DAYTIME_TELEPHONE
,      DAYTIME_EXTENSION
,      DAYTIME_AREA_CODE
,      EVENING_CONTACT_NAME
,      EVENING_TELEPHONE
,      EVENING_EXTENSION
,      EVENING_AREA_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DAYTIME_EMAIL
,      EVENING_EMAIL
,      EVENING_FAX_NO
,      DAYTIME_FAX_NO
FROM GR.GR_ORGANIZATION_CONTACTS;

Dependencies

[top of page]

GR.GR_ORGANIZATION_CONTACTS does not reference any database object

GR.GR_ORGANIZATION_CONTACTS is referenced by following:

SchemaAPPS
SynonymGR_ORGANIZATION_CONTACTS