IBY_FNDCPT_ALL_PMT_CHANNELS_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
ROW_ID PAYMENT_CHANNEL_NAME PAYMENT_CHANNEL_CODE INSTRUMENT_TYPE

Query

SQL_Statement
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)<SYSDATE