127: okc_k_headers_b chr,
128: okc_k_lines_b cle,
129: okc_line_styles_b lse,
130: okc_k_items cim,
131: okl_strm_type_b sty
132: where
133: chr.id = p_khr_id
134: and chr.id = cle.dnz_chr_id
135: and cle.lse_id = lse.id
150: OKC_K_HEADERS_B KHRB,
151: OKC_RULE_GROUPS_B CRGB,
152: OKC_RULES_B CRLB,
153: OKC_K_LINES_V KLIN,
154: OKL_STRM_TYPE_B STYB
155: WHERE
156: KHRB.ID = p_khr_id
157: AND CRGB.DNZ_CHR_ID = KHRB.ID
158: AND CRGB.RGD_CODE = 'LALEVL'
645: TO_NUMBER(NULL) KLE_ID
646: FROM
647: OKL_SIF_RET_STRMS RETURN_STREAMS,
648: OKL_SIF_RETS RETURN_HEADER,
649: OKL_STRM_TYPE_B STREAM_TYPE,
650: OKL_STREAM_INTERFACES HEADER
651: WHERE
652: RETURN_HEADER.id = RETURN_STREAMS.sir_id
653: AND RETURN_HEADER.transaction_number =p_trx_number
670: -- select kle_fee_id as well from the OKL_SIF_FEES table
671: FEES.KLE_ID KLE_ID
672: -- TO_NUMBER(NULL)
673: FROM
674: OKL_STRM_TYPE_B STREAM_TYPE,
675: OKL_SIF_RET_STRMS RETURN_STREAMS,
676: OKL_SIF_RETS RETURN_HEADER,
677: OKL_STREAM_INTERFACES HEADER,
678: -- OKL_SIF_LINES LINES,
724: HEADER.KHR_ID,
725:
726: LINES.KLE_ID KLE_ID
727: FROM
728: OKL_STRM_TYPE_B STREAM_TYPE,
729: OKL_SIF_RET_STRMS RETURN_STREAMS,
730: OKL_SIF_RETS RETURN_HEADER,
731: OKL_STREAM_INTERFACES HEADER,
732: OKL_SIF_LINES LINES,
770: STREAM_TYPE.ID stream_type_id,
771: HEADER.KHR_ID,
772: LINES.KLE_ID KLE_ID
773: FROM
774: OKL_STRM_TYPE_B STREAM_TYPE,
775: OKL_SIF_RET_STRMS RETURN_STREAMS,
776: OKL_SIF_RETS RETURN_HEADER,
777: OKL_STREAM_INTERFACES HEADER,
778: OKL_SIF_LINES LINES
812: HEADER.KHR_ID,
813:
814: LINES.KLE_ID KLE_ID
815: FROM
816: OKL_STRM_TYPE_B STREAM_TYPE,
817: OKL_SIF_RET_STRMS RETURN_STREAMS,
818: OKL_SIF_RETS RETURN_HEADER,
819: OKL_STREAM_INTERFACES HEADER,
820: OKL_SIF_LINES LINES,