VIEW: APPS.OE_PRINT_CONT_POINTS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')