[Home] [Help] [Dependency Information]
Object Name: | CRP_CAPACITY_PLANS# |
---|---|
Object Type: | VIEW |
Owner: | CRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
DEPARTMENT_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
LINE_ID | NUMBER | |||
TYPE_ID | NUMBER | |||
TYPE_TEXT | VARCHAR2 | (50) | ||
PERIOD1 | NUMBER | |||
PERIOD2 | NUMBER | |||
PERIOD3 | NUMBER | |||
PERIOD4 | NUMBER | |||
PERIOD5 | NUMBER | |||
PERIOD6 | NUMBER | |||
PERIOD7 | NUMBER | |||
PERIOD8 | NUMBER | |||
PERIOD9 | NUMBER | |||
PERIOD10 | NUMBER | |||
PERIOD11 | NUMBER | |||
PERIOD12 | NUMBER | |||
PERIOD13 | NUMBER | |||
PERIOD14 | NUMBER | |||
PERIOD15 | NUMBER | |||
PERIOD16 | NUMBER | |||
PERIOD17 | NUMBER | |||
PERIOD18 | NUMBER | |||
PERIOD19 | NUMBER | |||
PERIOD20 | NUMBER | |||
PERIOD21 | NUMBER | |||
PERIOD22 | NUMBER | |||
PERIOD23 | NUMBER | |||
PERIOD24 | NUMBER | |||
PERIOD25 | NUMBER | |||
PERIOD26 | NUMBER | |||
PERIOD27 | NUMBER | |||
PERIOD28 | NUMBER | |||
PERIOD29 | NUMBER | |||
PERIOD30 | NUMBER | |||
PERIOD31 | NUMBER | |||
PERIOD32 | NUMBER | |||
PERIOD33 | NUMBER | |||
PERIOD34 | NUMBER | |||
PERIOD35 | NUMBER | |||
PERIOD36 | NUMBER | |||
DEPARTMENT_CLASS | VARCHAR2 | (50) | ||
RESOURCE_TYPE | VARCHAR2 | (80) | ||
DEPARTMENT_NAME | VARCHAR2 | (50) | ||
RESOURCE_NAME | VARCHAR2 | (50) | ||
RESOURCE_GROUP_NAME | VARCHAR2 | (50) | ||
LINE_NAME | VARCHAR2 | (50) | ||
BILL_OF_RESOURCE | VARCHAR2 | (50) | ||
SIMULATION_SET | VARCHAR2 | (50) | ||
DESIGNATOR | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT QUERY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, DEPARTMENT_ID
, RESOURCE_ID
, LINE_ID
, TYPE_ID
, TYPE_TEXT
, PERIOD1
, PERIOD2
, PERIOD3
, PERIOD4
, PERIOD5
, PERIOD6
, PERIOD7
, PERIOD8
, PERIOD9
, PERIOD10
, PERIOD11
, PERIOD12
, PERIOD13
, PERIOD14
, PERIOD15
, PERIOD16
, PERIOD17
, PERIOD18
, PERIOD19
, PERIOD20
, PERIOD21
, PERIOD22
, PERIOD23
, PERIOD24
, PERIOD25
, PERIOD26
, PERIOD27
, PERIOD28
, PERIOD29
, PERIOD30
, PERIOD31
, PERIOD32
, PERIOD33
, PERIOD34
, PERIOD35
, PERIOD36
, DEPARTMENT_CLASS
, RESOURCE_TYPE
, DEPARTMENT_NAME
, RESOURCE_NAME
, RESOURCE_GROUP_NAME
, LINE_NAME
, BILL_OF_RESOURCE
, SIMULATION_SET
, DESIGNATOR
FROM CRP.CRP_CAPACITY_PLANS#;
|
|
|