eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_ORG_PAY_METHOD_USAGES_F_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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