DBA Data[Home] [Help]

VIEW: APPS.IBY_FNDCPT_ALL_PMT_CHANNELS_V

Source

View Text - Preformatted

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)
View Text - HTML Formatted

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)