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_SLSPROD_HIER

Object Details

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

View Type

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

BIL_DIMV_SLSPROD_HIER - Dimension view used to define the relationships along the product
hierarchy.
.
Source is Oracle CRM Sales schema.
.
.

[View Source]

Columns

Name	Datatype	Length	Comments
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
INTEREST_TYPE_ID	NUMBER		Interest type identifier
PRIMARY_INTEREST_CODE_ID	NUMBER		Primary interest code
SECONDARY_INTEREST_CODE_ID	NUMBER		Secondary interest code
INTEREST_TYPE	VARCHAR2	(80)	Inteest type
PRIMARY_INTEREST_CODE	VARCHAR2	(100)	Primary Interest
SECONDARY_INTEREST_CODE	VARCHAR2	(100)	secondary interest

Query Text

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


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

Dependencies

[top of page]

APPS.BIL_DIMV_SLSPROD_HIER references the following:

APPS: AS_INTEREST_CODES_TL; AS_INTEREST_TYPES_TL; AS_INV_ITEM_LOV_V; FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_PROFILE - show dependent code; OE_PROFILE - show dependent code

APPS.BIL_DIMV_SLSPROD_HIER is not referenced by any database object