VIEW: CN.CN_QUOTAS_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, QUOTA_ID QUOTA_ID, NAME NAME, RATE_SCHEDULE_ID RATE_SCHEDULE_ID, DISC_RATE_SCHEDULE_ID DISC_RATE_SCHEDULE_ID, QUOTA_TYPE_CODE QUOTA_TYPE_CODE, DISCOUNT_OPTION_CODE DISCOUNT_OPTION_CODE, TARGET TARGET, DESCRIPTION DESCRIPTION, PERIOD_TYPE_CODE PERIOD_TYPE_CODE, USAGE_CODE USAGE_CODE, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, PAYMENT_AMOUNT PAYMENT_AMOUNT, TRX_GROUP_CODE TRX_GROUP_CODE, CUMULATIVE_FLAG CUMULATIVE_FLAG, ITD_FLAG ITD_FLAG, SPLIT_FLAG SPLIT_FLAG, QUOTA_UNSPECIFIED QUOTA_UNSPECIFIED, START_PERIOD_ID START_PERIOD_ID, END_PERIOD_ID END_PERIOD_ID, START_NUM START_NUM, END_NUM END_NUM, INCREMENTAL_TYPE INCREMENTAL_TYPE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, START_DATE START_DATE, END_DATE END_DATE, INCENTIVE_TYPE_CODE INCENTIVE_TYPE_CODE, CREDIT_TYPE_ID CREDIT_TYPE_ID, BONUS_CREDIT_TYPE_ID BONUS_CREDIT_TYPE_ID, INTERVAL_TYPE_ID INTERVAL_TYPE_ID, CALC_FORMULA_ID CALC_FORMULA_ID, RT_SCHED_CUSTOM_FLAG RT_SCHED_CUSTOM_FLAG, PAYEE_ASSIGN_FLAG PAYEE_ASSIGN_FLAG, VESTING_FLAG VESTING_FLAG, PERFORMANCE_GOAL PERFORMANCE_GOAL, QUOTA_STATUS QUOTA_STATUS, PACKAGE_NAME PACKAGE_NAME, ADDUP_FROM_REV_CLASS_FLAG ADDUP_FROM_REV_CLASS_FLAG, LIABILITY_ACCOUNT_ID LIABILITY_ACCOUNT_ID, EXPENSE_ACCOUNT_ID EXPENSE_ACCOUNT_ID, QUOTA_GROUP_CODE QUOTA_GROUP_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, DELETE_FLAG DELETE_FLAG, PAYMENT_GROUP_CODE PAYMENT_GROUP_CODE, INDIRECT_CREDIT INDIRECT_CREDIT, SALESREPS_ENDDATED_FLAG SALESREPS_ENDDATED_FLAG from "CN"."CN_QUOTAS_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, QUOTA_ID QUOTA_ID
, NAME NAME
, RATE_SCHEDULE_ID RATE_SCHEDULE_ID
, DISC_RATE_SCHEDULE_ID DISC_RATE_SCHEDULE_ID
, QUOTA_TYPE_CODE QUOTA_TYPE_CODE
, DISCOUNT_OPTION_CODE DISCOUNT_OPTION_CODE
, TARGET TARGET
, DESCRIPTION DESCRIPTION
, PERIOD_TYPE_CODE PERIOD_TYPE_CODE
, USAGE_CODE USAGE_CODE
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, TRX_GROUP_CODE TRX_GROUP_CODE
, CUMULATIVE_FLAG CUMULATIVE_FLAG
, ITD_FLAG ITD_FLAG
, SPLIT_FLAG SPLIT_FLAG
, QUOTA_UNSPECIFIED QUOTA_UNSPECIFIED
, START_PERIOD_ID START_PERIOD_ID
, END_PERIOD_ID END_PERIOD_ID
, START_NUM START_NUM
, END_NUM END_NUM
, INCREMENTAL_TYPE INCREMENTAL_TYPE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, START_DATE START_DATE
, END_DATE END_DATE
, INCENTIVE_TYPE_CODE INCENTIVE_TYPE_CODE
, CREDIT_TYPE_ID CREDIT_TYPE_ID
, BONUS_CREDIT_TYPE_ID BONUS_CREDIT_TYPE_ID
, INTERVAL_TYPE_ID INTERVAL_TYPE_ID
, CALC_FORMULA_ID CALC_FORMULA_ID
, RT_SCHED_CUSTOM_FLAG RT_SCHED_CUSTOM_FLAG
, PAYEE_ASSIGN_FLAG PAYEE_ASSIGN_FLAG
, VESTING_FLAG VESTING_FLAG
, PERFORMANCE_GOAL PERFORMANCE_GOAL
, QUOTA_STATUS QUOTA_STATUS
, PACKAGE_NAME PACKAGE_NAME
, ADDUP_FROM_REV_CLASS_FLAG ADDUP_FROM_REV_CLASS_FLAG
, LIABILITY_ACCOUNT_ID LIABILITY_ACCOUNT_ID
, EXPENSE_ACCOUNT_ID EXPENSE_ACCOUNT_ID
, QUOTA_GROUP_CODE QUOTA_GROUP_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, DELETE_FLAG DELETE_FLAG
, PAYMENT_GROUP_CODE PAYMENT_GROUP_CODE
, INDIRECT_CREDIT INDIRECT_CREDIT
, SALESREPS_ENDDATED_FLAG SALESREPS_ENDDATED_FLAG
FROM "CN"."CN_QUOTAS_ALL"