View: BIL_DIMV_PLAN_ELEMENTS

Product:	BIL - Sales Intelligence
Description:	Compensation plan elements view
Implementation/DBA Data:	APPS.BIL_DIMV_PLAN_ELEMENTS

View Text

SELECT QUOTA.QUOTA_ID
, QUOTA.ORG_ID
, QUOTA.NAME
, QUOTA.DESCRIPTION
, QUOTA.TARGET
, QUOTA.PAYMENT_AMOUNT
, CITT.NAME
, QUOTA.INCENTIVE_TYPE_CODE
, QUOTA.PERFORMANCE_GOAL
, QUOTA.START_DATE
, QUOTA.END_DATE
, TO_CHAR(QUOTA.QUOTA_ID) ID
, QUOTA.NAME
FROM CN_QUOTA_ASSIGNS_ALL ASSIGN
, CN_INTERVAL_TYPES_ALL_B CITB
, CN_INTERVAL_TYPES_ALL_TL CITT
, CN_QUOTAS_ALL QUOTA
WHERE QUOTA.INTERVAL_TYPE_ID = CITB.INTERVAL_TYPE_ID
AND CITB.INTERVAL_TYPE_ID = CITT.INTERVAL_TYPE_ID
AND CITT.LANGUAGE = USERENV('LANG')
AND ASSIGN.QUOTA_ID = QUOTA.QUOTA_ID UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) QUOTA_PK
, TO_NUMBER(FL.LOOKUP_CODE) ORG_FK
, FL.MEANING QUOTA_NAME
, FL.DESCRIPTION QUOTA_DESCRIPTION
, TO_NUMBER(FL.LOOKUP_CODE) QUOTA_TARGET
, TO_NUMBER(FL.LOOKUP_CODE) QUOTA_PAYMENT
, FL.MEANING QUOTA_PERIOD_TYPE
, FL.MEANING QUOTA_INCENTIVE_TYPE
, TO_NUMBER(FL.LOOKUP_CODE) QUOTA_PERFORMANCE_GOAL
, FL.START_DATE_ACTIVE START_DATE
, FL.END_DATE_ACTIVE END_DATE
, FL.LOOKUP_CODE ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns