664: ,CSI_SYSTEMS_B CSISYS
665: ,OKC_K_LINES_TL OKCLINTL
666: ,OKS_K_LINES_B OKSLINB
667: ,OKS_K_LINES_TL OKSLINTL
668: ,okc_k_lines_b okclinb_line
669: ,OKC_K_LINES_B OKCLINB_subline
670:
671: WHERE LININT.HEADER_INTERFACE_ID = HDRINT.HEADER_INTERFACE_ID
672:
665: ,OKC_K_LINES_TL OKCLINTL
666: ,OKS_K_LINES_B OKSLINB
667: ,OKS_K_LINES_TL OKSLINTL
668: ,okc_k_lines_b okclinb_line
669: ,OKC_K_LINES_B OKCLINB_subline
670:
671: WHERE LININT.HEADER_INTERFACE_ID = HDRINT.HEADER_INTERFACE_ID
672:
673: and OKCLINB_subline.dnz_chr_id = okchdrb.id
751: ,OKC_K_HEADERS_ALL_B OKCHDRB
752: ,OKS_HEADERS_INTERFACE HDRINT
753: ,OKC_K_LINES_TL OKCLINTL
754: ,OKS_K_LINES_TL OKSLINTL
755: ,OKC_K_LINES_B OKCLINB_LINE
756: ,OKC_K_LINES_B OKCLINB_SUBLINE
757: ,okc_k_items okcitm
758: WHERE HDRINT.HEADER_INTERFACE_ID = LININT.HEADER_INTERFACE_ID
759: AND LININT.LINE_TYPE = 'USAGE'
752: ,OKS_HEADERS_INTERFACE HDRINT
753: ,OKC_K_LINES_TL OKCLINTL
754: ,OKS_K_LINES_TL OKSLINTL
755: ,OKC_K_LINES_B OKCLINB_LINE
756: ,OKC_K_LINES_B OKCLINB_SUBLINE
757: ,okc_k_items okcitm
758: WHERE HDRINT.HEADER_INTERFACE_ID = LININT.HEADER_INTERFACE_ID
759: AND LININT.LINE_TYPE = 'USAGE'
760: AND LININT.LINE_NUMBER= OKCLINB_LINE.LINE_NUMBER
842: FROM JTF_NOTES_B JTFNTB
843: ,JTF_NOTES_TL JTFNTL
844: ,OKS_HEADERS_INTERFACE HDRINT
845: ,OKC_K_HEADERS_ALL_B OKCHDRB
846: ,OKC_K_LINES_B OKCLINB
847: ,OKS_LINES_INTERFACE LININT
848:
849: WHERE LININT.HEADER_INTERFACE_ID = HDRINT.HEADER_INTERFACE_ID
850: AND JTFNTB.SOURCE_OBJECT_CODE = 'OKS_COV_NOTE'