VIEW: APPS.OKS_PRODUCTS_V

Source

View Text - Preformatted

SELECT l.start_date, l.end_date, l.dnz_chr_id contract_id , l.cle_id line_id , l.id product_line_id , l.lse_id, ls.name , it.object1_id1, it.number_of_items , it.uom_code , l.price_negotiated From Okc_k_headers_v k , Okc_k_lines_v l , Okc_line_styles_V ls , Okc_k_items_v it WHERE k.id = l.dnz_chr_id And l.lse_id in (11,25,35) And l.lse_id = ls.id And l.id = it.cle_id

View Text - HTML Formatted

SELECT L.START_DATE
, L.END_DATE
, L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID PRODUCT_LINE_ID
, L.LSE_ID
, LS.NAME
, IT.OBJECT1_ID1
, IT.NUMBER_OF_ITEMS
, IT.UOM_CODE
, L.PRICE_NEGOTIATED
FROM OKC_K_HEADERS_V K
, OKC_K_LINES_V L
, OKC_LINE_STYLES_V LS
, OKC_K_ITEMS_V IT
WHERE K.ID = L.DNZ_CHR_ID
AND L.LSE_ID IN (11
, 25
, 35)
AND L.LSE_ID = LS.ID
AND L.ID = IT.CLE_ID