VIEW: APPS.BIL_DIMV_PLAN_ELEMENTS

Source

View Text - Preformatted

SELECT QUOTA.QUOTA_ID , QUOTA.ORG_ID , QUOTA.NAME , QUOTA.DESCRIPTION , QUOTA.TARGET , QUOTA.PAYMENT_AMOUNT , null , QUOTA.INCENTIVE_TYPE_CODE , QUOTA.PERFORMANCE_GOAL , QUOTA.START_DATE , QUOTA.END_DATE , TO_CHAR(QUOTA.QUOTA_ID) ID , QUOTA.NAME FROM CN_QUOTAS_ALL QUOTA 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 , null , 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

View Text - HTML Formatted

SELECT QUOTA.QUOTA_ID
, QUOTA.ORG_ID
, QUOTA.NAME
, QUOTA.DESCRIPTION
, QUOTA.TARGET
, QUOTA.PAYMENT_AMOUNT
, NULL
, QUOTA.INCENTIVE_TYPE_CODE
, QUOTA.PERFORMANCE_GOAL
, QUOTA.START_DATE
, QUOTA.END_DATE
, TO_CHAR(QUOTA.QUOTA_ID) ID
, QUOTA.NAME
FROM CN_QUOTAS_ALL QUOTA 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
, NULL
, 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