[Home] [Help]
View: PAY_ORG_PAY_METHOD_USAGES_F_V
View Text
SELECT OPU.ROWID ROW_ID
, OPU.ORG_PAY_METHOD_USAGE_ID
, OPU.EFFECTIVE_START_DATE
, OPU.EFFECTIVE_END_DATE
, OPU.PAYROLL_ID
, OPU.ORG_PAYMENT_METHOD_ID
, OPU.LAST_UPDATE_DATE
, OPU.LAST_UPDATED_BY
, OPU.LAST_UPDATE_LOGIN
, OPU.CREATED_BY
, OPU.CREATION_DATE
, OPMTL.ORG_PAYMENT_METHOD_NAME NAME
, PTTL.PAYMENT_TYPE_NAME TYPE
FROM PAY_ORG_PAY_METHOD_USAGES_F OPU
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL PTTL
, FND_SESSIONS SES
WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')
AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
AND OPMTL.LANGUAGE = USERENV('LANG')
AND OPM.ORG_PAYMENT_METHOD_ID = OPU.ORG_PAYMENT_METHOD_ID
AND PT.PAYMENT_TYPE_ID = OPM.PAYMENT_TYPE_ID
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN OPU.EFFECTIVE_START_DATE
AND OPU.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
Columns
Name |
ROW_ID |
ORG_PAY_METHOD_USAGE_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
PAYROLL_ID |
ORG_PAYMENT_METHOD_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
NAME |
TYPE |