VIEW: APPS.GMS_PHONE_CONTACTS_V

Source

View Text - Preformatted

SELECT CONT_POINT.CONTACT_POINT_ID , DECODE(CONT_POINT.CONTACT_POINT_TYPE, 'TLX', CONT_POINT.TELEX_NUMBER, CONT_POINT.PHONE_NUMBER) , CONT_POINT.STATUS , NVL(CONT_POINT.PHONE_LINE_TYPE, CONT_POINT.CONTACT_POINT_TYPE) , LOOK.MEANING , CAR.CUST_ACCOUNT_ID , CAR.CUST_ACCOUNT_ROLE_ID , CONT_POINT.PHONE_AREA_CODE , CONT_POINT.PHONE_EXTENSION , CONT_POINT.PRIMARY_FLAG , CONT_POINT.LAST_UPDATE_DATE , CONT_POINT.LAST_UPDATED_BY , CONT_POINT.CREATION_DATE , CONT_POINT.CREATED_BY , CONT_POINT.LAST_UPDATE_LOGIN , NULL FROM HZ_CONTACT_POINTS CONT_POINT , HZ_CUST_ACCOUNT_ROLES CAR, AR_LOOKUPS LOOK WHERE NVL(CONT_POINT.PHONE_LINE_TYPE, CONT_POINT.CONTACT_POINT_TYPE) = LOOK.LOOKUP_CODE AND LOOK.LOOKUP_TYPE = 'COMMUNICATION_TYPE' AND CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES' AND CONT_POINT.CONTACT_POINT_TYPE NOT IN ( 'EDI', 'EMAIL', 'WEB')

View Text - HTML Formatted

SELECT CONT_POINT.CONTACT_POINT_ID
, DECODE(CONT_POINT.CONTACT_POINT_TYPE
, 'TLX'
, CONT_POINT.TELEX_NUMBER
, CONT_POINT.PHONE_NUMBER)
, CONT_POINT.STATUS
, NVL(CONT_POINT.PHONE_LINE_TYPE
, CONT_POINT.CONTACT_POINT_TYPE)
, LOOK.MEANING
, CAR.CUST_ACCOUNT_ID
, CAR.CUST_ACCOUNT_ROLE_ID
, CONT_POINT.PHONE_AREA_CODE
, CONT_POINT.PHONE_EXTENSION
, CONT_POINT.PRIMARY_FLAG
, CONT_POINT.LAST_UPDATE_DATE
, CONT_POINT.LAST_UPDATED_BY
, CONT_POINT.CREATION_DATE
, CONT_POINT.CREATED_BY
, CONT_POINT.LAST_UPDATE_LOGIN
, NULL
FROM HZ_CONTACT_POINTS CONT_POINT
, HZ_CUST_ACCOUNT_ROLES CAR
, AR_LOOKUPS LOOK
WHERE NVL(CONT_POINT.PHONE_LINE_TYPE
, CONT_POINT.CONTACT_POINT_TYPE) = LOOK.LOOKUP_CODE
AND LOOK.LOOKUP_TYPE = 'COMMUNICATION_TYPE'
AND CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND CONT_POINT.CONTACT_POINT_TYPE NOT IN ( 'EDI'
, 'EMAIL'
, 'WEB')