DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.ARBV_COLLECTION_CALLS

Object Details
Object Name: ARBV_COLLECTION_CALLS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.ARBV_COLLECTION_CALLS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about telephone calls made to a customer regarding outstanding account balances.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COLLECTION_CALL_ID NUMBER (15) Yes
CALL_DATE DATE
Yes
CALL_TIME NUMBER

_LA:CALL_STATUS CHAR (91)
CUSTOMER_LOCATION VARCHAR2 (40)
_LA:CUSTOMER_RESPONSE CHAR (63)
_LA:OUTCOME CHAR (52)
NOTES VARCHAR2 (2000)
_LA:FOLLOW_UP_ACTION CHAR (53)
FOLLOW_UP_DATE DATE

_LA:FOLLOW_UP_COMPLETE_FLAG CHAR (47)
PROMISE_DATE DATE

PROMISE_AMOUNT NUMBER

FORECAST_COLLECTIBLE_PERCENT NUMBER (3)
FORECAST_DATE DATE

CUSTOMER_ID NUMBER (15) Yes
CONTACT_ID NUMBER (15)
COLLECTOR_ID NUMBER (15) Yes
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COLLECTION_CALL_ID
,      CALL_DATE
,      CALL_TIME
,      _LA:CALL_STATUS
,      CUSTOMER_LOCATION
,      _LA:CUSTOMER_RESPONSE
,      _LA:OUTCOME
,      NOTES
,      _LA:FOLLOW_UP_ACTION
,      FOLLOW_UP_DATE
,      _LA:FOLLOW_UP_COMPLETE_FLAG
,      PROMISE_DATE
,      PROMISE_AMOUNT
,      FORECAST_COLLECTIBLE_PERCENT
,      FORECAST_DATE
,      CUSTOMER_ID
,      CONTACT_ID
,      COLLECTOR_ID
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.ARBV_COLLECTION_CALLS;

Dependencies

[top of page]

APPS.ARBV_COLLECTION_CALLS references the following:

SchemaAPPS
SynonymAR_CUSTOMER_CALLS
SynonymAR_NOTES
SynonymHZ_CUST_SITE_USES

APPS.ARBV_COLLECTION_CALLS is not referenced by any database object