VIEW: PA.PA_FORECAST_ITEM_DETAILS#

Source

View Text - Preformatted

select FORECAST_ITEM_ID FORECAST_ITEM_ID, AMOUNT_TYPE_ID AMOUNT_TYPE_ID, LINE_NUM LINE_NUM, RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE, PERSON_BILLABLE_FLAG PERSON_BILLABLE_FLAG, ITEM_DATE ITEM_DATE, ITEM_UOM ITEM_UOM, ITEM_QUANTITY ITEM_QUANTITY, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PVDR_ACCT_CURR_CODE PVDR_ACCT_CURR_CODE, PVDR_ACCT_AMOUNT PVDR_ACCT_AMOUNT, RCVR_ACCT_CURR_CODE RCVR_ACCT_CURR_CODE, RCVR_ACCT_AMOUNT RCVR_ACCT_AMOUNT, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE, PROJ_AMOUNT PROJ_AMOUNT, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, DENOM_AMOUNT DENOM_AMOUNT, TP_AMOUNT_TYPE TP_AMOUNT_TYPE, BILLABLE_FLAG BILLABLE_FLAG, FORECAST_SUMMARIZED_CODE FORECAST_SUMMARIZED_CODE, UTIL_SUMMARIZED_CODE UTIL_SUMMARIZED_CODE, WORK_TYPE_ID WORK_TYPE_ID, RESOURCE_UTIL_CATEGORY_ID RESOURCE_UTIL_CATEGORY_ID, ORG_UTIL_CATEGORY_ID ORG_UTIL_CATEGORY_ID, RESOURCE_UTIL_WEIGHTED RESOURCE_UTIL_WEIGHTED, ORG_UTIL_WEIGHTED ORG_UTIL_WEIGHTED, PROVISIONAL_FLAG PROVISIONAL_FLAG, REVERSED_FLAG REVERSED_FLAG, NET_ZERO_FLAG NET_ZERO_FLAG, REDUCE_CAPACITY_FLAG REDUCE_CAPACITY_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, CAPACITY_QUANTITY CAPACITY_QUANTITY, OVERCOMMITMENT_QTY OVERCOMMITMENT_QTY, OVERPROVISIONAL_QTY OVERPROVISIONAL_QTY, OVER_PROV_CONF_QTY OVER_PROV_CONF_QTY, CONFIRMED_QTY CONFIRMED_QTY, PROVISIONAL_QTY PROVISIONAL_QTY, JOB_ID JOB_ID, PROJECT_ID PROJECT_ID, RESOURCE_ID RESOURCE_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG from "PA"."PA_FORECAST_ITEM_DETAILS"

View Text - HTML Formatted

SELECT FORECAST_ITEM_ID FORECAST_ITEM_ID
, AMOUNT_TYPE_ID AMOUNT_TYPE_ID
, LINE_NUM LINE_NUM
, RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE
, PERSON_BILLABLE_FLAG PERSON_BILLABLE_FLAG
, ITEM_DATE ITEM_DATE
, ITEM_UOM ITEM_UOM
, ITEM_QUANTITY ITEM_QUANTITY
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PVDR_ACCT_CURR_CODE PVDR_ACCT_CURR_CODE
, PVDR_ACCT_AMOUNT PVDR_ACCT_AMOUNT
, RCVR_ACCT_CURR_CODE RCVR_ACCT_CURR_CODE
, RCVR_ACCT_AMOUNT RCVR_ACCT_AMOUNT
, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE
, PROJ_AMOUNT PROJ_AMOUNT
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, DENOM_AMOUNT DENOM_AMOUNT
, TP_AMOUNT_TYPE TP_AMOUNT_TYPE
, BILLABLE_FLAG BILLABLE_FLAG
, FORECAST_SUMMARIZED_CODE FORECAST_SUMMARIZED_CODE
, UTIL_SUMMARIZED_CODE UTIL_SUMMARIZED_CODE
, WORK_TYPE_ID WORK_TYPE_ID
, RESOURCE_UTIL_CATEGORY_ID RESOURCE_UTIL_CATEGORY_ID
, ORG_UTIL_CATEGORY_ID ORG_UTIL_CATEGORY_ID
, RESOURCE_UTIL_WEIGHTED RESOURCE_UTIL_WEIGHTED
, ORG_UTIL_WEIGHTED ORG_UTIL_WEIGHTED
, PROVISIONAL_FLAG PROVISIONAL_FLAG
, REVERSED_FLAG REVERSED_FLAG
, NET_ZERO_FLAG NET_ZERO_FLAG
, REDUCE_CAPACITY_FLAG REDUCE_CAPACITY_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
, CAPACITY_QUANTITY CAPACITY_QUANTITY
, OVERCOMMITMENT_QTY OVERCOMMITMENT_QTY
, OVERPROVISIONAL_QTY OVERPROVISIONAL_QTY
, OVER_PROV_CONF_QTY OVER_PROV_CONF_QTY
, CONFIRMED_QTY CONFIRMED_QTY
, PROVISIONAL_QTY PROVISIONAL_QTY
, JOB_ID JOB_ID
, PROJECT_ID PROJECT_ID
, RESOURCE_ID RESOURCE_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG
FROM "PA"."PA_FORECAST_ITEM_DETAILS"