VIEW: PA.PA_FRCST_ITEMS_AR#

Source

View Text - Preformatted

select ASGMT_SYS_STATUS_CODE ASGMT_SYS_STATUS_CODE, ASSIGNMENT_ID ASSIGNMENT_ID, AVAILABILITY_FLAG AVAILABILITY_FLAG, AVAILABILITY_QUANTITY AVAILABILITY_QUANTITY, BORROWED_FLAG BORROWED_FLAG, BURDEN_REJECTION_CODE BURDEN_REJECTION_CODE, CAPACITY_QUANTITY CAPACITY_QUANTITY, CONFIRMED_QTY CONFIRMED_QTY, COST_REJECTION_CODE COST_REJECTION_CODE, COST_TXN_CURRENCY_CODE COST_TXN_CURRENCY_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DELETE_FLAG DELETE_FLAG, ERROR_FLAG ERROR_FLAG, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS, EXPFUNC_BURDENED_COST EXPFUNC_BURDENED_COST, EXPFUNC_CURRENCY_CODE EXPFUNC_CURRENCY_CODE, EXPFUNC_RAW_COST EXPFUNC_RAW_COST, EXPFUNC_TRANSFER_PRICE EXPFUNC_TRANSFER_PRICE, FORECAST_AMT_CALC_FLAG FORECAST_AMT_CALC_FLAG, FORECAST_ITEM_ID FORECAST_ITEM_ID, FORECAST_ITEM_TYPE FORECAST_ITEM_TYPE, GLOBAL_EXP_PERIOD_END_DATE GLOBAL_EXP_PERIOD_END_DATE, ITEM_DATE ITEM_DATE, ITEM_QUANTITY ITEM_QUANTITY, ITEM_UOM ITEM_UOM, JOB_ID JOB_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OTHER_REJECTION_CODE OTHER_REJECTION_CODE, OVERCOMMITMENT_FLAG OVERCOMMITMENT_FLAG, OVERCOMMITMENT_QUANTITY OVERCOMMITMENT_QUANTITY, OVERPROVISIONAL_QTY OVERPROVISIONAL_QTY, OVER_PROV_CONF_QTY OVER_PROV_CONF_QTY, PERSON_ID PERSON_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_BURDENED_COST PROJECT_BURDENED_COST, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_ID PROJECT_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_RAW_COST PROJECT_RAW_COST, PROJECT_REVENUE PROJECT_REVENUE, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS, PROJFUNC_BURDENED_COST PROJFUNC_BURDENED_COST, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_RAW_COST PROJFUNC_RAW_COST, PROJFUNC_REVENUE PROJFUNC_REVENUE, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE, PROVISIONAL_FLAG PROVISIONAL_FLAG, PROVISIONAL_QTY PROVISIONAL_QTY, PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_PROJECT_ID PURGE_PROJECT_ID, PURGE_RELEASE PURGE_RELEASE, PVDR_GL_PERIOD_NAME PVDR_GL_PERIOD_NAME, PVDR_PA_PERIOD_NAME PVDR_PA_PERIOD_NAME, PVDR_PERIOD_SET_NAME PVDR_PERIOD_SET_NAME, RCVR_GL_PERIOD_NAME RCVR_GL_PERIOD_NAME, RCVR_PA_PERIOD_NAME RCVR_PA_PERIOD_NAME, RCVR_PERIOD_SET_NAME RCVR_PERIOD_SET_NAME, REQUEST_ID REQUEST_ID, RESOURCE_ID RESOURCE_ID, REVENUE_TXN_CURRENCY_CODE REVENUE_TXN_CURRENCY_CODE, REV_REJECTION_CODE REV_REJECTION_CODE, TP_AMOUNT_TYPE TP_AMOUNT_TYPE, TP_REJECTION_CODE TP_REJECTION_CODE, TP_TXN_CURRENCY_CODE TP_TXN_CURRENCY_CODE, TXN_BURDENED_COST TXN_BURDENED_COST, TXN_RAW_COST TXN_RAW_COST, TXN_REVENUE TXN_REVENUE, TXN_TRANSFER_PRICE TXN_TRANSFER_PRICE from "PA"."PA_FRCST_ITEMS_AR"

