VIEW: APPS.AR_CUST_CALLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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