VIEW: APPS.ARBV_COLLECTION_CALLS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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