eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.BIL_DIMV_INTEREST_CODES

Object Details

Object Name:	BIL_DIMV_INTEREST_CODES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIL.BIL_DIMV_INTEREST_CODES
Subobject Name:
Status:	VALID

View Type

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

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

[View Source]

Columns

Name	Datatype	Length	Comments
INTEREST_CODE_PK	NUMBER		Interest code identifier
INTEREST_TYPE_FK	NUMBER		Interest type identifier
PARENT_INTEREST_CODE_FK	NUMBER		Parent interest code identifier
INTEREST_CODE	VARCHAR2	(100)	Interest code
DESCRIPTION	VARCHAR2	(240)	Interest code description
ENABLED_FLAG	VARCHAR2	(1)	Interest code enabled flag
ID	VARCHAR2	(40)	Interest Code identifier
VALUE	VARCHAR2	(80)	Interest Code description

Query Text

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


SELECT INTEREST_CODE_PK
,      INTEREST_TYPE_FK
,      PARENT_INTEREST_CODE_FK
,      INTEREST_CODE
,      DESCRIPTION
,      ENABLED_FLAG
,      ID
,      VALUE
FROM APPS.BIL_DIMV_INTEREST_CODES;

Dependencies

[top of page]

APPS.BIL_DIMV_INTEREST_CODES references the following:

APPS: AS_INTEREST_CODES_B; AS_INTEREST_CODES_TL; AS_INTEREST_TYPES_B; FND_GLOBAL - show dependent code; FND_LOOKUPS

APPS.BIL_DIMV_INTEREST_CODES is not referenced by any database object