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


VIEW: APPS.BIL_DIMV_SEC_INT_CODES

Object Details
Object Name: BIL_DIMV_SEC_INT_CODES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIL.BIL_DIMV_SEC_INT_CODES
Subobject Name:
Status: VALID

View Type

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


BIL_DIMV_SEC_INT_CODES - Dimension view used to provide descriptive information related to
product secondary interest codes. Used for Sales Intelligence performance measure reporting.
.
Source is Oracle CRM Sales schema.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SECONDARY_INTEREST_CODE_ID NUMBER

Interest code identifier
SECONDARY_INTEREST_CODE VARCHAR2 (100)
Interest code
ID VARCHAR2 (40)
Interest code identifier
VALUE VARCHAR2 (80)
Interest code
Query Text

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


SELECT SECONDARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE
,      ID
,      VALUE
FROM APPS.BIL_DIMV_SEC_INT_CODES;

Dependencies

[top of page]

APPS.BIL_DIMV_SEC_INT_CODES references the following:

SchemaAPPS
SynonymAS_INTEREST_CODES_B
SynonymAS_INTEREST_CODES_TL
SynonymAS_INTEREST_TYPES_B
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIL_DIMV_SEC_INT_CODES is not referenced by any database object