View: ASO_PVT_PHONES_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_PVT_PHONES_V

View Text

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'

Columns