VIEW: APPS.CN_SRP_RATE_ASSIGNS_V

Source

View Text - Preformatted

SELECT DISTINCT ra.srp_quota_assign_id, ra.quota_id, ra.rt_quota_asgn_id, trunc(rq.start_date) start_date, trunc(rq.end_date) end_date, rq.calc_formula_id, ra.rate_schedule_id, rs.commission_unit_code, rs.name, lp.meaning type, ra.object_version_number FROM CN_SRP_RATE_ASSIGNS RA, CN_RATE_SCHEDULES RS, CN_LOOKUPS LP, CN_RT_QUOTA_ASGNS RQ WHERE rq.rt_quota_asgn_id = ra.rt_quota_asgn_id AND rs.rate_schedule_id = ra.rate_schedule_id AND lp.lookup_type = 'UNIT_OF_MEASURE' AND lp.lookup_code = rs.commission_unit_code

View Text - HTML Formatted

SELECT DISTINCT RA.SRP_QUOTA_ASSIGN_ID
, RA.QUOTA_ID
, RA.RT_QUOTA_ASGN_ID
, TRUNC(RQ.START_DATE) START_DATE
, TRUNC(RQ.END_DATE) END_DATE
, RQ.CALC_FORMULA_ID
, RA.RATE_SCHEDULE_ID
, RS.COMMISSION_UNIT_CODE
, RS.NAME
, LP.MEANING TYPE
, RA.OBJECT_VERSION_NUMBER
FROM CN_SRP_RATE_ASSIGNS RA
, CN_RATE_SCHEDULES RS
, CN_LOOKUPS LP
, CN_RT_QUOTA_ASGNS RQ
WHERE RQ.RT_QUOTA_ASGN_ID = RA.RT_QUOTA_ASGN_ID
AND RS.RATE_SCHEDULE_ID = RA.RATE_SCHEDULE_ID
AND LP.LOOKUP_TYPE = 'UNIT_OF_MEASURE'
AND LP.LOOKUP_CODE = RS.COMMISSION_UNIT_CODE