VIEW: PA.PA_FI_AMOUNT_DETAILS#

Source

View Text - Preformatted

select FORECAST_ITEM_ID FORECAST_ITEM_ID, LINE_NUM LINE_NUM, ITEM_DATE ITEM_DATE, ITEM_UOM ITEM_UOM, ITEM_QUANTITY ITEM_QUANTITY, REVERSED_FLAG REVERSED_FLAG, NET_ZERO_FLAG NET_ZERO_FLAG, LINE_NUM_REVERSED LINE_NUM_REVERSED, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, COST_TXN_CURRENCY_CODE COST_TXN_CURRENCY_CODE, TXN_RAW_COST TXN_RAW_COST, TXN_BURDENED_COST TXN_BURDENED_COST, REVENUE_TXN_CURRENCY_CODE REVENUE_TXN_CURRENCY_CODE, TXN_REVENUE TXN_REVENUE, TP_TXN_CURRENCY_CODE TP_TXN_CURRENCY_CODE, TXN_TRANSFER_PRICE TXN_TRANSFER_PRICE, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_COST_RATE_DATE PROJECT_COST_RATE_DATE, PROJECT_COST_RATE_TYPE PROJECT_COST_RATE_TYPE, PROJECT_COST_EXCHANGE_RATE PROJECT_COST_EXCHANGE_RATE, PROJECT_RAW_COST PROJECT_RAW_COST, PROJECT_BURDENED_COST PROJECT_BURDENED_COST, PROJECT_REVENUE_RATE_DATE PROJECT_REVENUE_RATE_DATE, PROJECT_REVENUE_RATE_TYPE PROJECT_REVENUE_RATE_TYPE, PROJECT_REVENUE_EXCHANGE_RATE PROJECT_REVENUE_EXCHANGE_RATE, PROJECT_REVENUE PROJECT_REVENUE, PROJECT_TP_RATE_DATE PROJECT_TP_RATE_DATE, PROJECT_TP_RATE_TYPE PROJECT_TP_RATE_TYPE, PROJECT_TP_EXCHANGE_RATE PROJECT_TP_EXCHANGE_RATE, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE, PROJFUNC_RAW_COST PROJFUNC_RAW_COST, PROJFUNC_BURDENED_COST PROJFUNC_BURDENED_COST, PROJFUNC_REVENUE PROJFUNC_REVENUE, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE, EXPFUNC_CURRENCY_CODE EXPFUNC_CURRENCY_CODE, EXPFUNC_COST_RATE_DATE EXPFUNC_COST_RATE_DATE, EXPFUNC_COST_RATE_TYPE EXPFUNC_COST_RATE_TYPE, EXPFUNC_COST_EXCHANGE_RATE EXPFUNC_COST_EXCHANGE_RATE, EXPFUNC_RAW_COST EXPFUNC_RAW_COST, EXPFUNC_BURDENED_COST EXPFUNC_BURDENED_COST, EXPFUNC_TP_RATE_DATE EXPFUNC_TP_RATE_DATE, EXPFUNC_TP_RATE_TYPE EXPFUNC_TP_RATE_TYPE, EXPFUNC_TP_EXCHANGE_RATE EXPFUNC_TP_EXCHANGE_RATE, EXPFUNC_TRANSFER_PRICE EXPFUNC_TRANSFER_PRICE, PROJFUNC_REVENUE_RATE_DATE PROJFUNC_REVENUE_RATE_DATE, PROJFUNC_REVENUE_RATE_TYPE PROJFUNC_REVENUE_RATE_TYPE, PROJFUNC_REVENUE_EXCHANGE_RATE PROJFUNC_REVENUE_EXCHANGE_RATE, PROJFUNC_TP_RATE_DATE PROJFUNC_TP_RATE_DATE, PROJFUNC_TP_RATE_TYPE PROJFUNC_TP_RATE_TYPE, PROJFUNC_TP_EXCHANGE_RATE PROJFUNC_TP_EXCHANGE_RATE from "PA"."PA_FI_AMOUNT_DETAILS"

