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

VIEW: APPS.FII_AR_COLLECTORS_V

Object Details
Object Name: FII_AR_COLLECTORS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFII.FII_AR_COLLECTORS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is based on table AR_COLLECTORS, It will contain information about the Collectors.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COLLECTOR_ID NUMBER

Collector Identifier
DESCRIPTION VARCHAR2 (4000)
Collector Description
EMPLOYEE_ID NUMBER

Employee Identifier
INACTIVE_DATE DATE

Inactive Date for the Collector
NAME VARCHAR2 (4000)
Collector Name
STATUS VARCHAR2 (1)
Collector Status
TELEPHONE_NUMBER VARCHAR2 (25)
Coollector Telephone Number
ALIAS VARCHAR2 (240)
Collector Alias
Query Text

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


SELECT COLLECTOR_ID
,      DESCRIPTION
,      EMPLOYEE_ID
,      INACTIVE_DATE
,      NAME
,      STATUS
,      TELEPHONE_NUMBER
,      ALIAS
FROM APPS.FII_AR_COLLECTORS_V;

Dependencies

[top of page]

APPS.FII_AR_COLLECTORS_V references the following:

SchemaAPPS
SynonymAR_COLLECTORS
PL/SQL PackageFND_MESSAGE - show dependent code
SchemaPUBLIC
SynonymDUAL

APPS.FII_AR_COLLECTORS_V is not referenced by any database object