VIEW: PA.PA_FORECAST_ITEMS#

Source

View Text - Preformatted

select FORECAST_ITEM_ID FORECAST_ITEM_ID, FORECAST_ITEM_TYPE FORECAST_ITEM_TYPE, PROJECT_ORG_ID PROJECT_ORG_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ID PROJECT_ID, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS, PERSON_ID PERSON_ID, RESOURCE_ID RESOURCE_ID, BORROWED_FLAG BORROWED_FLAG, ASSIGNMENT_ID ASSIGNMENT_ID, ITEM_DATE ITEM_DATE, ITEM_UOM ITEM_UOM, ITEM_QUANTITY ITEM_QUANTITY, PVDR_PERIOD_SET_NAME PVDR_PERIOD_SET_NAME, PVDR_PA_PERIOD_NAME PVDR_PA_PERIOD_NAME, PVDR_GL_PERIOD_NAME PVDR_GL_PERIOD_NAME, RCVR_PERIOD_SET_NAME RCVR_PERIOD_SET_NAME, RCVR_PA_PERIOD_NAME RCVR_PA_PERIOD_NAME, RCVR_GL_PERIOD_NAME RCVR_GL_PERIOD_NAME, GLOBAL_EXP_PERIOD_END_DATE GLOBAL_EXP_PERIOD_END_DATE, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS, COST_REJECTION_CODE COST_REJECTION_CODE, REV_REJECTION_CODE REV_REJECTION_CODE, TP_REJECTION_CODE TP_REJECTION_CODE, BURDEN_REJECTION_CODE BURDEN_REJECTION_CODE, OTHER_REJECTION_CODE OTHER_REJECTION_CODE, DELETE_FLAG DELETE_FLAG, ERROR_FLAG ERROR_FLAG, PROVISIONAL_FLAG PROVISIONAL_FLAG, 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, ASGMT_SYS_STATUS_CODE ASGMT_SYS_STATUS_CODE, CAPACITY_QUANTITY CAPACITY_QUANTITY, OVERCOMMITMENT_QUANTITY OVERCOMMITMENT_QUANTITY, AVAILABILITY_QUANTITY AVAILABILITY_QUANTITY, OVERCOMMITMENT_FLAG OVERCOMMITMENT_FLAG, AVAILABILITY_FLAG AVAILABILITY_FLAG, TP_AMOUNT_TYPE TP_AMOUNT_TYPE, FORECAST_AMT_CALC_FLAG FORECAST_AMT_CALC_FLAG, 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_RAW_COST PROJECT_RAW_COST, PROJECT_BURDENED_COST PROJECT_BURDENED_COST, PROJECT_REVENUE PROJECT_REVENUE, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, 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_RAW_COST EXPFUNC_RAW_COST, EXPFUNC_BURDENED_COST EXPFUNC_BURDENED_COST, EXPFUNC_TRANSFER_PRICE EXPFUNC_TRANSFER_PRICE, OVERPROVISIONAL_QTY OVERPROVISIONAL_QTY, OVER_PROV_CONF_QTY OVER_PROV_CONF_QTY, CONFIRMED_QTY CONFIRMED_QTY, PROVISIONAL_QTY PROVISIONAL_QTY, JOB_ID JOB_ID from "PA"."PA_FORECAST_ITEMS"

View Text - HTML Formatted

SELECT FORECAST_ITEM_ID FORECAST_ITEM_ID
, FORECAST_ITEM_TYPE FORECAST_ITEM_TYPE
, PROJECT_ORG_ID PROJECT_ORG_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ID PROJECT_ID
, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS
, PERSON_ID PERSON_ID
, RESOURCE_ID RESOURCE_ID
, BORROWED_FLAG BORROWED_FLAG
, ASSIGNMENT_ID ASSIGNMENT_ID
, ITEM_DATE ITEM_DATE
, ITEM_UOM ITEM_UOM
, ITEM_QUANTITY ITEM_QUANTITY
, PVDR_PERIOD_SET_NAME PVDR_PERIOD_SET_NAME
, PVDR_PA_PERIOD_NAME PVDR_PA_PERIOD_NAME
, PVDR_GL_PERIOD_NAME PVDR_GL_PERIOD_NAME
, RCVR_PERIOD_SET_NAME RCVR_PERIOD_SET_NAME
, RCVR_PA_PERIOD_NAME RCVR_PA_PERIOD_NAME
, RCVR_GL_PERIOD_NAME RCVR_GL_PERIOD_NAME
, GLOBAL_EXP_PERIOD_END_DATE GLOBAL_EXP_PERIOD_END_DATE
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS
, COST_REJECTION_CODE COST_REJECTION_CODE
, REV_REJECTION_CODE REV_REJECTION_CODE
, TP_REJECTION_CODE TP_REJECTION_CODE
, BURDEN_REJECTION_CODE BURDEN_REJECTION_CODE
, OTHER_REJECTION_CODE OTHER_REJECTION_CODE
, DELETE_FLAG DELETE_FLAG
, ERROR_FLAG ERROR_FLAG
, PROVISIONAL_FLAG PROVISIONAL_FLAG
, 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
, ASGMT_SYS_STATUS_CODE ASGMT_SYS_STATUS_CODE
, CAPACITY_QUANTITY CAPACITY_QUANTITY
, OVERCOMMITMENT_QUANTITY OVERCOMMITMENT_QUANTITY
, AVAILABILITY_QUANTITY AVAILABILITY_QUANTITY
, OVERCOMMITMENT_FLAG OVERCOMMITMENT_FLAG
, AVAILABILITY_FLAG AVAILABILITY_FLAG
, TP_AMOUNT_TYPE TP_AMOUNT_TYPE
, FORECAST_AMT_CALC_FLAG FORECAST_AMT_CALC_FLAG
, 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_RAW_COST PROJECT_RAW_COST
, PROJECT_BURDENED_COST PROJECT_BURDENED_COST
, PROJECT_REVENUE PROJECT_REVENUE
, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, 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_RAW_COST EXPFUNC_RAW_COST
, EXPFUNC_BURDENED_COST EXPFUNC_BURDENED_COST
, EXPFUNC_TRANSFER_PRICE EXPFUNC_TRANSFER_PRICE
, OVERPROVISIONAL_QTY OVERPROVISIONAL_QTY
, OVER_PROV_CONF_QTY OVER_PROV_CONF_QTY
, CONFIRMED_QTY CONFIRMED_QTY
, PROVISIONAL_QTY PROVISIONAL_QTY
, JOB_ID JOB_ID
FROM "PA"."PA_FORECAST_ITEMS"