VIEW: CRP.CRP_CAPACITY_PLANS#

Source

View Text - Preformatted

select QUERY_ID QUERY_ID, 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, ORGANIZATION_ID ORGANIZATION_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, LINE_ID LINE_ID, TYPE_ID TYPE_ID, TYPE_TEXT TYPE_TEXT, PERIOD1 PERIOD1, PERIOD2 PERIOD2, PERIOD3 PERIOD3, PERIOD4 PERIOD4, PERIOD5 PERIOD5, PERIOD6 PERIOD6, PERIOD7 PERIOD7, PERIOD8 PERIOD8, PERIOD9 PERIOD9, PERIOD10 PERIOD10, PERIOD11 PERIOD11, PERIOD12 PERIOD12, PERIOD13 PERIOD13, PERIOD14 PERIOD14, PERIOD15 PERIOD15, PERIOD16 PERIOD16, PERIOD17 PERIOD17, PERIOD18 PERIOD18, PERIOD19 PERIOD19, PERIOD20 PERIOD20, PERIOD21 PERIOD21, PERIOD22 PERIOD22, PERIOD23 PERIOD23, PERIOD24 PERIOD24, PERIOD25 PERIOD25, PERIOD26 PERIOD26, PERIOD27 PERIOD27, PERIOD28 PERIOD28, PERIOD29 PERIOD29, PERIOD30 PERIOD30, PERIOD31 PERIOD31, PERIOD32 PERIOD32, PERIOD33 PERIOD33, PERIOD34 PERIOD34, PERIOD35 PERIOD35, PERIOD36 PERIOD36, DEPARTMENT_CLASS DEPARTMENT_CLASS, RESOURCE_TYPE RESOURCE_TYPE, DEPARTMENT_NAME DEPARTMENT_NAME, RESOURCE_NAME RESOURCE_NAME, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME, LINE_NAME LINE_NAME, BILL_OF_RESOURCE BILL_OF_RESOURCE, SIMULATION_SET SIMULATION_SET, DESIGNATOR DESIGNATOR from "CRP"."CRP_CAPACITY_PLANS"

View Text - HTML Formatted

SELECT QUERY_ID QUERY_ID
, 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
, ORGANIZATION_ID ORGANIZATION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, LINE_ID LINE_ID
, TYPE_ID TYPE_ID
, TYPE_TEXT TYPE_TEXT
, PERIOD1 PERIOD1
, PERIOD2 PERIOD2
, PERIOD3 PERIOD3
, PERIOD4 PERIOD4
, PERIOD5 PERIOD5
, PERIOD6 PERIOD6
, PERIOD7 PERIOD7
, PERIOD8 PERIOD8
, PERIOD9 PERIOD9
, PERIOD10 PERIOD10
, PERIOD11 PERIOD11
, PERIOD12 PERIOD12
, PERIOD13 PERIOD13
, PERIOD14 PERIOD14
, PERIOD15 PERIOD15
, PERIOD16 PERIOD16
, PERIOD17 PERIOD17
, PERIOD18 PERIOD18
, PERIOD19 PERIOD19
, PERIOD20 PERIOD20
, PERIOD21 PERIOD21
, PERIOD22 PERIOD22
, PERIOD23 PERIOD23
, PERIOD24 PERIOD24
, PERIOD25 PERIOD25
, PERIOD26 PERIOD26
, PERIOD27 PERIOD27
, PERIOD28 PERIOD28
, PERIOD29 PERIOD29
, PERIOD30 PERIOD30
, PERIOD31 PERIOD31
, PERIOD32 PERIOD32
, PERIOD33 PERIOD33
, PERIOD34 PERIOD34
, PERIOD35 PERIOD35
, PERIOD36 PERIOD36
, DEPARTMENT_CLASS DEPARTMENT_CLASS
, RESOURCE_TYPE RESOURCE_TYPE
, DEPARTMENT_NAME DEPARTMENT_NAME
, RESOURCE_NAME RESOURCE_NAME
, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME
, LINE_NAME LINE_NAME
, BILL_OF_RESOURCE BILL_OF_RESOURCE
, SIMULATION_SET SIMULATION_SET
, DESIGNATOR DESIGNATOR
FROM "CRP"."CRP_CAPACITY_PLANS"