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.BIM_DIMV_PROD_LOV

Object Details

Object Name:	BIM_DIMV_PROD_LOV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIM.BIM_DIMV_PROD_LOV
Subobject Name:
Status:	VALID

View Type

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

BIM_DIMV_PROD_LOV is a view showing the relationship between interest types, primary interest codes and secondary interest codes.
.

[View Source]

Columns

Name	Datatype	Length	Comments
INTEREST_TYPE_ID	NUMBER		interest type id
INTEREST_TYPE	VARCHAR2	(80)	interest type
PRIMARY_INTEREST_CODE_ID	NUMBER		primary interest code id
PRIMARY_INTEREST_CODE	VARCHAR2	(100)	primary interest code
SECONDARY_INTEREST_CODE_ID	NUMBER		secondary interest code id
SECONDARY_INTEREST_CODE	VARCHAR2	(100)	secondary interest code

Query Text

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


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

Dependencies

[top of page]

APPS.BIM_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.BIM_DIMV_PROD_LOV is referenced by following:

APPS: BIM_SUMV_CAMP_MARGIN; BIM_SUMV_CAMP_PERF; BIM_SUMV_EVENT_PERF