VIEW: APPS.AMS_LT_HZ_PHONE_1

Source

View Text - Preformatted

SELECT hcp.CONTACT_POINT_ID , hcp.CONTACT_POINT_TYPE , hcp.STATUS , hcp.OWNER_TABLE_ID , hcp.CONTENT_SOURCE_TYPE , hcp.PHONE_TOUCH_TONE_TYPE_FLAG , hcp.PHONE_LINE_TYPE , hcp.TIME_ZONE , hcp.RAW_PHONE_NUMBER , hcp.PHONE_COUNTRY_CODE , hcp.PHONE_AREA_CODE , hcp.PHONE_NUMBER , hcp.PHONE_EXTENSION , hcp.TELEX_NUMBER , hcp.TIMEZONE_ID , hcp.CONTACT_POINT_PURPOSE , hcp.PRIMARY_BY_PURPOSE , hcp.TRANSPOSED_PHONE_NUMBER FROM HZ_CONTACT_POINTS hcp WHERE hcp.STATUS = 'A' AND hcp.CONTENT_SOURCE_TYPE = 'USER_ENTERED' AND hcp.CONTACT_POINT_TYPE = 'PHONE' AND hcp.OWNER_TABLE_NAME = 'HZ_PARTIES' AND hcp.PRIMARY_FLAG = 'Y'

View Text - HTML Formatted

SELECT HCP.CONTACT_POINT_ID
, HCP.CONTACT_POINT_TYPE
, HCP.STATUS
, HCP.OWNER_TABLE_ID
, HCP.CONTENT_SOURCE_TYPE
, HCP.PHONE_TOUCH_TONE_TYPE_FLAG
, HCP.PHONE_LINE_TYPE
, HCP.TIME_ZONE
, HCP.RAW_PHONE_NUMBER
, HCP.PHONE_COUNTRY_CODE
, HCP.PHONE_AREA_CODE
, HCP.PHONE_NUMBER
, HCP.PHONE_EXTENSION
, HCP.TELEX_NUMBER
, HCP.TIMEZONE_ID
, HCP.CONTACT_POINT_PURPOSE
, HCP.PRIMARY_BY_PURPOSE
, HCP.TRANSPOSED_PHONE_NUMBER
FROM HZ_CONTACT_POINTS HCP
WHERE HCP.STATUS = 'A'
AND HCP.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND HCP.CONTACT_POINT_TYPE = 'PHONE'
AND HCP.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND HCP.PRIMARY_FLAG = 'Y'