VIEW: PA.PA_FRCST_ITEM_DTLS_AR#

Source

View Text - Preformatted

select AMOUNT_TYPE_ID AMOUNT_TYPE_ID, BILLABLE_FLAG BILLABLE_FLAG, CAPACITY_QUANTITY CAPACITY_QUANTITY, CONFIRMED_QTY CONFIRMED_QTY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DENOM_AMOUNT DENOM_AMOUNT, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, FORECAST_ITEM_ID FORECAST_ITEM_ID, FORECAST_SUMMARIZED_CODE FORECAST_SUMMARIZED_CODE, 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, LINE_NUM LINE_NUM, LINE_NUM_REVERSED LINE_NUM_REVERSED, NET_ZERO_FLAG NET_ZERO_FLAG, ORG_UTIL_CATEGORY_ID ORG_UTIL_CATEGORY_ID, ORG_UTIL_WEIGHTED ORG_UTIL_WEIGHTED, OVERCOMMITMENT_QTY OVERCOMMITMENT_QTY, OVERPROVISIONAL_QTY OVERPROVISIONAL_QTY, OVER_PROV_CONF_QTY OVER_PROV_CONF_QTY, PERSON_BILLABLE_FLAG PERSON_BILLABLE_FLAG, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJ_AMOUNT PROJ_AMOUNT, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE, 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_ACCT_AMOUNT PVDR_ACCT_AMOUNT, PVDR_ACCT_CURR_CODE PVDR_ACCT_CURR_CODE, RCVR_ACCT_AMOUNT RCVR_ACCT_AMOUNT, RCVR_ACCT_CURR_CODE RCVR_ACCT_CURR_CODE, REDUCE_CAPACITY_FLAG REDUCE_CAPACITY_FLAG, REQUEST_ID REQUEST_ID, RESOURCE_ID RESOURCE_ID, RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE, RESOURCE_UTIL_CATEGORY_ID RESOURCE_UTIL_CATEGORY_ID, RESOURCE_UTIL_WEIGHTED RESOURCE_UTIL_WEIGHTED, REVERSED_FLAG REVERSED_FLAG, TP_AMOUNT_TYPE TP_AMOUNT_TYPE, UTIL_SUMMARIZED_CODE UTIL_SUMMARIZED_CODE, WORK_TYPE_ID WORK_TYPE_ID from "PA"."PA_FRCST_ITEM_DTLS_AR"

View Text - HTML Formatted

SELECT AMOUNT_TYPE_ID AMOUNT_TYPE_ID
, BILLABLE_FLAG BILLABLE_FLAG
, CAPACITY_QUANTITY CAPACITY_QUANTITY
, CONFIRMED_QTY CONFIRMED_QTY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DENOM_AMOUNT DENOM_AMOUNT
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, FORECAST_ITEM_ID FORECAST_ITEM_ID
, FORECAST_SUMMARIZED_CODE FORECAST_SUMMARIZED_CODE
, 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
, LINE_NUM LINE_NUM
, LINE_NUM_REVERSED LINE_NUM_REVERSED
, NET_ZERO_FLAG NET_ZERO_FLAG
, ORG_UTIL_CATEGORY_ID ORG_UTIL_CATEGORY_ID
, ORG_UTIL_WEIGHTED ORG_UTIL_WEIGHTED
, OVERCOMMITMENT_QTY OVERCOMMITMENT_QTY
, OVERPROVISIONAL_QTY OVERPROVISIONAL_QTY
, OVER_PROV_CONF_QTY OVER_PROV_CONF_QTY
, PERSON_BILLABLE_FLAG PERSON_BILLABLE_FLAG
, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJ_AMOUNT PROJ_AMOUNT
, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE
, 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_ACCT_AMOUNT PVDR_ACCT_AMOUNT
, PVDR_ACCT_CURR_CODE PVDR_ACCT_CURR_CODE
, RCVR_ACCT_AMOUNT RCVR_ACCT_AMOUNT
, RCVR_ACCT_CURR_CODE RCVR_ACCT_CURR_CODE
, REDUCE_CAPACITY_FLAG REDUCE_CAPACITY_FLAG
, REQUEST_ID REQUEST_ID
, RESOURCE_ID RESOURCE_ID
, RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE
, RESOURCE_UTIL_CATEGORY_ID RESOURCE_UTIL_CATEGORY_ID
, RESOURCE_UTIL_WEIGHTED RESOURCE_UTIL_WEIGHTED
, REVERSED_FLAG REVERSED_FLAG
, TP_AMOUNT_TYPE TP_AMOUNT_TYPE
, UTIL_SUMMARIZED_CODE UTIL_SUMMARIZED_CODE
, WORK_TYPE_ID WORK_TYPE_ID
FROM "PA"."PA_FRCST_ITEM_DTLS_AR"