View: OE_PRINT_CONT_POINTS_V

Product:	ONT - Order Management
Description:	This view is used to print the details of the various modes of communication for the Customer Contact
Implementation/DBA Data:	APPS.OE_PRINT_CONT_POINTS_V

View Text

SELECT CONTACT_POINT_ID
, CONTACT_POINT_TYPE
, STATUS
, OWNER_TABLE_NAME
, OWNER_TABLE_ID
, PRIMARY_FLAG
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, PHONE_LINE_TYPE
, TELEX_NUMBER
, WEB_TYPE
, URL
FROM HZ_CONTACT_POINTS
WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
AND STATUS = 'A'
AND CONTACT_POINT_TYPE IN ('PHONE'
, 'WEB'
, 'TLX')

Columns