VIEW: APPS.CN_SRP_ROLE_DTLS_V

Source

View Text - Preformatted

SELECT srd.SRP_ROLE_ID, sr.SALESREP_ID SRP_ID, srd.JOB_TITLE_ID, sr.ROLE_ID, r.NAME ROLE_NAME, srd.JOB_DISCRETION, srd.ORG_CODE, sr.START_DATE, sr.END_DATE, srd.OVERLAY_FLAG, srd.NON_STD_FLAG, srd.CLUB_ELIGIBLE_FLAG, srd.STATUS, srd.NOTIF_STATUS, srd.FILE_ID, srd.REASON, srd.PLAN_ACTIVATE_STATUS, srd.ROLE_MODEL_ID, srd.PRORATION_OVERRIDE_FLAG, srd.BASE_SRP_ROLE_ID, srd.CNRT_DISPLAY_VERSION FROM cn_roles r,cn_srp_roles sr,cn_srp_role_dtls srd WHERE sr.srp_role_id = srd.srp_role_id AND r.role_id = sr.role_id

View Text - HTML Formatted

SELECT SRD.SRP_ROLE_ID
, SR.SALESREP_ID SRP_ID
, SRD.JOB_TITLE_ID
, SR.ROLE_ID
, R.NAME ROLE_NAME
, SRD.JOB_DISCRETION
, SRD.ORG_CODE
, SR.START_DATE
, SR.END_DATE
, SRD.OVERLAY_FLAG
, SRD.NON_STD_FLAG
, SRD.CLUB_ELIGIBLE_FLAG
, SRD.STATUS
, SRD.NOTIF_STATUS
, SRD.FILE_ID
, SRD.REASON
, SRD.PLAN_ACTIVATE_STATUS
, SRD.ROLE_MODEL_ID
, SRD.PRORATION_OVERRIDE_FLAG
, SRD.BASE_SRP_ROLE_ID
, SRD.CNRT_DISPLAY_VERSION
FROM CN_ROLES R
, CN_SRP_ROLES SR
, CN_SRP_ROLE_DTLS SRD
WHERE SR.SRP_ROLE_ID = SRD.SRP_ROLE_ID
AND R.ROLE_ID = SR.ROLE_ID