VIEW: APPS.OKL_FUNDING_CRD_CHECKLISTS_UV

Source

View Text - Preformatted

SELECT clt.ID ,clt.RGP_ID ,gov.dnz_chr_id KHR_ID ,clt.TODO_ITEM_CODE ,clt.TODO_ITEM_MEANING ,clt.MANDATORY_FLAG ,clt.MANDATORY_FLAG_MEANING ,clt.CHECK_OFF ,clt.CHECK_OFF_MEANING ,clt.NOTE FROM OKL_CREDIT_CHECKLISTS_UV CLT,OKC_K_HEADERS_B KHR,OKC_GOVERNANCES GOV WHERE clt.khr_id = khr.id and khr.id = gov.chr_id_referred and khr.sts_code = 'ACTIVE' and khr.scs_code = 'CREDITLINE_CONTRACT'

View Text - HTML Formatted

SELECT CLT.ID
, CLT.RGP_ID
, GOV.DNZ_CHR_ID KHR_ID
, CLT.TODO_ITEM_CODE
, CLT.TODO_ITEM_MEANING
, CLT.MANDATORY_FLAG
, CLT.MANDATORY_FLAG_MEANING
, CLT.CHECK_OFF
, CLT.CHECK_OFF_MEANING
, CLT.NOTE
FROM OKL_CREDIT_CHECKLISTS_UV CLT
, OKC_K_HEADERS_B KHR
, OKC_GOVERNANCES GOV
WHERE CLT.KHR_ID = KHR.ID
AND KHR.ID = GOV.CHR_ID_REFERRED
AND KHR.STS_CODE = 'ACTIVE'
AND KHR.SCS_CODE = 'CREDITLINE_CONTRACT'