[Home] [Help]
VIEW: APPS.CN_SRP_JOB_TITLES
Source
View Text - Preformatted
SELECT srd.SRP_ID, srd.JOB_TITLE_ID, j.NAME JOB_NAME, j.JOB_CODE, srd.JOB_DISCRETION, srd.ORG_CODE, srd.START_DATE, srd.END_DATE FROM cn_job_titles j, cn_srp_role_dtls_v srd WHERE j.JOB_TITLE_ID = srd.JOB_TITLE_ID
View Text - HTML Formatted
SELECT SRD.SRP_ID
, SRD.JOB_TITLE_ID
, J.NAME JOB_NAME
, J.JOB_CODE
, SRD.JOB_DISCRETION
, SRD.ORG_CODE
, SRD.START_DATE
, SRD.END_DATE
FROM CN_JOB_TITLES J
, CN_SRP_ROLE_DTLS_V SRD
WHERE J.JOB_TITLE_ID = SRD.JOB_TITLE_ID