VIEW: APPS.OKL_SEC_BUYBACK_PRODUCTS_UV

Source

View Text - Preformatted

SELECT pdtb.id pdt_id, pdtb.name product, pdtb.from_date pdt_from_date, pdtb.TO_DATE pdt_to_date FROM OKL_PRODUCTS PDTB WHERE pdtb.id IN (SELECT khrb.pdt_id FROM okl_k_headers khrb, okl_pool_contents pocb WHERE khrb.pdt_id = pdtb.id AND pocb.khr_id = khrb.id AND pocb.status_code = 'ACTIVE')

View Text - HTML Formatted

SELECT PDTB.ID PDT_ID
, PDTB.NAME PRODUCT
, PDTB.FROM_DATE PDT_FROM_DATE
, PDTB.TO_DATE PDT_TO_DATE
FROM OKL_PRODUCTS PDTB
WHERE PDTB.ID IN (SELECT KHRB.PDT_ID
FROM OKL_K_HEADERS KHRB
, OKL_POOL_CONTENTS POCB
WHERE KHRB.PDT_ID = PDTB.ID
AND POCB.KHR_ID = KHRB.ID
AND POCB.STATUS_CODE = 'ACTIVE')