[Home] [Help]
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,
679: OKL_SIF_FEES FEES
680: WHERE
681: RETURN_HEADER.transaction_number = p_trx_number
682: AND
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,
733: OKL_SIF_FEES FEES
734: WHERE
735: RETURN_HEADER.transaction_number = p_trx_number
736: AND
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
779: WHERE
780: RETURN_HEADER.transaction_number = p_trx_number
781: AND
782: HEADER.transaction_number = p_trx_number
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,
821: OKL_SIF_FEES FEES
822: WHERE
823: RETURN_HEADER.transaction_number = p_trx_number
824: AND
2671: SRLB.FIRST_PAYMENT_DATE,
2672: SIFB.KHR_ID,
2673: SILB.KLE_ID
2674: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,
2675: OKL_SIF_LINES SILB
2676: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
2677: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
2678: AND SILB.SIF_ID = SIFB.ID
2679: AND SRLB.SIR_ID = SIRB.ID
3185: SRLB.STREAM_INTERFACE_ATTRIBUTE15,
3186: SIFB.KHR_ID,
3187: SILB.KLE_ID
3188: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,
3189: OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB
3190: WHERE SRLB.SIR_ID = p_sir_id
3191: AND SIFB.TRANSACTION_NUMBER = p_trx_number
3192: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
3193: AND SILB.SIF_ID = SIFB.ID