VIEW: EAM.EAM_FORECAST_CEBBA#

Source

View Text - Preformatted

select PERIOD_SET_NAME PERIOD_SET_NAME, PERIOD_NAME PERIOD_NAME, ACCT_PERIOD_ID ACCT_PERIOD_ID, WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_ID ORGANIZATION_ID, OPERATIONS_DEPT_ID OPERATIONS_DEPT_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, MAINT_COST_CATEGORY MAINT_COST_CATEGORY, OWNING_DEPT_ID OWNING_DEPT_ID, ACCT_VALUE ACCT_VALUE, PERIOD_START_DATE PERIOD_START_DATE, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, FORECAST_ID FORECAST_ID, CCID CCID, MFG_COST_ELEMENT_ID MFG_COST_ELEMENT_ID, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM, TXN_TYPE TXN_TYPE from "EAM"."EAM_FORECAST_CEBBA"

View Text - HTML Formatted

SELECT PERIOD_SET_NAME PERIOD_SET_NAME
, PERIOD_NAME PERIOD_NAME
, ACCT_PERIOD_ID ACCT_PERIOD_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, OPERATIONS_DEPT_ID OPERATIONS_DEPT_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, MAINT_COST_CATEGORY MAINT_COST_CATEGORY
, OWNING_DEPT_ID OWNING_DEPT_ID
, ACCT_VALUE ACCT_VALUE
, PERIOD_START_DATE PERIOD_START_DATE
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, FORECAST_ID FORECAST_ID
, CCID CCID
, MFG_COST_ELEMENT_ID MFG_COST_ELEMENT_ID
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
, TXN_TYPE TXN_TYPE
FROM "EAM"."EAM_FORECAST_CEBBA"