[Home] [Help]
View: PAY_PAYMENT_TYPE_LOV
View Text
SELECT PTTL.PAYMENT_TYPE_NAME
, PT.PAYMENT_TYPE_ID
, PT.TERRITORY_CODE
, TERR.TERRITORY_SHORT_NAME
, PT.CURRENCY_CODE
, PT.CATEGORY
, PT.PAYMENT_TYPE_NAME PMETH_INFORMATION_CATEGORY
FROM PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL PTTL
, FND_TERRITORIES_VL TERR
WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')
AND PT.TERRITORY_CODE = TERR.TERRITORY_CODE(+)
Columns
Name |
PAYMENT_TYPE_NAME |
PAYMENT_TYPE_ID |
TERRITORY_CODE |
TERRITORY_SHORT_NAME |
CURRENCY_CODE |
CATEGORY |
PMETH_INFORMATION_CATEGORY |