View: BIL_FCTV_COMP_AMOUNTS

View Text

SELECT CPS.PERIOD_NAME
, CL.PROCESSED_DATE
, JRS.RESOURCE_ID
, CH.ORG_ID
, CL.ROLE_ID
, CQA.COMP_PLAN_ID
, CH.SALES_CHANNEL
, CQ.INCENTIVE_TYPE_CODE
, CL.COMMISSION_LINE_ID
, CQ.QUOTA_ID
, DECODE(CQ.INCENTIVE_TYPE_CODE
, 'COMMISSION'
, CL.COMMISSION_AMOUNT
, NULL)
, DECODE(CQ.INCENTIVE_TYPE_CODE
, 'BONUS'
, CL.COMMISSION_AMOUNT
, NULL)
, JRRE.COMPENSATION_CURRENCY_CODE
FROM CN_PERIOD_STATUSES_ALL CPS
, CN_QUOTA_ASSIGNS_ALL CQA
, CN_QUOTAS_ALL CQ
, CN_COMMISSION_LINES_ALL CL
, CN_COMMISSION_HEADERS_ALL CH
, CN_CREDIT_TYPES_ALL_B CCTB
, JTF_RS_SALESREPS JRS
, JTF_RS_RESOURCE_EXTNS JRRE
WHERE CH.COMMISSION_HEADER_ID = CL.COMMISSION_HEADER_ID
AND CH.PROCESSED_PERIOD_ID = CPS.PERIOD_ID
AND CL.QUOTA_ID = CQ.QUOTA_ID
AND CQA.QUOTA_ID = CQ.QUOTA_ID
AND CQ.CREDIT_TYPE_ID = CCTB.CREDIT_TYPE_ID
AND UPPER(CCTB.MONETARY_FLAG) = 'Y'
AND UPPER(CL.STATUS) = ('CALC')
AND JRS.SALESREP_ID = CL.CREDITED_SALESREP_ID
AND JRS.RESOURCE_ID = JRRE.RESOURCE_ID
AND JRS.ORG_ID = CH.ORG_ID

Columns