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

VIEW: APPS.BIX_DM_EMAIL_CLASSIFICATIONS_V

Object Details
Object Name: BIX_DM_EMAIL_CLASSIFICATIONS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This view lists all the email classifications from the table iem_route_classifications . It is used in the definition of list of values for the parameters of reports and bins .


[View Source]

Columns
Name Datatype Length Mandatory Comments
SORT_COL NUMBER

Used to sort the rows in the views while displaying in the list of values of the parameters .
CLASSIFICATION_ID VARCHAR2 (40)
Unique identifier for the classification .
CLASSIFICATION_NAME VARCHAR2 (80)
Name of the classification .
Query Text

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


SELECT SORT_COL
,      CLASSIFICATION_ID
,      CLASSIFICATION_NAME
FROM APPS.BIX_DM_EMAIL_CLASSIFICATIONS_V;

Dependencies

[top of page]

APPS.BIX_DM_EMAIL_CLASSIFICATIONS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymIEM_ROUTE_CLASSIFICATIONS

APPS.BIX_DM_EMAIL_CLASSIFICATIONS_V is not referenced by any database object