VIEW: APPS.ASO_PVT_PHONES_V

Source

View Text - Preformatted

SELECT CONTACT_POINT_ID, PHONE_COUNTRY_CODE, PHONE_AREA_CODE, PHONE_NUMBER, PHONE_EXTENSION, OWNER_TABLE_ID, phone_line_type, primary_flag FROM HZ_CONTACT_POINTS WHERE STATUS = 'A' AND OWNER_TABLE_NAME = 'HZ_PARTIES' AND CONTACT_POINT_TYPE = 'PHONE'

View Text - HTML Formatted

SELECT CONTACT_POINT_ID
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, OWNER_TABLE_ID
, PHONE_LINE_TYPE
, PRIMARY_FLAG
FROM HZ_CONTACT_POINTS
WHERE STATUS = 'A'
AND OWNER_TABLE_NAME = 'HZ_PARTIES'
AND CONTACT_POINT_TYPE = 'PHONE'