[Home] [Help] [Dependency Information]
Object Name: | CRP_CAPACITY_PLANS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CRP.CRP_CAPACITY_PLANS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.CRP_CAPACITY_PLANS_V is not referenced by any database object
|
|
|