View: GML_EC_CONTACT_V

Product:	GML - Process Manufacturing Logistics
Description:	Customer contact view.
Implementation/DBA Data:	APPS.GML_EC_CONTACT_V

View Text

SELECT RSU.SITE_USE_ID SITE_USE_ID
, RCU.CUSTOMER_ID CUSTOMER_ID
, RAD.ADDRESS_ID ADDRESS_ID
, ETH.TP_HEADER_ID TP_HEADER_ID
, RAC.CONTACT_ID CONTACT_ID
, RSU.LOCATION LOCATION
, RAD.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, RAD.ECE_TP_LOCATION_CODE TP_LOCATION_CODE_EXT
, ETH.TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, ETH.TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, RCU.CUSTOMER_NAME CUSTOMER_NAME
, RAD.ADDRESS1 ADDRESS1
, RAD.ADDRESS2 ADDRESS2
, RAD.ADDRESS3 ADDRESS3
, RAD.ADDRESS4 ADDRESS4
, RAD.CITY CITY
, RAD.POSTAL_CODE POSTAL_CODE
, RAD.COUNTRY COUNTRY
, RAD.STATE STATE
, RAD.PROVINCE PROVINCE
, RAD.COUNTY COUNTY
, RAC.LAST_NAME LAST_NAME
, RAC.FIRST_NAME FIRST_NAME
, RAC.JOB_TITLE JOB_TITLE
, RAP.AREA_CODE AREA_CODE
, RAP.PHONE_NUMBER PHONE_NUMBER
FROM ECE_TP_HEADERS ETH
, RA_ADDRESSES_ALL RAD
, RA_CUSTOMERS RCU
, RA_SITE_USES_ALL RSU
, RA_CONTACTS RAC
, RA_PHONES RAP
WHERE ETH.TP_HEADER_ID = RAD.TP_HEADER_ID
AND RAD.CUSTOMER_ID = RCU.CUSTOMER_ID
AND RAD.ADDRESS_ID = RSU.ADDRESS_ID
AND RSU.ADDRESS_ID = RAC.ADDRESS_ID(+)
AND RAC.CONTACT_ID = RAP.CONTACT_ID (+)
AND RAP.PHONE_TYPE (+) = 'GEN'
AND RAP.PRIMARY_FLAG (+) = 'Y'

Columns