VIEW: EAM.EAM_FORECASTS#

Source

View Text - Preformatted

select FORECAST_ID FORECAST_ID, ORGANIZATION_ID ORGANIZATION_ID, TEMPLATE_FLAG TEMPLATE_FLAG, REQUEST_ID REQUEST_ID, FORECAST_NAME FORECAST_NAME, DESCRIPTION DESCRIPTION, PERIOD_FROM PERIOD_FROM, PERIOD_TO PERIOD_TO, PERIOD_SET_NAME_FROM PERIOD_SET_NAME_FROM, FORECAST_TYPE FORECAST_TYPE, ACCOUNT_FROM ACCOUNT_FROM, ACCOUNT_TO ACCOUNT_TO, WIP_ACCT_CLASS_FROM WIP_ACCT_CLASS_FROM, WIP_ACCT_CLASS_TO WIP_ACCT_CLASS_TO, ACTIVITY_FROM ACTIVITY_FROM, ACTIVITY_TO ACTIVITY_TO, DEPARTMENT_FROM DEPARTMENT_FROM, DEPARTMENT_TO DEPARTMENT_TO, PROJECT_FROM PROJECT_FROM, PROJECT_TO PROJECT_TO, ASSET_NUM_FROM ASSET_NUM_FROM, ASSET_NUM_TO ASSET_NUM_TO, ASSET_SERIAL_NUM_FROM ASSET_SERIAL_NUM_FROM, ASSET_SERIAL_NUM_TO ASSET_SERIAL_NUM_TO, ASSET_GROUP_FROM ASSET_GROUP_FROM, ASSET_GROUP_TO ASSET_GROUP_TO, WORK_ORDER_FROM WORK_ORDER_FROM, WORK_ORDER_TO WORK_ORDER_TO, WORK_ORDER_TYPE_FROM WORK_ORDER_TYPE_FROM, WORK_ORDER_TYPE_TO WORK_ORDER_TYPE_TO, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, AREA_FROM AREA_FROM, AREA_TO AREA_TO, SOURCE_TEMPLATE_ID SOURCE_TEMPLATE_ID, PERIOD_SET_NAME_TO PERIOD_SET_NAME_TO, INCLUDE_TRANSACTED INCLUDE_TRANSACTED, COMPLETION_DATE COMPLETION_DATE from "EAM"."EAM_FORECASTS"

View Text - HTML Formatted

SELECT FORECAST_ID FORECAST_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TEMPLATE_FLAG TEMPLATE_FLAG
, REQUEST_ID REQUEST_ID
, FORECAST_NAME FORECAST_NAME
, DESCRIPTION DESCRIPTION
, PERIOD_FROM PERIOD_FROM
, PERIOD_TO PERIOD_TO
, PERIOD_SET_NAME_FROM PERIOD_SET_NAME_FROM
, FORECAST_TYPE FORECAST_TYPE
, ACCOUNT_FROM ACCOUNT_FROM
, ACCOUNT_TO ACCOUNT_TO
, WIP_ACCT_CLASS_FROM WIP_ACCT_CLASS_FROM
, WIP_ACCT_CLASS_TO WIP_ACCT_CLASS_TO
, ACTIVITY_FROM ACTIVITY_FROM
, ACTIVITY_TO ACTIVITY_TO
, DEPARTMENT_FROM DEPARTMENT_FROM
, DEPARTMENT_TO DEPARTMENT_TO
, PROJECT_FROM PROJECT_FROM
, PROJECT_TO PROJECT_TO
, ASSET_NUM_FROM ASSET_NUM_FROM
, ASSET_NUM_TO ASSET_NUM_TO
, ASSET_SERIAL_NUM_FROM ASSET_SERIAL_NUM_FROM
, ASSET_SERIAL_NUM_TO ASSET_SERIAL_NUM_TO
, ASSET_GROUP_FROM ASSET_GROUP_FROM
, ASSET_GROUP_TO ASSET_GROUP_TO
, WORK_ORDER_FROM WORK_ORDER_FROM
, WORK_ORDER_TO WORK_ORDER_TO
, WORK_ORDER_TYPE_FROM WORK_ORDER_TYPE_FROM
, WORK_ORDER_TYPE_TO WORK_ORDER_TYPE_TO
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, AREA_FROM AREA_FROM
, AREA_TO AREA_TO
, SOURCE_TEMPLATE_ID SOURCE_TEMPLATE_ID
, PERIOD_SET_NAME_TO PERIOD_SET_NAME_TO
, INCLUDE_TRANSACTED INCLUDE_TRANSACTED
, COMPLETION_DATE COMPLETION_DATE
FROM "EAM"."EAM_FORECASTS"