[Home] [Help]
View: IBY_CREDITCARD_ISSUERS_V
View Text
SELECT B.ROWID ROW_ID
, B.CARD_ISSUER_ACCEPTED_FLAG
, B.AUTHORIZATION_VALIDITY_PERIOD
, B.DIGIT_CHECK_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.CARD_ISSUER_CODE
, T.CARD_ISSUER_NAME
, T.DESCRIPTION
FROM IBY_CREDITCARD_ISSUERS_TL T
, IBY_CREDITCARD_ISSUERS_B B
WHERE B.CARD_ISSUER_CODE = T.CARD_ISSUER_CODE
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
CARD_ISSUER_ACCEPTED_FLAG |
AUTHORIZATION_VALIDITY_PERIOD |
DIGIT_CHECK_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
OBJECT_VERSION_NUMBER |
CARD_ISSUER_CODE |
CARD_ISSUER_NAME |
DESCRIPTION |