DBA Data[Home] [Help] [Dependency Information]

VIEW: CRP.CRP_CAPACITY_PLANS#

Object Details
Object Name: CRP_CAPACITY_PLANS#
Object Type: VIEW
Owner: CRP
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

CRP.CRP_CAPACITY_PLANS# references the following:

SchemaCRP
TableCRP_CAPACITY_PLANS
CRP.CRP_CAPACITY_PLANS# is referenced by following:

SchemaAPPS
SynonymCRP_CAPACITY_PLANS