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

VIEW: APPS.BIL_DIMV_PLAN_ELEMENTS

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

View Type

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


BIL_DIMV_PLAN_ELEMENTS - Dimension view used to provide descriptive information related to
compensation plan elements. Plan elements are defined as quota_id from cn_quotas_all.
.
Source is Oracle CRM Sales Compensation schema.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUOTA_PK NUMBER

Quoat plan element identifier
ORG_FK NUMBER

Organization identifier
QUOTA_NAME VARCHAR2 (80)
Compensation plan element name
QUOTA_DESCRIPTION VARCHAR2 (1900)
Plan element description
QUOTA_TARGET NUMBER

Target quota amount for quota based plan elements
QUOTA_PAYMENT NUMBER

Quota payment amount percentage
QUOTA_PERIOD_TYPE VARCHAR2 (0)
Quota interval type
QUOTA_INCENTIVE_TYPE VARCHAR2 (80)
Quota incentive type code
QUOTA_PERFORMANCE_GOAL NUMBER

Performance goal
START_DATE DATE

Start date for quota
END_DATE DATE

End date for quota
ID VARCHAR2 (40)
Compensation plan element identifier
VALUE VARCHAR2 (80)
Compensation plan element name
Query Text

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


SELECT QUOTA_PK
,      ORG_FK
,      QUOTA_NAME
,      QUOTA_DESCRIPTION
,      QUOTA_TARGET
,      QUOTA_PAYMENT
,      QUOTA_PERIOD_TYPE
,      QUOTA_INCENTIVE_TYPE
,      QUOTA_PERFORMANCE_GOAL
,      START_DATE
,      END_DATE
,      ID
,      VALUE
FROM APPS.BIL_DIMV_PLAN_ELEMENTS;

Dependencies

[top of page]

APPS.BIL_DIMV_PLAN_ELEMENTS references the following:

SchemaAPPS
SynonymCN_QUOTAS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIL_DIMV_PLAN_ELEMENTS is not referenced by any database object