VIEW: APPS.OKS_K_DETAIL_V

Source

View Text - Preformatted

SELECT kh.contract_number CONTRACT_NUMBER ,kh.start_date START_DATE ,kh.end_date END_DATE ,kd.id id ,kd.order_line_id1 order_line_id1 ,kd.chr_id CHR_ID ,kd.cle_id CLE_ID ,kd.object_version_number from okc_k_headers_v kh ,oks_k_order_details_v kd WHERE kd.link_chr_id = kh.id

View Text - HTML Formatted

SELECT KH.CONTRACT_NUMBER CONTRACT_NUMBER
, KH.START_DATE START_DATE
, KH.END_DATE END_DATE
, KD.ID ID
, KD.ORDER_LINE_ID1 ORDER_LINE_ID1
, KD.CHR_ID CHR_ID
, KD.CLE_ID CLE_ID
, KD.OBJECT_VERSION_NUMBER
FROM OKC_K_HEADERS_V KH
, OKS_K_ORDER_DETAILS_V KD
WHERE KD.LINK_CHR_ID = KH.ID