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_PROD_LOV

Object Details

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

View Type

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

BI._DIMV_PROD_LOV - Dimension view used to define the product hierarchy used for Sales
Intelligence reporting.
.
Source is Oracle CRM Sales and Sales Intelligence schemas.
.
.

[View Source]

Columns

Name	Datatype	Length	Comments
INTEREST_TYPE	VARCHAR2	(80)	Interest type
PRIMARY_INTEREST_CODE_ID	NUMBER		Primary interest code identifier
PRIMARY_INTEREST_CODE	VARCHAR2	(100)	Primary interest code
SECONDARY_INTEREST_CODE_ID	NUMBER		Secondary interest code identifier
SECONDARY_INTEREST_CODE	VARCHAR2	(100)	Secondary interest code
INTEREST_TYPE_ID	NUMBER		Interest type identifer

Query Text

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


SELECT INTEREST_TYPE
,      PRIMARY_INTEREST_CODE_ID
,      PRIMARY_INTEREST_CODE
,      SECONDARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE
,      INTEREST_TYPE_ID
FROM APPS.BIL_DIMV_PROD_LOV;

Dependencies

[top of page]

APPS.BIL_DIMV_PROD_LOV references the following:

APPS: AS_INTEREST_CODES_TL; AS_INTEREST_TYPES_TL; BIM_SALES_CATEGORY_HIER; FND_GLOBAL - show dependent code; FND_LOOKUPS

APPS.BIL_DIMV_PROD_LOV is not referenced by any database object