VIEW: APPS.CN_SRP_PERIOD_QUOTAS_V

Source

View Text - Preformatted

SELECT pq.srp_period_quota_id , p.period_name , pq.period_id , pq.salesrep_id , pq.quota_id , pq.srp_quota_assign_id , pq.srp_plan_assign_id , pq.target_amount , pq.itd_target , pq.period_payment , pq.itd_payment , pq.performance_goal_ptd , pq.performance_goal_itd , p.quarter_num , p.period_year , pq.creation_date , pq.last_update_date , pq.last_update_login , pq.last_updated_by , pq.created_by FROM CN_SRP_PERIOD_QUOTAS PQ, CN_PERIOD_STATUSES_ALL P WHERE pq.period_id = p.period_id and pq.org_id = p.org_id

View Text - HTML Formatted

SELECT PQ.SRP_PERIOD_QUOTA_ID
, P.PERIOD_NAME
, PQ.PERIOD_ID
, PQ.SALESREP_ID
, PQ.QUOTA_ID
, PQ.SRP_QUOTA_ASSIGN_ID
, PQ.SRP_PLAN_ASSIGN_ID
, PQ.TARGET_AMOUNT
, PQ.ITD_TARGET
, PQ.PERIOD_PAYMENT
, PQ.ITD_PAYMENT
, PQ.PERFORMANCE_GOAL_PTD
, PQ.PERFORMANCE_GOAL_ITD
, P.QUARTER_NUM
, P.PERIOD_YEAR
, PQ.CREATION_DATE
, PQ.LAST_UPDATE_DATE
, PQ.LAST_UPDATE_LOGIN
, PQ.LAST_UPDATED_BY
, PQ.CREATED_BY
FROM CN_SRP_PERIOD_QUOTAS PQ
, CN_PERIOD_STATUSES_ALL P
WHERE PQ.PERIOD_ID = P.PERIOD_ID
AND PQ.ORG_ID = P.ORG_ID