[Home] [Help] [Dependency Information]
Object Name: | MRP_MATERIAL_PLANS# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | |
PLAN_ORGANIZATION_ID | NUMBER | |||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
ITEM_SEGMENTS | VARCHAR2 | (255) | ||
HORIZONTAL_PLAN_TYPE | NUMBER | Yes | ||
BUCKET_TYPE | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
HORIZONTAL_PLAN_TYPE_TEXT | VARCHAR2 | (80) | ||
QUANTITY1 | NUMBER | |||
QUANTITY2 | NUMBER | |||
QUANTITY3 | NUMBER | |||
QUANTITY4 | NUMBER | |||
QUANTITY5 | NUMBER | |||
QUANTITY6 | NUMBER | |||
QUANTITY7 | NUMBER | |||
QUANTITY8 | NUMBER | |||
QUANTITY9 | NUMBER | |||
QUANTITY10 | NUMBER | |||
QUANTITY11 | NUMBER | |||
QUANTITY12 | NUMBER | |||
QUANTITY13 | NUMBER | |||
QUANTITY14 | NUMBER | |||
QUANTITY15 | NUMBER | |||
QUANTITY16 | NUMBER | |||
QUANTITY17 | NUMBER | |||
QUANTITY18 | NUMBER | |||
QUANTITY19 | NUMBER | |||
QUANTITY20 | NUMBER | |||
QUANTITY21 | NUMBER | |||
QUANTITY22 | NUMBER | |||
QUANTITY23 | NUMBER | |||
QUANTITY24 | NUMBER | |||
QUANTITY25 | NUMBER | |||
QUANTITY26 | NUMBER | |||
QUANTITY27 | NUMBER | |||
QUANTITY28 | NUMBER | |||
QUANTITY29 | NUMBER | |||
QUANTITY30 | NUMBER | |||
QUANTITY31 | NUMBER | |||
QUANTITY32 | NUMBER | |||
QUANTITY33 | NUMBER | |||
QUANTITY34 | NUMBER | |||
QUANTITY35 | NUMBER | |||
QUANTITY36 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, PLAN_ORGANIZATION_ID
, ORGANIZATION_CODE
, INVENTORY_ITEM_ID
, ITEM_SEGMENTS
, HORIZONTAL_PLAN_TYPE
, BUCKET_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, HORIZONTAL_PLAN_TYPE_TEXT
, QUANTITY1
, QUANTITY2
, QUANTITY3
, QUANTITY4
, QUANTITY5
, QUANTITY6
, QUANTITY7
, QUANTITY8
, QUANTITY9
, QUANTITY10
, QUANTITY11
, QUANTITY12
, QUANTITY13
, QUANTITY14
, QUANTITY15
, QUANTITY16
, QUANTITY17
, QUANTITY18
, QUANTITY19
, QUANTITY20
, QUANTITY21
, QUANTITY22
, QUANTITY23
, QUANTITY24
, QUANTITY25
, QUANTITY26
, QUANTITY27
, QUANTITY28
, QUANTITY29
, QUANTITY30
, QUANTITY31
, QUANTITY32
, QUANTITY33
, QUANTITY34
, QUANTITY35
, QUANTITY36
FROM MRP.MRP_MATERIAL_PLANS#;
|
|
|