DBA Data[Home] [Help]

VIEW: HR.PAY_PRE_PAYMENTS_EFC#

Source

View Text - Preformatted

select PRE_PAYMENT_ID PRE_PAYMENT_ID, EFC_ACTION_ID EFC_ACTION_ID, VALUE VALUE, BASE_CURRENCY_VALUE BASE_CURRENCY_VALUE, PBT_CURRENCY_CODE PBT_CURRENCY_CODE, OPM_CURRENCY_CODE OPM_CURRENCY_CODE, OUTPUT_CURRENCY_CODE OUTPUT_CURRENCY_CODE, CURRENCY_CODE CURRENCY_CODE from "HR"."PAY_PRE_PAYMENTS_EFC"
View Text - HTML Formatted

SELECT PRE_PAYMENT_ID PRE_PAYMENT_ID
, EFC_ACTION_ID EFC_ACTION_ID
, VALUE VALUE
, BASE_CURRENCY_VALUE BASE_CURRENCY_VALUE
, PBT_CURRENCY_CODE PBT_CURRENCY_CODE
, OPM_CURRENCY_CODE OPM_CURRENCY_CODE
, OUTPUT_CURRENCY_CODE OUTPUT_CURRENCY_CODE
, CURRENCY_CODE CURRENCY_CODE
FROM "HR"."PAY_PRE_PAYMENTS_EFC"