VIEW: APPS.CSC_REVERSE_PHONE_V

Source

View Text - Preformatted

SELECT REVERSE(TRANSLATE(phone_country_code||phone_area_code||phone_number, '1@_.!"#$%&()''*+,-/:;<=>?[\]^`{|}~ ', '1')) reverse_phone_number, owner_table_id, last_update_date FROM hz_contact_points WHERE owner_table_name='HZ_PARTIES'

View Text - HTML Formatted

SELECT REVERSE(TRANSLATE(PHONE_COUNTRY_CODE||PHONE_AREA_CODE||PHONE_NUMBER
, '1@_.!"#$%&()''*+
, -/:;<=>?[\]^`{|}~ '
, '1')) REVERSE_PHONE_NUMBER
, OWNER_TABLE_ID
, LAST_UPDATE_DATE
FROM HZ_CONTACT_POINTS
WHERE OWNER_TABLE_NAME='HZ_PARTIES'