[Home] [Help]
View: PAY_PAYMENT_TYPES_VL
View Text
SELECT B.ROWID ROW_ID
, B.PAYMENT_TYPE_ID
, B.TERRITORY_CODE
, B.CURRENCY_CODE
, B.CATEGORY
, T.PAYMENT_TYPE_NAME
, B.ALLOW_AS_DEFAULT
, T.DESCRIPTION
, B.PRE_VALIDATION_REQUIRED
, B.PROCEDURE_NAME
, B.VALIDATION_DAYS
, B.VALIDATION_VALUE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.RECONCILIATION_FUNCTION
FROM PAY_PAYMENT_TYPES B
, PAY_PAYMENT_TYPES_TL T
WHERE B.PAYMENT_TYPE_ID = T.PAYMENT_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
PAYMENT_TYPE_ID |
TERRITORY_CODE |
CURRENCY_CODE |
CATEGORY |
PAYMENT_TYPE_NAME |
ALLOW_AS_DEFAULT |
DESCRIPTION |
PRE_VALIDATION_REQUIRED |
PROCEDURE_NAME |
VALIDATION_DAYS |
VALIDATION_VALUE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
RECONCILIATION_FUNCTION |