VIEW: APPS.OKS_COVERED_LEVEL_V

Source

View Text - Preformatted

SELECT mtl.name NAME ,kl.start_date START_DATE ,kl.end_date END_DATE ,kl.sts_code STS_CODE ,'A' covlvl ,kl.dnz_chr_id DNZ_CHR_ID ,kl.id CLE_ID ,kh.id ID from okc_k_lines_b kl ,okc_k_items item ,okc_k_headers_b kh ,okx_system_items_v mtl WHERE kl.lse_id in (1,19) And item.cle_id = kl.id And mtl.id1 = item.object1_id1 And kh.id = kl.dnz_chr_id and kl.cle_id Is Null And mtl.organization_id = kh.inv_organization_id

View Text - HTML Formatted

SELECT MTL.NAME NAME
, KL.START_DATE START_DATE
, KL.END_DATE END_DATE
, KL.STS_CODE STS_CODE
, 'A' COVLVL
, KL.DNZ_CHR_ID DNZ_CHR_ID
, KL.ID CLE_ID
, KH.ID ID
FROM OKC_K_LINES_B KL
, OKC_K_ITEMS ITEM
, OKC_K_HEADERS_B KH
, OKX_SYSTEM_ITEMS_V MTL
WHERE KL.LSE_ID IN (1
, 19)
AND ITEM.CLE_ID = KL.ID
AND MTL.ID1 = ITEM.OBJECT1_ID1
AND KH.ID = KL.DNZ_CHR_ID
AND KL.CLE_ID IS NULL
AND MTL.ORGANIZATION_ID = KH.INV_ORGANIZATION_ID