VIEW: APPS.AST_PHONE_ASSISTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'