VIEW: APPS.OKS_APPROVED_CONTRACTS_V

Source

View Text - Preformatted

SELECT nkitm.object1_id1 customer_product_id, svckline.start_date start_date, svckline.end_date end_date, nhdr.contract_number contract_number, nhdr.contract_number_modifier contract_number_modifier, nhdr.id contract_id from okc_k_items nkitm, okc_k_lines_b svckline, okc_k_lines_b clvlline, okc_k_headers_b nhdr WHERE nhdr.id = svckline.dnz_chr_id and nhdr.scs_code IN ('SERVICE', 'WARRANTY') and svckline.sts_code IN('SIGNED', 'ACTIVE') and svckline.id = clvlline.cle_id and clvlline.lse_id = 25 and clvlline.id = nkitm.cle_id and nkitm.jtot_object1_code = 'OKX_CUSTPROD'

View Text - HTML Formatted

SELECT NKITM.OBJECT1_ID1 CUSTOMER_PRODUCT_ID
, SVCKLINE.START_DATE START_DATE
, SVCKLINE.END_DATE END_DATE
, NHDR.CONTRACT_NUMBER CONTRACT_NUMBER
, NHDR.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, NHDR.ID CONTRACT_ID
FROM OKC_K_ITEMS NKITM
, OKC_K_LINES_B SVCKLINE
, OKC_K_LINES_B CLVLLINE
, OKC_K_HEADERS_B NHDR
WHERE NHDR.ID = SVCKLINE.DNZ_CHR_ID
AND NHDR.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND SVCKLINE.STS_CODE IN('SIGNED'
, 'ACTIVE')
AND SVCKLINE.ID = CLVLLINE.CLE_ID
AND CLVLLINE.LSE_ID = 25
AND CLVLLINE.ID = NKITM.CLE_ID
AND NKITM.JTOT_OBJECT1_CODE = 'OKX_CUSTPROD'