DBA Data[Home] [Help]

VIEW: PA.PA_ORG_FORECAST_LINES#

Source

View Text - Preformatted

select FORECAST_LINE_ID FORECAST_LINE_ID, FORECAST_ELEMENT_ID FORECAST_ELEMENT_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, BUDGET_VERSION_ID BUDGET_VERSION_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PERIOD_NAME PERIOD_NAME, START_DATE START_DATE, END_DATE END_DATE, QUANTITY QUANTITY, RAW_COST RAW_COST, BURDENED_COST BURDENED_COST, TP_COST_IN TP_COST_IN, TP_COST_OUT TP_COST_OUT, LENT_RESOURCE_COST LENT_RESOURCE_COST, UNASSIGNED_TIME_COST UNASSIGNED_TIME_COST, REVENUE REVENUE, TP_REVENUE_IN TP_REVENUE_IN, TP_REVENUE_OUT TP_REVENUE_OUT, BORROWED_REVENUE BORROWED_REVENUE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_ORG_FORECAST_LINES"
View Text - HTML Formatted

SELECT FORECAST_LINE_ID FORECAST_LINE_ID
, FORECAST_ELEMENT_ID FORECAST_ELEMENT_ID
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PERIOD_NAME PERIOD_NAME
, START_DATE START_DATE
, END_DATE END_DATE
, QUANTITY QUANTITY
, RAW_COST RAW_COST
, BURDENED_COST BURDENED_COST
, TP_COST_IN TP_COST_IN
, TP_COST_OUT TP_COST_OUT
, LENT_RESOURCE_COST LENT_RESOURCE_COST
, UNASSIGNED_TIME_COST UNASSIGNED_TIME_COST
, REVENUE REVENUE
, TP_REVENUE_IN TP_REVENUE_IN
, TP_REVENUE_OUT TP_REVENUE_OUT
, BORROWED_REVENUE BORROWED_REVENUE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PA"."PA_ORG_FORECAST_LINES"