View Text - HTML Formatted

SELECT FORECAST_ITEM_ID FORECAST_ITEM_ID
, LINE_NUM LINE_NUM
, ITEM_DATE ITEM_DATE
, ITEM_UOM ITEM_UOM
, ITEM_QUANTITY ITEM_QUANTITY
, REVERSED_FLAG REVERSED_FLAG
, NET_ZERO_FLAG NET_ZERO_FLAG
, LINE_NUM_REVERSED LINE_NUM_REVERSED
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, COST_TXN_CURRENCY_CODE COST_TXN_CURRENCY_CODE
, TXN_RAW_COST TXN_RAW_COST
, TXN_BURDENED_COST TXN_BURDENED_COST
, REVENUE_TXN_CURRENCY_CODE REVENUE_TXN_CURRENCY_CODE
, TXN_REVENUE TXN_REVENUE
, TP_TXN_CURRENCY_CODE TP_TXN_CURRENCY_CODE
, TXN_TRANSFER_PRICE TXN_TRANSFER_PRICE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_COST_RATE_DATE PROJECT_COST_RATE_DATE
, PROJECT_COST_RATE_TYPE PROJECT_COST_RATE_TYPE
, PROJECT_COST_EXCHANGE_RATE PROJECT_COST_EXCHANGE_RATE
, PROJECT_RAW_COST PROJECT_RAW_COST
, PROJECT_BURDENED_COST PROJECT_BURDENED_COST
, PROJECT_REVENUE_RATE_DATE PROJECT_REVENUE_RATE_DATE
, PROJECT_REVENUE_RATE_TYPE PROJECT_REVENUE_RATE_TYPE
, PROJECT_REVENUE_EXCHANGE_RATE PROJECT_REVENUE_EXCHANGE_RATE
, PROJECT_REVENUE PROJECT_REVENUE
, PROJECT_TP_RATE_DATE PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE PROJECT_TP_RATE_TYPE
, PROJECT_TP_EXCHANGE_RATE PROJECT_TP_EXCHANGE_RATE
, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, PROJFUNC_RAW_COST PROJFUNC_RAW_COST
, PROJFUNC_BURDENED_COST PROJFUNC_BURDENED_COST
, PROJFUNC_REVENUE PROJFUNC_REVENUE
, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE
, EXPFUNC_CURRENCY_CODE EXPFUNC_CURRENCY_CODE
, EXPFUNC_COST_RATE_DATE EXPFUNC_COST_RATE_DATE
, EXPFUNC_COST_RATE_TYPE EXPFUNC_COST_RATE_TYPE
, EXPFUNC_COST_EXCHANGE_RATE EXPFUNC_COST_EXCHANGE_RATE
, EXPFUNC_RAW_COST EXPFUNC_RAW_COST
, EXPFUNC_BURDENED_COST EXPFUNC_BURDENED_COST
, EXPFUNC_TP_RATE_DATE EXPFUNC_TP_RATE_DATE
, EXPFUNC_TP_RATE_TYPE EXPFUNC_TP_RATE_TYPE
, EXPFUNC_TP_EXCHANGE_RATE EXPFUNC_TP_EXCHANGE_RATE
, EXPFUNC_TRANSFER_PRICE EXPFUNC_TRANSFER_PRICE
, PROJFUNC_REVENUE_RATE_DATE PROJFUNC_REVENUE_RATE_DATE
, PROJFUNC_REVENUE_RATE_TYPE PROJFUNC_REVENUE_RATE_TYPE
, PROJFUNC_REVENUE_EXCHANGE_RATE PROJFUNC_REVENUE_EXCHANGE_RATE
, PROJFUNC_TP_RATE_DATE PROJFUNC_TP_RATE_DATE
, PROJFUNC_TP_RATE_TYPE PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TP_EXCHANGE_RATE PROJFUNC_TP_EXCHANGE_RATE
FROM "PA"."PA_FI_AMOUNT_DETAILS"