[Home] [Help]
View: 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
Name |
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 |