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
819: OKL_STRM_TYPE_B STREAM_TYPE,
820: OKL_SIF_RET_STRMS RETURN_STREAMS,
821: OKL_SIF_RETS RETURN_HEADER,
822: OKL_STREAM_INTERFACES HEADER,
823: OKL_SIF_LINES LINES,
824: OKL_SIF_FEES FEES
825: WHERE
826: RETURN_HEADER.transaction_number = p_trx_number
827: AND
869: OKL_STRM_TYPE_B STREAM_TYPE,
870: OKL_SIF_RET_STRMS RETURN_STREAMS,
871: OKL_SIF_RETS RETURN_HEADER,
872: OKL_STREAM_INTERFACES HEADER,
873: OKL_SIF_LINES LINES,
874: OKL_SIF_FEES FEES
875: WHERE
876: RETURN_HEADER.transaction_number = p_trx_number
877: AND
2724: SRLB.FIRST_PAYMENT_DATE,
2725: SIFB.KHR_ID,
2726: SILB.KLE_ID
2727: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,
2728: OKL_SIF_LINES SILB
2729: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
2730: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
2731: AND SILB.SIF_ID = SIFB.ID
2732: AND SRLB.SIR_ID = SIRB.ID
3242: SILB.KLE_ID,
3243: SIFB.ID SIF_ID,
3244: SILB.ID SIL_ID
3245: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,
3246: OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB
3247: WHERE SRLB.SIR_ID = p_sir_id
3248: AND SIFB.TRANSACTION_NUMBER = p_trx_number
3249: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
3250: AND SILB.SIF_ID = SIFB.ID