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

VIEW: APPS.CRP_CAPACITY_PLANS_V

Object Details
Object Name: CRP_CAPACITY_PLANS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCRP.CRP_CAPACITY_PLANS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
BILL_OF_RESOURCE VARCHAR2 (50)
Bill of resource
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
DEPARTMENT_CLASS VARCHAR2 (50)
Department Class
DEPARTMENT_ID NUMBER

Department identifier
DEPARTMENT_NAME VARCHAR2 (50)
Department name
DESIGNATOR VARCHAR2 (50)
Plan or schedule name
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LINE_ID NUMBER

Line Identifier
LINE_NAME VARCHAR2 (50)
Line name
ORGANIZATION_ID NUMBER

Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
PERIOD1 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
PERIOD2 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
PERIOD3 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
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
QUERY_ID NUMBER
Yes Query Identifier
RESOURCE_ID NUMBER

Resource identifier
RESOURCE_NAME VARCHAR2 (50)
Resource name
RESOURCE_GROUP_NAME VARCHAR2 (50)
Resource Group Name
RESOURCE_TYPE VARCHAR2 (80)
Resource Type
SIMULATION_SET VARCHAR2 (50)
Simulation Set
TYPE_ID NUMBER

Type Identifier
TYPE_TEXT VARCHAR2 (80) Yes Horizontal bucket attribute type
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      BILL_OF_RESOURCE
,      CREATED_BY
,      CREATION_DATE
,      DEPARTMENT_CLASS
,      DEPARTMENT_ID
,      DEPARTMENT_NAME
,      DESIGNATOR
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LINE_ID
,      LINE_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      PERIOD1
,      PERIOD10
,      PERIOD11
,      PERIOD12
,      PERIOD13
,      PERIOD14
,      PERIOD15
,      PERIOD16
,      PERIOD17
,      PERIOD18
,      PERIOD19
,      PERIOD2
,      PERIOD20
,      PERIOD21
,      PERIOD22
,      PERIOD23
,      PERIOD24
,      PERIOD25
,      PERIOD26
,      PERIOD27
,      PERIOD28
,      PERIOD29
,      PERIOD3
,      PERIOD30
,      PERIOD31
,      PERIOD32
,      PERIOD33
,      PERIOD34
,      PERIOD35
,      PERIOD36
,      PERIOD4
,      PERIOD5
,      PERIOD6
,      PERIOD7
,      PERIOD8
,      PERIOD9
,      QUERY_ID
,      RESOURCE_ID
,      RESOURCE_NAME
,      RESOURCE_GROUP_NAME
,      RESOURCE_TYPE
,      SIMULATION_SET
,      TYPE_ID
,      TYPE_TEXT
FROM APPS.CRP_CAPACITY_PLANS_V;

Dependencies

[top of page]

APPS.CRP_CAPACITY_PLANS_V references the following:

SchemaAPPS
SynonymCRP_CAPACITY_PLANS
ViewMFG_LOOKUPS
SynonymMTL_PARAMETERS

APPS.CRP_CAPACITY_PLANS_V is not referenced by any database object