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: HR.PAY_PAYMENT_COSTS#

Source

View Text - Preformatted


select PAYMENT_COST_ID PAYMENT_COST_ID, ACCOUNT_ID ACCOUNT_ID, ACCOUNT_TYPE ACCOUNT_TYPE, VALUE VALUE, CURRENCY_CODE CURRENCY_CODE, DEBIT_OR_CREDIT DEBIT_OR_CREDIT, ACCOUNTING_DATE ACCOUNTING_DATE, ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID, TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG, SOURCE_TYPE SOURCE_TYPE, SOURCE_ACTION_ID SOURCE_ACTION_ID, PRE_PAYMENT_ID PRE_PAYMENT_ID, ASSIGNMENT_ID ASSIGNMENT_ID, SOURCE_ID SOURCE_ID from "HR"."PAY_PAYMENT_COSTS"

View Text - HTML Formatted

SELECT PAYMENT_COST_ID PAYMENT_COST_ID
, ACCOUNT_ID ACCOUNT_ID
, ACCOUNT_TYPE ACCOUNT_TYPE
, VALUE VALUE
, CURRENCY_CODE CURRENCY_CODE
, DEBIT_OR_CREDIT DEBIT_OR_CREDIT
, ACCOUNTING_DATE ACCOUNTING_DATE
, ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG
, SOURCE_TYPE SOURCE_TYPE
, SOURCE_ACTION_ID SOURCE_ACTION_ID
, PRE_PAYMENT_ID PRE_PAYMENT_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, SOURCE_ID SOURCE_ID
FROM "HR"."PAY_PAYMENT_COSTS"