View: CSC_REVERSE_PHONE_V

Product:	CSC - Customer Care
Description:	Gives reverse phone number from HZ_CONTACT_POINTS table
Implementation/DBA Data:	APPS.CSC_REVERSE_PHONE_V

View Text

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'

Columns