VIEW: APPS.CN_ROLE_DETAILS_V

Source

View Text - Preformatted

SELECT rdtl.role_id, r.name, r.description, rdtl.club_eligible_flag, rdtl.ote, rdtl.rounding_factor, rdtl.attain_schedule_id, rdtl.pro_rating_sch_id, rdtl.plan_level, rdtl.quota_min, rdtl.quota_max, rdtl.reason, rdtl.plan_activate_status, rdtl.attribute_category, rdtl.attribute1, rdtl.attribute2, rdtl.attribute3, rdtl.attribute4, rdtl.attribute5, rdtl.attribute6, rdtl.attribute7, rdtl.attribute8, rdtl.attribute9, rdtl.attribute10, rdtl.attribute11, rdtl.attribute12, rdtl.attribute13, rdtl.attribute14, rdtl.attribute15, rdtl.creation_date, rdtl.created_by, rdtl.last_update_date, rdtl.last_update_login, rdtl.last_updated_by, rdtl.object_version_number FROM cn_role_details rdtl,cn_roles r WHERE r.role_id = rdtl.role_id

View Text - HTML Formatted

SELECT RDTL.ROLE_ID
, R.NAME
, R.DESCRIPTION
, RDTL.CLUB_ELIGIBLE_FLAG
, RDTL.OTE
, RDTL.ROUNDING_FACTOR
, RDTL.ATTAIN_SCHEDULE_ID
, RDTL.PRO_RATING_SCH_ID
, RDTL.PLAN_LEVEL
, RDTL.QUOTA_MIN
, RDTL.QUOTA_MAX
, RDTL.REASON
, RDTL.PLAN_ACTIVATE_STATUS
, RDTL.ATTRIBUTE_CATEGORY
, RDTL.ATTRIBUTE1
, RDTL.ATTRIBUTE2
, RDTL.ATTRIBUTE3
, RDTL.ATTRIBUTE4
, RDTL.ATTRIBUTE5
, RDTL.ATTRIBUTE6
, RDTL.ATTRIBUTE7
, RDTL.ATTRIBUTE8
, RDTL.ATTRIBUTE9
, RDTL.ATTRIBUTE10
, RDTL.ATTRIBUTE11
, RDTL.ATTRIBUTE12
, RDTL.ATTRIBUTE13
, RDTL.ATTRIBUTE14
, RDTL.ATTRIBUTE15
, RDTL.CREATION_DATE
, RDTL.CREATED_BY
, RDTL.LAST_UPDATE_DATE
, RDTL.LAST_UPDATE_LOGIN
, RDTL.LAST_UPDATED_BY
, RDTL.OBJECT_VERSION_NUMBER
FROM CN_ROLE_DETAILS RDTL
, CN_ROLES R
WHERE R.ROLE_ID = RDTL.ROLE_ID