Product: | AST - TeleSales |
---|---|
Description: | Merge between phone assistance and contact points |
Implementation/DBA Data: | APPS.AST_PHONE_ASSISTS_V |
SELECT PA.PHONE_ASSIST_ID
, PA.PROGRAM_ID
, PA.OBJECT_VERSION_NUMBER
, PA.LAST_UPDATE_DATE
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.PHONE_ASSIST_NAME
, PA.DESCRIPTION
, PA.ENABLED_FLAG
, PA.PHONE_ID
, PA.ASSIST_ID
, CP.STATUS
, CP.OWNER_TABLE_NAME
, CP.OWNER_TABLE_ID
, CP.PHONE_AREA_CODE
, CP.PHONE_COUNTRY_CODE
, CP.PHONE_NUMBER
, CP.PHONE_EXTENSION
, CP.PHONE_LINE_TYPE
FROM AST_PHONE_ASSISTS PA
, HZ_CONTACT_POINTS CP
WHERE PA.PHONE_ID = CP.CONTACT_POINT_ID
AND CP.CONTACT_POINT_TYPE = 'PHONE'
AND CP.STATUS = 'A'