View: ARBV_COLLECTION_CALLS

Product:	AR - Receivables
Description:	This shows information about telephone calls made to a customer regarding outstanding account balances.
Implementation/DBA Data:	APPS.ARBV_COLLECTION_CALLS

View Text

SELECT /* UNIQUE ATTRIBUTES */ CCA.CUSTOMER_CALL_ID
, /* REGULAR ATTRIBUTES */ CCA.CALL_DATE
, (CCA.CALL_DATE - TRUNC(CCA.CALL_DATE))
, '_LA:DECODE(CCA.STATUS
, ''OPEN''
, ''OP''
, ''CL''):AR_LOOKUPS:PAYMENT_SCHEDULE_STATUS:MEANING'
, SUA.LOCATION
, '_LA:CCA.REASON_CODE:AR_LOOKUPS:CUSTOMER_RESPONSE_REASON:MEANING'
, '_LA:CCA.CALL_OUTCOME:AR_LOOKUPS:CALL_OUTCOME:MEANING'
, NS.TEXT
, '_LA:CCA.FOLLOW_UP_ACTION:AR_LOOKUPS:FOLLOW_UP:MEANING'
, CCA.FOLLOW_UP_DATE
, '_LA:CCA.COMPLETE_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, CCA.PROMISE_DATE
, CCA.PROMISE_AMOUNT
, CCA.COLLECTION_FORECAST
, CCA.FORECAST_DATE
, /* IDS */ CCA.CUSTOMER_ID
, CCA.CONTACT_ID
, CCA.COLLECTOR_ID
, CCA.ORG_ID
, /* WHO COLUMNS */ CCA.LAST_UPDATE_DATE
, CCA.LAST_UPDATED_BY
, CCA.CREATION_DATE
, CCA.CREATED_BY
FROM AR_CUSTOMER_CALLS CCA
, HZ_CUST_SITE_USES SUA
, AR_NOTES NS
WHERE CCA.CUSTOMER_CALL_ID = NS.CUSTOMER_CALL_ID(+)
AND CCA.SITE_USE_ID = SUA.SITE_USE_ID(+) WITH READ ONLY

Columns