[Home] [Help]
[Dependency Information]
| Object Name: | BIL_DIMV_PRIM_INT_CODES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | BIL.BIL_DIMV_PRIM_INT_CODES
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIL_DIMV_PRIM_INT_CODES - Dimension view used to provide descriptive information related to
product primary interest codes. Used for Sales Intelligence performance measure reporting.
.
Source is Oracle CRM Sales Schema.
.
.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRIMARY_INTEREST_CODE_ID | NUMBER | Interest code identifier | ||
| PRIMARY_INTEREST_CODE | VARCHAR2 | (100) | Interest code | |
| ID | VARCHAR2 | (40) | Interest code identifier | |
| VALUE | VARCHAR2 | (80) | Interest code |
Cut, paste (and edit) the following text to query this object:
SELECT PRIMARY_INTEREST_CODE_ID
, PRIMARY_INTEREST_CODE
, ID
, VALUE
FROM APPS.BIL_DIMV_PRIM_INT_CODES;
APPS
AS_INTEREST_CODES_B
AS_INTEREST_CODES_TL
AS_INTEREST_TYPES_B
FND_GLOBAL
- show dependent code
FND_LOOKUPS
APPS.BIL_DIMV_PRIM_INT_CODES is not referenced by any database object
|
|
|
|