929: SRMB.TAG_ATTRIBUTE_VALUE,
930: SRMB.DESCRIPTION
931: FROM
932: OKL_SIF_RETS SIRB,
933: OKL_SIF_RET_ERRORS SRMB
934: WHERE
935: SIRB.TRANSACTION_NUMBER = p_trx_number
936: AND
937: SIRB.ID = SRMB.SIR_ID;
1958: SRMB.TAG_ATTRIBUTE_VALUE,
1959: SRMB.DESCRIPTION
1960: FROM
1961: OKL_SIF_RETS SIRB,
1962: OKL_SIF_RET_ERRORS SRMB
1963: WHERE
1964: SIRB.TRANSACTION_NUMBER = p_trx_number
1965: AND
1966: SIRB.ID = SRMB.SIR_ID;
2096: SELECT
2097: SRMB.ID
2098: FROM
2099: OKL_SIF_RETS SIRB,
2100: OKL_SIF_RET_ERRORS SRMB
2101: WHERE
2102: SIRB.TRANSACTION_NUMBER = p_trx_number
2103: AND
2104: SIRB.ID = SRMB.SIR_ID;