View: AR_CUST_CALLS_V

Product:	AR - Receivables
Description:	(Release 11.5 Only)
Implementation/DBA Data:	APPS.AR_CUST_CALLS_V

View Text

SELECT CC.ROWID
, C.NAME
, CC.CALL_DATE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AR_CALL_STATUS'
, CC.STATUS)
, SUBSTRB(PARTY_CONT.PERSON_FIRST_NAME
, 1
, 40) ||' '|| SUBSTRB(PARTY_CONT.PERSON_LAST_NAME
, 1
, 50)
, L.MEANING
, N.TEXT
, PARTY.PARTY_NAME
, CUST_ACCT.ACCOUNT_NUMBER
, SU.LOCATION
, CC.CUSTOMER_CALL_ID
, CC.CUSTOMER_ID
, SU.SITE_USE_ID
, CC.LAST_UPDATED_BY
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATE_LOGIN
, CC.CREATED_BY
, CC.CREATION_DATE
FROM AR_CUSTOMER_CALLS CC
, AR_COLLECTORS C
, HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY_CONT
, HZ_RELATIONSHIPS REL
, AR_LOOKUPS L
, AR_NOTES N
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES SU
WHERE C.COLLECTOR_ID = CC.COLLECTOR_ID
AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID(+) = CC.CONTACT_ID
AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID(+)
AND REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG(+) = 'F'
AND ACCT_ROLE.ROLE_TYPE(+) = 'CONTACT'
AND REL.SUBJECT_ID = PARTY_CONT.PARTY_ID(+)
AND NVL(L.LOOKUP_TYPE
, 'CUSTOMER_RESPONSE_REASON') = 'CUSTOMER_RESPONSE_REASON'
AND L.LOOKUP_CODE (+) = CC.REASON_CODE
AND N.CUSTOMER_CALL_ID(+) = CC.CUSTOMER_CALL_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = CC.CUSTOMER_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND SU.SITE_USE_ID(+) = CC.SITE_USE_ID

Columns