VIEW: PA.PA_FP_TXN_CURRENCIES#

Source

View Text - Preformatted

select FP_TXN_CURRENCY_ID FP_TXN_CURRENCY_ID, PROJ_FP_OPTIONS_ID PROJ_FP_OPTIONS_ID, PROJECT_ID PROJECT_ID, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID, FIN_PLAN_VERSION_ID FIN_PLAN_VERSION_ID, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, DEFAULT_REV_CURR_FLAG DEFAULT_REV_CURR_FLAG, DEFAULT_COST_CURR_FLAG DEFAULT_COST_CURR_FLAG, DEFAULT_ALL_CURR_FLAG DEFAULT_ALL_CURR_FLAG, PROJECT_CURRENCY_FLAG PROJECT_CURRENCY_FLAG, PROJFUNC_CURRENCY_FLAG PROJFUNC_CURRENCY_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROJECT_COST_EXCHANGE_RATE PROJECT_COST_EXCHANGE_RATE, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE from "PA"."PA_FP_TXN_CURRENCIES"

View Text - HTML Formatted

SELECT FP_TXN_CURRENCY_ID FP_TXN_CURRENCY_ID
, PROJ_FP_OPTIONS_ID PROJ_FP_OPTIONS_ID
, PROJECT_ID PROJECT_ID
, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID
, FIN_PLAN_VERSION_ID FIN_PLAN_VERSION_ID
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, DEFAULT_REV_CURR_FLAG DEFAULT_REV_CURR_FLAG
, DEFAULT_COST_CURR_FLAG DEFAULT_COST_CURR_FLAG
, DEFAULT_ALL_CURR_FLAG DEFAULT_ALL_CURR_FLAG
, PROJECT_CURRENCY_FLAG PROJECT_CURRENCY_FLAG
, PROJFUNC_CURRENCY_FLAG PROJFUNC_CURRENCY_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROJECT_COST_EXCHANGE_RATE PROJECT_COST_EXCHANGE_RATE
, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE
, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE
FROM "PA"."PA_FP_TXN_CURRENCIES"