VIEW: APPS.CN_SRP_QUOTA_ASSIGNS_V

Source

View Text - Preformatted

SELECT qa.srp_quota_assign_id, qa.srp_plan_assign_id, qa.quota_id, q.name, q.description, q.start_date, q.end_date,q.interval_type_id,it.name, ic.lookup_code,ic.meaning,q.credit_type_id, ct.name, q.payee_assign_flag, q.vesting_flag, qa.target, qa.payment_amount, qa.performance_goal, q.addup_from_rev_class_flag,qa.customized_flag, qa.creation_date , qa.last_update_date ,qa.created_by , qa.last_updated_by , qa.last_update_login , qa.period_target_dist_rule_code, qa.period_target_unit_code, qa.quota_type_code FROM CN_SRP_QUOTA_ASSIGNS QA, CN_QUOTAS_ALL Q, CN_INTERVAL_TYPES_ALL_TL IT, CN_LOOKUPS IC, CN_CREDIT_TYPES_ALL_TL CT WHERE qa.quota_id = q.quota_id AND q.interval_type_id = it.interval_type_id AND q.incentive_type_code = ic.lookup_code AND ic.lookup_type = 'INCENTIVE_TYPE' AND q.credit_type_id = ct.credit_type_id and qa.org_id = it.org_id and it.language = userenv('LANG') and qa.org_id = ct.org_id and ct.language = userenv('LANG')

View Text - HTML Formatted

SELECT QA.SRP_QUOTA_ASSIGN_ID
, QA.SRP_PLAN_ASSIGN_ID
, QA.QUOTA_ID
, Q.NAME
, Q.DESCRIPTION
, Q.START_DATE
, Q.END_DATE
, Q.INTERVAL_TYPE_ID
, IT.NAME
, IC.LOOKUP_CODE
, IC.MEANING
, Q.CREDIT_TYPE_ID
, CT.NAME
, Q.PAYEE_ASSIGN_FLAG
, Q.VESTING_FLAG
, QA.TARGET
, QA.PAYMENT_AMOUNT
, QA.PERFORMANCE_GOAL
, Q.ADDUP_FROM_REV_CLASS_FLAG
, QA.CUSTOMIZED_FLAG
, QA.CREATION_DATE
, QA.LAST_UPDATE_DATE
, QA.CREATED_BY
, QA.LAST_UPDATED_BY
, QA.LAST_UPDATE_LOGIN
, QA.PERIOD_TARGET_DIST_RULE_CODE
, QA.PERIOD_TARGET_UNIT_CODE
, QA.QUOTA_TYPE_CODE
FROM CN_SRP_QUOTA_ASSIGNS QA
, CN_QUOTAS_ALL Q
, CN_INTERVAL_TYPES_ALL_TL IT
, CN_LOOKUPS IC
, CN_CREDIT_TYPES_ALL_TL CT
WHERE QA.QUOTA_ID = Q.QUOTA_ID
AND Q.INTERVAL_TYPE_ID = IT.INTERVAL_TYPE_ID
AND Q.INCENTIVE_TYPE_CODE = IC.LOOKUP_CODE
AND IC.LOOKUP_TYPE = 'INCENTIVE_TYPE'
AND Q.CREDIT_TYPE_ID = CT.CREDIT_TYPE_ID
AND QA.ORG_ID = IT.ORG_ID
AND IT.LANGUAGE = USERENV('LANG')
AND QA.ORG_ID = CT.ORG_ID
AND CT.LANGUAGE = USERENV('LANG')