View: BIL_DIMV_COMP_PLANS

Product:	BIL - Sales Intelligence
Description:	Compensation plans view
Implementation/DBA Data:	APPS.BIL_DIMV_COMP_PLANS

View Text

SELECT CPLAN.COMP_PLAN_ID
, CPLAN.NAME
, CPLAN.DESCRIPTION
, CPLAN.STATUS_CODE
, CPLAN.ALLOW_REV_CLASS_OVERLAP
, CPLAN.START_DATE
, CPLAN.END_DATE
, TO_CHAR(CPLAN.COMP_PLAN_ID) ID
, CPLAN.NAME
FROM CN_COMP_PLANS_ALL CPLAN UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) COMP_PLAN_PK
, SUBSTR(FL.MEANING
, 1
, 30) COMP_PLAN_NAME
, FL.DESCRIPTION COMP_PLAN_DESCRIPTION
, SUBSTR(FL.MEANING
, 1
, 30) COMP_PLAN_STATUS
, 'N' ALLOW_REV_CLASS_OVERLAP
, FL.START_DATE_ACTIVE COMP_PLAN_START_DATE
, FL.END_DATE_ACTIVE COMP_PLAN_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