SELECT B.ROWID , T.PAYMENT_CHANNEL_NAME , B.PAYMENT_CHANNEL_CODE , B.INSTRUMENT_TYPE FROM IBY_FNDCPT_PMT_CHNNLS_B B , IBY_FNDCPT_PMT_CHNNLS_TL T WHERE B.PAYMENT_CHANNEL_CODE = T.PAYMENT_CHANNEL_CODE AND T.LANGUAGE = USERENV('LANG') AND NVL(B.INACTIVE_DATE , SYSDATE-10)