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_SLS_CHANNELS

Object Details

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

View Type

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

BIL_DIMV_SLS_CHANNELS - Dimension view use to provide descriptive information related to
sales channels.
.
Source is Oracle Applications Order Management schema.
.
.

[View Source]

Columns

Name	Datatype	Length	Comments
CHANNEL_LOOKUP_CODE	VARCHAR2	(30)	Sales channel identifier
CHANNEL_MEANING	VARCHAR2	(80)	Sales channel name
CHANNEL_DESCRIPTION	VARCHAR2	(240)	Sales channel desription
CHANNEL_ENABLED_FLAG	VARCHAR2	(1)	Indicates whether sales channel is nabled or not
CHANNEL_START_DATE_ACTIVE	DATE		Date from which sales channel becomes active
CHANNEL_END_DATE_ACTIVE	DATE		Date from which sales channel becomes inactive
ID	VARCHAR2	(30)	Sales channel identifier
VALUE	VARCHAR2	(80)	Sales channel name

Query Text

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


SELECT CHANNEL_LOOKUP_CODE
,      CHANNEL_MEANING
,      CHANNEL_DESCRIPTION
,      CHANNEL_ENABLED_FLAG
,      CHANNEL_START_DATE_ACTIVE
,      CHANNEL_END_DATE_ACTIVE
,      ID
,      VALUE
FROM APPS.BIL_DIMV_SLS_CHANNELS;

Dependencies

[top of page]

APPS.BIL_DIMV_SLS_CHANNELS references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; OE_LOOKUPS

APPS.BIL_DIMV_SLS_CHANNELS is not referenced by any database object