eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CRP.CRP_CAPACITY_PLANS

Object Details

Object Name:	CRP_CAPACITY_PLANS
Object Type:	TABLE
Owner:	CRP
FND Design Data:	CRP.CRP_CAPACITY_PLANS
Subobject Name:
Status:	VALID

CRP_CAPACITY_PLANS is a table used by the form module CRPFCVCP
for displaying bucketed information on resource availability and
requirement. It is populated at run time by user exits.
Each row stores a type of information about a particular resource.
There are 15 different types of information for resources and 9
different types for assembly lines. For a given resource, there will
be 15 rows of information in the table, each with a different TYPE.
Similarly, for a given LINE, there will be 9 rows of information in
the table.
All of the information is bucketed into 36 weekly buckets. This
bucketed information is stored in the columns PERIOD1 through
PERIOD36.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CRP_CAPACITY_PLANS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUERY_ID ORGANIZATION_ID DEPARTMENT_ID RESOURCE_ID
CRP_CAPACITY_PLANS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUERY_ID ORGANIZATION_ID LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
QUERY_ID	NUMBER		Yes	Query Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ORGANIZATION_ID	NUMBER			Organization identifier
DEPARTMENT_ID	NUMBER			Department identifier
RESOURCE_ID	NUMBER			Resource identifier
LINE_ID	NUMBER			Line Identifier
TYPE_ID	NUMBER			Type Identifier
TYPE_TEXT	VARCHAR2	(50)		Horizontal bucket attribute type
PERIOD1	NUMBER			Generic number column
PERIOD2	NUMBER			Generic number column
PERIOD3	NUMBER			Generic number column
PERIOD4	NUMBER			Generic number column
PERIOD5	NUMBER			Generic number column
PERIOD6	NUMBER			Generic number column
PERIOD7	NUMBER			Generic number column
PERIOD8	NUMBER			Generic number column
PERIOD9	NUMBER			Generic number column
PERIOD10	NUMBER			Generic number column
PERIOD11	NUMBER			Generic number column
PERIOD12	NUMBER			Generic number column
PERIOD13	NUMBER			Generic number column
PERIOD14	NUMBER			Generic number column
PERIOD15	NUMBER			Generic number column
PERIOD16	NUMBER			Generic number column
PERIOD17	NUMBER			Generic number column
PERIOD18	NUMBER			Generic number column
PERIOD19	NUMBER			Generic number column
PERIOD20	NUMBER			Generic number column
PERIOD21	NUMBER			Generic number column
PERIOD22	NUMBER			Generic number column
PERIOD23	NUMBER			Generic number column
PERIOD24	NUMBER			Generic number column
PERIOD25	NUMBER			Generic number column
PERIOD26	NUMBER			Generic number column
PERIOD27	NUMBER			Generic number column
PERIOD28	NUMBER			Generic number column
PERIOD29	NUMBER			Generic number column
PERIOD30	NUMBER			Generic number column
PERIOD31	NUMBER			Generic number column
PERIOD32	NUMBER			Generic number column
PERIOD33	NUMBER			Generic number column
PERIOD34	NUMBER			Generic number column
PERIOD35	NUMBER			Generic number column
PERIOD36	NUMBER			Generic number column
DEPARTMENT_CLASS	VARCHAR2	(50)		Department Class
RESOURCE_TYPE	VARCHAR2	(80)		Resource type
DEPARTMENT_NAME	VARCHAR2	(50)		Department name
RESOURCE_NAME	VARCHAR2	(50)		Resource name
RESOURCE_GROUP_NAME	VARCHAR2	(50)		Resource Group Name
LINE_NAME	VARCHAR2	(50)		Line name
BILL_OF_RESOURCE	VARCHAR2	(50)		Bill of resource
SIMULATION_SET	VARCHAR2	(50)		Simulation Set
DESIGNATOR	VARCHAR2	(50)		Plan or schedule name

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 does not reference any database object

CRP.CRP_CAPACITY_PLANS is referenced by following:

APPS: CRP_CAPACITY_PLANS