[Home] [Help]
View: PAY_ORG_PAYMENT_METHODS_D
View Text
SELECT PAYORG.ORG_PAYMENT_METHOD_ID
, PAYORG.EFFECTIVE_START_DATE
, PAYORG.EFFECTIVE_END_DATE
, PTYPETL.PAYMENT_TYPE_NAME
, PAYORGTL.ORG_PAYMENT_METHOD_NAME
, PAYORG.LAST_UPDATE_DATE
, FUSER.USER_NAME
, PAYORG.ORG_PAYMENT_METHOD_NAME SYSTEM_ORG_PAY_METHOD_NAME
FROM PAY_ORG_PAYMENT_METHODS_F PAYORG
, PAY_PAYMENT_TYPES PTYPE
, PAY_ORG_PAYMENT_METHODS_F_TL PAYORGTL
, PAY_PAYMENT_TYPES_TL PTYPETL
, FND_USER FUSER
WHERE PAYORG.ORG_PAYMENT_METHOD_ID = PAYORGTL.ORG_PAYMENT_METHOD_ID
AND PAYORGTL.LANGUAGE = USERENV('LANG')
AND PTYPE.PAYMENT_TYPE_ID = PTYPETL.PAYMENT_TYPE_ID
AND PTYPETL.LANGUAGE = USERENV('LANG')
AND PTYPE.PAYMENT_TYPE_ID = PAYORG.PAYMENT_TYPE_ID
AND FUSER.USER_ID (+)= PAYORG.LAST_UPDATED_BY
Columns
Name |
ORG_PAYMENT_METHOD_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
TYPE |
NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
SYSTEM_ORG_PAY_METHOD_NAME |