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

VIEW: APPS.GML_EC_CONTACT_V

Object Details
Object Name: GML_EC_CONTACT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGML.GML_EC_CONTACT_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Contains customer data to support the OPM Outbound Advanced Ship Notice (856/DESADV) and the OPM Outbound Purchase Order Acknowledgement (855/ORDRSP) EDI transactions.
This view is used to populate the GML_GPOAO_ORDERS_V, GML_GPOAO_DETAILS_V, GML_GASNO_SHIPMENTS_V and GML_GASNO_DETAILS_V views for their respective tables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SITE_USE_ID VARCHAR2 (0)
Identifier for the row of Site Use
CUSTOMER_ID VARCHAR2 (0)
Customer Identifier
ADDRESS_ID VARCHAR2 (0)
Address identifier
TP_HEADER_ID VARCHAR2 (0)
TP Header Id
CONTACT_ID VARCHAR2 (0)
Contact Identifier
LOCATION VARCHAR2 (0)
Location Identifier
ORIG_SYSTEM_REFERENCE VARCHAR2 (0)
System that Originated
TP_LOCATION_CODE_EXT VARCHAR2 (0)
Location Code
TP_REFERENCE_EXT1 VARCHAR2 (0)
Trading Partner
TP_REFERENCE_EXT2 VARCHAR2 (0)
Trading Partner
CUSTOMER_NAME VARCHAR2 (0)
Customer Name
ADDRESS1 VARCHAR2 (0)
Address 1
ADDRESS2 VARCHAR2 (0)
Address 2
ADDRESS3 VARCHAR2 (0)
Address 3
ADDRESS4 VARCHAR2 (0)
Address 4
CITY VARCHAR2 (0)
City
POSTAL_CODE VARCHAR2 (0)
Postal Code
COUNTRY VARCHAR2 (0)
Country
STATE VARCHAR2 (0)
State
PROVINCE VARCHAR2 (0)
Province
COUNTY VARCHAR2 (0)
County
LAST_NAME VARCHAR2 (0)
Last Name
FIRST_NAME VARCHAR2 (0)
First Name
JOB_TITLE VARCHAR2 (0)
Job Title
AREA_CODE VARCHAR2 (0)
Area Code
PHONE_NUMBER VARCHAR2 (0)
Phone Number
Query Text

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


SELECT SITE_USE_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      TP_HEADER_ID
,      CONTACT_ID
,      LOCATION
,      ORIG_SYSTEM_REFERENCE
,      TP_LOCATION_CODE_EXT
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      CUSTOMER_NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      COUNTRY
,      STATE
,      PROVINCE
,      COUNTY
,      LAST_NAME
,      FIRST_NAME
,      JOB_TITLE
,      AREA_CODE
,      PHONE_NUMBER
FROM APPS.GML_EC_CONTACT_V;

Dependencies

[top of page]

APPS.GML_EC_CONTACT_V references the following:

SchemaPUBLIC
SynonymDUAL
APPS.GML_EC_CONTACT_V is referenced by following:

SchemaAPPS
ViewGML_GASNO_DETAILS_V
ViewGML_GASNO_ORDERS_V
ViewGML_GASNO_SHIPMENTS_V
ViewGML_GPOAO_DETAILS_V
ViewGML_GPOAO_ORDERS_V