FND Design Data [Home] [Help]

View: IBY_FNDCPT_ALL_PMT_CHANNELS_V

Product: IBY - Payments
Description:
Implementation/DBA Data: ViewAPPS.IBY_FNDCPT_ALL_PMT_CHANNELS_V
View Text

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)

Columns

Name
ROW_ID
PAYMENT_CHANNEL_NAME
PAYMENT_CHANNEL_CODE
INSTRUMENT_TYPE