[Home] [Help] [Dependency Information]
Object Name: | GML_EC_CONTACT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GML.GML_EC_CONTACT_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|