eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CN_SRP_PERIOD_QUOTAS_QTDYTD

Source

View Text - Preformatted


SELECT spq_p.salesrep_id, spq_p.role_id, spq_p.credit_type_id, spq_p.period_id, SUM(DECODE(ps_y.quarter_num,ps.quarter_num,NVL(spq_y.commission_earned_ptd,0),0)), SUM(DECODE(ps_y.quarter_num,ps.quarter_num,NVL(spq_y.bonus_earned_ptd,0),0)), SUM(DECODE(ps_y.quarter_num,ps.quarter_num,NVL(spq_y.other_earned_ptd,0),0)), SUM(DECODE(ps_y.quarter_num,ps.quarter_num,NVL(spq_y.advance_commission_ptd,0),0)), SUM(DECODE(ps_y.quarter_num,ps.quarter_num,NVL(spq_y.forecast_earned_ptd,0),0)), SUM(NVL(spq_y.commission_earned_ptd,0)), SUM(NVL(spq_y.bonus_earned_ptd,0)), SUM(NVL(spq_y.other_earned_ptd,0)), SUM(NVL(spq_y.advance_commission_ptd,0)), SUM(NVL(spq_y.forecast_earned_ptd,0)) FROM cn_srp_period_quotas_ptd spq_p, cn_srp_period_quotas_ptd spq_y, cn_period_statuses ps, cn_period_statuses ps_y WHERE spq_p.salesrep_id = spq_y.salesrep_id AND spq_p.period_id = ps.period_id AND spq_y.period_id = ps_y.period_id AND ps.period_year = ps_y.period_year AND ps.period_id >= ps_y.period_id AND spq_p.role_id = spq_y.role_id AND spq_p.credit_type_id = spq_y.credit_type_id GROUP BY spq_p.salesrep_id, spq_p.period_id, spq_p.role_id, spq_p.credit_type_id

View Text - HTML Formatted

SELECT SPQ_P.SALESREP_ID
, SPQ_P.ROLE_ID
, SPQ_P.CREDIT_TYPE_ID
, SPQ_P.PERIOD_ID
, SUM(DECODE(PS_Y.QUARTER_NUM
, PS.QUARTER_NUM
, NVL(SPQ_Y.COMMISSION_EARNED_PTD
, 0)
, 0))
, SUM(DECODE(PS_Y.QUARTER_NUM
, PS.QUARTER_NUM
, NVL(SPQ_Y.BONUS_EARNED_PTD
, 0)
, 0))
, SUM(DECODE(PS_Y.QUARTER_NUM
, PS.QUARTER_NUM
, NVL(SPQ_Y.OTHER_EARNED_PTD
, 0)
, 0))
, SUM(DECODE(PS_Y.QUARTER_NUM
, PS.QUARTER_NUM
, NVL(SPQ_Y.ADVANCE_COMMISSION_PTD
, 0)
, 0))
, SUM(DECODE(PS_Y.QUARTER_NUM
, PS.QUARTER_NUM
, NVL(SPQ_Y.FORECAST_EARNED_PTD
, 0)
, 0))
, SUM(NVL(SPQ_Y.COMMISSION_EARNED_PTD
, 0))
, SUM(NVL(SPQ_Y.BONUS_EARNED_PTD
, 0))
, SUM(NVL(SPQ_Y.OTHER_EARNED_PTD
, 0))
, SUM(NVL(SPQ_Y.ADVANCE_COMMISSION_PTD
, 0))
, SUM(NVL(SPQ_Y.FORECAST_EARNED_PTD
, 0))
FROM CN_SRP_PERIOD_QUOTAS_PTD SPQ_P
, CN_SRP_PERIOD_QUOTAS_PTD SPQ_Y
, CN_PERIOD_STATUSES PS
, CN_PERIOD_STATUSES PS_Y
WHERE SPQ_P.SALESREP_ID = SPQ_Y.SALESREP_ID
AND SPQ_P.PERIOD_ID = PS.PERIOD_ID
AND SPQ_Y.PERIOD_ID = PS_Y.PERIOD_ID
AND PS.PERIOD_YEAR = PS_Y.PERIOD_YEAR
AND PS.PERIOD_ID >= PS_Y.PERIOD_ID
AND SPQ_P.ROLE_ID = SPQ_Y.ROLE_ID
AND SPQ_P.CREDIT_TYPE_ID = SPQ_Y.CREDIT_TYPE_ID GROUP BY SPQ_P.SALESREP_ID
, SPQ_P.PERIOD_ID
, SPQ_P.ROLE_ID
, SPQ_P.CREDIT_TYPE_ID