View Text - HTML Formatted

SELECT ASGMT_SYS_STATUS_CODE ASGMT_SYS_STATUS_CODE
, ASSIGNMENT_ID ASSIGNMENT_ID
, AVAILABILITY_FLAG AVAILABILITY_FLAG
, AVAILABILITY_QUANTITY AVAILABILITY_QUANTITY
, BORROWED_FLAG BORROWED_FLAG
, BURDEN_REJECTION_CODE BURDEN_REJECTION_CODE
, CAPACITY_QUANTITY CAPACITY_QUANTITY
, CONFIRMED_QTY CONFIRMED_QTY
, COST_REJECTION_CODE COST_REJECTION_CODE
, COST_TXN_CURRENCY_CODE COST_TXN_CURRENCY_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DELETE_FLAG DELETE_FLAG
, ERROR_FLAG ERROR_FLAG
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS
, EXPFUNC_BURDENED_COST EXPFUNC_BURDENED_COST
, EXPFUNC_CURRENCY_CODE EXPFUNC_CURRENCY_CODE
, EXPFUNC_RAW_COST EXPFUNC_RAW_COST
, EXPFUNC_TRANSFER_PRICE EXPFUNC_TRANSFER_PRICE
, FORECAST_AMT_CALC_FLAG FORECAST_AMT_CALC_FLAG
, FORECAST_ITEM_ID FORECAST_ITEM_ID
, FORECAST_ITEM_TYPE FORECAST_ITEM_TYPE
, GLOBAL_EXP_PERIOD_END_DATE GLOBAL_EXP_PERIOD_END_DATE
, ITEM_DATE ITEM_DATE
, ITEM_QUANTITY ITEM_QUANTITY
, ITEM_UOM ITEM_UOM
, JOB_ID JOB_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OTHER_REJECTION_CODE OTHER_REJECTION_CODE
, OVERCOMMITMENT_FLAG OVERCOMMITMENT_FLAG
, OVERCOMMITMENT_QUANTITY OVERCOMMITMENT_QUANTITY
, OVERPROVISIONAL_QTY OVERPROVISIONAL_QTY
, OVER_PROV_CONF_QTY OVER_PROV_CONF_QTY
, PERSON_ID PERSON_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_BURDENED_COST PROJECT_BURDENED_COST
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_ID PROJECT_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_RAW_COST PROJECT_RAW_COST
, PROJECT_REVENUE PROJECT_REVENUE
, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE
, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS
, PROJFUNC_BURDENED_COST PROJFUNC_BURDENED_COST
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_RAW_COST PROJFUNC_RAW_COST
, PROJFUNC_REVENUE PROJFUNC_REVENUE
, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE
, PROVISIONAL_FLAG PROVISIONAL_FLAG
, PROVISIONAL_QTY PROVISIONAL_QTY
, PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, PURGE_RELEASE PURGE_RELEASE
, PVDR_GL_PERIOD_NAME PVDR_GL_PERIOD_NAME
, PVDR_PA_PERIOD_NAME PVDR_PA_PERIOD_NAME
, PVDR_PERIOD_SET_NAME PVDR_PERIOD_SET_NAME
, RCVR_GL_PERIOD_NAME RCVR_GL_PERIOD_NAME
, RCVR_PA_PERIOD_NAME RCVR_PA_PERIOD_NAME
, RCVR_PERIOD_SET_NAME RCVR_PERIOD_SET_NAME
, REQUEST_ID REQUEST_ID
, RESOURCE_ID RESOURCE_ID
, REVENUE_TXN_CURRENCY_CODE REVENUE_TXN_CURRENCY_CODE
, REV_REJECTION_CODE REV_REJECTION_CODE
, TP_AMOUNT_TYPE TP_AMOUNT_TYPE
, TP_REJECTION_CODE TP_REJECTION_CODE
, TP_TXN_CURRENCY_CODE TP_TXN_CURRENCY_CODE
, TXN_BURDENED_COST TXN_BURDENED_COST
, TXN_RAW_COST TXN_RAW_COST
, TXN_REVENUE TXN_REVENUE
, TXN_TRANSFER_PRICE TXN_TRANSFER_PRICE
FROM "PA"."PA_FRCST_ITEMS_AR"