VIEW: CN.CN_SRP_PERIOD_QUOTAS_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, SRP_PERIOD_QUOTA_ID SRP_PERIOD_QUOTA_ID, SRP_PLAN_ASSIGN_ID SRP_PLAN_ASSIGN_ID, SRP_QUOTA_ASSIGN_ID SRP_QUOTA_ASSIGN_ID, SALESREP_ID SALESREP_ID, PERIOD_ID PERIOD_ID, QUOTA_ID QUOTA_ID, TARGET_AMOUNT TARGET_AMOUNT, QUOTA_ACHIEVED_PTD QUOTA_ACHIEVED_PTD, COMMISSION_PAYED_PTD COMMISSION_PAYED_PTD, COMMISSION_PAYED_YTD COMMISSION_PAYED_YTD, QUOTA_ACHIEVED_YTD QUOTA_ACHIEVED_YTD, ITD_TARGET ITD_TARGET, PERIOD_PAYMENT PERIOD_PAYMENT, ITD_PAYMENT ITD_PAYMENT, TRX_AMOUNT_PTD TRX_AMOUNT_PTD, TRX_AMOUNT_YTD TRX_AMOUNT_YTD, QUANTITY_PTD QUANTITY_PTD, QUANTITY_YTD QUANTITY_YTD, COMMISSION_PAYED_ITD COMMISSION_PAYED_ITD, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QUOTA_ACHIEVED_PTD_F QUOTA_ACHIEVED_PTD_F, QUOTA_AMOUNT_PTD_F QUOTA_AMOUNT_PTD_F, QUOTA_AMOUNT_YTD_F QUOTA_AMOUNT_YTD_F, QUOTA_ACHIEVED_YTD_F QUOTA_ACHIEVED_YTD_F, COMMISSION_PAYED_ITD_F COMMISSION_PAYED_ITD_F, COMMISSION_PAYED_PTD_F COMMISSION_PAYED_PTD_F, COMMISSION_PAYED_YTD_F COMMISSION_PAYED_YTD_F, TRX_AMOUNT_PTD_F TRX_AMOUNT_PTD_F, TRX_AMOUNT_YTD_F TRX_AMOUNT_YTD_F, QUANTITY_PTD_F QUANTITY_PTD_F, QUANTITY_YTD_F QUANTITY_YTD_F, INPUT_ACHIEVED_PTD INPUT_ACHIEVED_PTD, INPUT_ACHIEVED_ITD INPUT_ACHIEVED_ITD, OUTPUT_ACHIEVED_PTD OUTPUT_ACHIEVED_PTD, OUTPUT_ACHIEVED_ITD OUTPUT_ACHIEVED_ITD, PERF_ACHIEVED_PTD PERF_ACHIEVED_PTD, PERF_ACHIEVED_ITD PERF_ACHIEVED_ITD, ADVANCE_RECOVERED_PTD ADVANCE_RECOVERED_PTD, ADVANCE_RECOVERED_ITD ADVANCE_RECOVERED_ITD, ADVANCE_TO_REC_PTD ADVANCE_TO_REC_PTD, ADVANCE_TO_REC_ITD ADVANCE_TO_REC_ITD, COMM_PEND_PTD COMM_PEND_PTD, COMM_PEND_ITD COMM_PEND_ITD, RECOVERY_AMOUNT_PTD RECOVERY_AMOUNT_PTD, RECOVERY_AMOUNT_ITD RECOVERY_AMOUNT_ITD, PERFORMANCE_GOAL_PTD PERFORMANCE_GOAL_PTD, PERFORMANCE_GOAL_ITD PERFORMANCE_GOAL_ITD, LAST_RATE_TIER_ID LAST_RATE_TIER_ID, LAST_RATES LAST_RATES, INPUT_ACHIEVED_PTD_F INPUT_ACHIEVED_PTD_F, INPUT_ACHIEVED_ITD_F INPUT_ACHIEVED_ITD_F, OUTPUT_ACHIEVED_PTD_F OUTPUT_ACHIEVED_PTD_F, OUTPUT_ACHIEVED_ITD_F OUTPUT_ACHIEVED_ITD_F, PERF_ACHIEVED_PTD_F PERF_ACHIEVED_PTD_F, PERF_ACHIEVED_ITD_F PERF_ACHIEVED_ITD_F, SECURITY_GROUP_ID SECURITY_GROUP_ID, ROLLOVER ROLLOVER, TOTAL_ROLLOVER TOTAL_ROLLOVER, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TRANSACTION_AMOUNT_PTD TRANSACTION_AMOUNT_PTD, TRANSACTION_AMOUNT_ITD TRANSACTION_AMOUNT_ITD from "CN"."CN_SRP_PERIOD_QUOTAS_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, SRP_PERIOD_QUOTA_ID SRP_PERIOD_QUOTA_ID
, SRP_PLAN_ASSIGN_ID SRP_PLAN_ASSIGN_ID
, SRP_QUOTA_ASSIGN_ID SRP_QUOTA_ASSIGN_ID
, SALESREP_ID SALESREP_ID
, PERIOD_ID PERIOD_ID
, QUOTA_ID QUOTA_ID
, TARGET_AMOUNT TARGET_AMOUNT
, QUOTA_ACHIEVED_PTD QUOTA_ACHIEVED_PTD
, COMMISSION_PAYED_PTD COMMISSION_PAYED_PTD
, COMMISSION_PAYED_YTD COMMISSION_PAYED_YTD
, QUOTA_ACHIEVED_YTD QUOTA_ACHIEVED_YTD
, ITD_TARGET ITD_TARGET
, PERIOD_PAYMENT PERIOD_PAYMENT
, ITD_PAYMENT ITD_PAYMENT
, TRX_AMOUNT_PTD TRX_AMOUNT_PTD
, TRX_AMOUNT_YTD TRX_AMOUNT_YTD
, QUANTITY_PTD QUANTITY_PTD
, QUANTITY_YTD QUANTITY_YTD
, COMMISSION_PAYED_ITD COMMISSION_PAYED_ITD
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QUOTA_ACHIEVED_PTD_F QUOTA_ACHIEVED_PTD_F
, QUOTA_AMOUNT_PTD_F QUOTA_AMOUNT_PTD_F
, QUOTA_AMOUNT_YTD_F QUOTA_AMOUNT_YTD_F
, QUOTA_ACHIEVED_YTD_F QUOTA_ACHIEVED_YTD_F
, COMMISSION_PAYED_ITD_F COMMISSION_PAYED_ITD_F
, COMMISSION_PAYED_PTD_F COMMISSION_PAYED_PTD_F
, COMMISSION_PAYED_YTD_F COMMISSION_PAYED_YTD_F
, TRX_AMOUNT_PTD_F TRX_AMOUNT_PTD_F
, TRX_AMOUNT_YTD_F TRX_AMOUNT_YTD_F
, QUANTITY_PTD_F QUANTITY_PTD_F
, QUANTITY_YTD_F QUANTITY_YTD_F
, INPUT_ACHIEVED_PTD INPUT_ACHIEVED_PTD
, INPUT_ACHIEVED_ITD INPUT_ACHIEVED_ITD
, OUTPUT_ACHIEVED_PTD OUTPUT_ACHIEVED_PTD
, OUTPUT_ACHIEVED_ITD OUTPUT_ACHIEVED_ITD
, PERF_ACHIEVED_PTD PERF_ACHIEVED_PTD
, PERF_ACHIEVED_ITD PERF_ACHIEVED_ITD
, ADVANCE_RECOVERED_PTD ADVANCE_RECOVERED_PTD
, ADVANCE_RECOVERED_ITD ADVANCE_RECOVERED_ITD
, ADVANCE_TO_REC_PTD ADVANCE_TO_REC_PTD
, ADVANCE_TO_REC_ITD ADVANCE_TO_REC_ITD
, COMM_PEND_PTD COMM_PEND_PTD
, COMM_PEND_ITD COMM_PEND_ITD
, RECOVERY_AMOUNT_PTD RECOVERY_AMOUNT_PTD
, RECOVERY_AMOUNT_ITD RECOVERY_AMOUNT_ITD
, PERFORMANCE_GOAL_PTD PERFORMANCE_GOAL_PTD
, PERFORMANCE_GOAL_ITD PERFORMANCE_GOAL_ITD
, LAST_RATE_TIER_ID LAST_RATE_TIER_ID
, LAST_RATES LAST_RATES
, INPUT_ACHIEVED_PTD_F INPUT_ACHIEVED_PTD_F
, INPUT_ACHIEVED_ITD_F INPUT_ACHIEVED_ITD_F
, OUTPUT_ACHIEVED_PTD_F OUTPUT_ACHIEVED_PTD_F
, OUTPUT_ACHIEVED_ITD_F OUTPUT_ACHIEVED_ITD_F
, PERF_ACHIEVED_PTD_F PERF_ACHIEVED_PTD_F
, PERF_ACHIEVED_ITD_F PERF_ACHIEVED_ITD_F
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ROLLOVER ROLLOVER
, TOTAL_ROLLOVER TOTAL_ROLLOVER
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TRANSACTION_AMOUNT_PTD TRANSACTION_AMOUNT_PTD
, TRANSACTION_AMOUNT_ITD TRANSACTION_AMOUNT_ITD
FROM "CN"."CN_SRP_PERIOD_QUOTAS_ALL"