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

VIEW: APPS.BIL_DIMV_INTEREST_TYPES

Object Details
Object Name: BIL_DIMV_INTEREST_TYPES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIL.BIL_DIMV_INTEREST_TYPES
Subobject Name:
Status: VALID

View Type

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


BIL_DIMV_INTEREST_TYPES - Dimension view used to provide descriptive information relating to
product interest types.
.
Source is Oracle CRM Sales schema.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INTEREST_TYPE_PK NUMBER

Interest type identifier
INTEREST_TYPE VARCHAR2 (80)
Interest type
DESCRIPTION VARCHAR2 (240)
Interest type description
ENABLED_FLAG VARCHAR2 (1)
Interest type enabled flag
ID VARCHAR2 (40)
Interest type identifier
VALUE VARCHAR2 (80)
Interest type description
Query Text

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


SELECT INTEREST_TYPE_PK
,      INTEREST_TYPE
,      DESCRIPTION
,      ENABLED_FLAG
,      ID
,      VALUE
FROM APPS.BIL_DIMV_INTEREST_TYPES;

Dependencies

[top of page]

APPS.BIL_DIMV_INTEREST_TYPES references the following:

SchemaAPPS
SynonymAS_INTEREST_TYPES_B
SynonymAS_INTEREST_TYPES_TL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIL_DIMV_INTEREST_TYPES is not referenced by any database object