[Home] [Help] [Dependency Information]
Object Name: | MRP_WEB_HORIZONTAL_PLAN_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_WEB_HORIZONTAL_PLAN_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
This view is used by the Planning Web Inquiries to display the
horizontal plan information for a plan and is based on
MRP_MATERIAL_PLANS.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization identifier | ||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | MPS, MRP or DRP plan identifier | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
PLAN_ORGANIZATION_ID | NUMBER | Organization identifier of the plan | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
ITEM_SEGMENTS | VARCHAR2 | (255) | Item segments | |
HORIZONTAL_PLAN_TYPE | NUMBER | Horizontal plan type | ||
HORIZONTAL_PLAN_TYPE_TEXT | VARCHAR2 | (80) | Horizontal plan type text | |
COLUMN1 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN2 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN3 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN4 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN5 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN6 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN7 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN8 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN9 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN10 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN11 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN12 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN13 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN14 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN15 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN16 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN17 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN18 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN19 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN20 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN21 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN22 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN23 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN24 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN25 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN26 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN27 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN28 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN29 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN30 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN31 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN32 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN33 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN34 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN35 | VARCHAR2 | (40) | Generic Quantity Column | |
COLUMN36 | VARCHAR2 | (40) | Generic Quantity Column | |
PLANNING_GROUP | VARCHAR2 | (4000) | Planning group | |
PROJECT_ID | NUMBER | Project identifier | ||
TASK_ID | NUMBER | Task identifier | ||
PROJECT_NUMBER | VARCHAR2 | (25) | Project number | |
TASK_NUMBER | VARCHAR2 | (25) | Task number |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, COMPILE_DESIGNATOR
, ORGANIZATION_CODE
, PLAN_ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_SEGMENTS
, HORIZONTAL_PLAN_TYPE
, HORIZONTAL_PLAN_TYPE_TEXT
, COLUMN1
, COLUMN2
, COLUMN3
, COLUMN4
, COLUMN5
, COLUMN6
, COLUMN7
, COLUMN8
, COLUMN9
, COLUMN10
, COLUMN11
, COLUMN12
, COLUMN13
, COLUMN14
, COLUMN15
, COLUMN16
, COLUMN17
, COLUMN18
, COLUMN19
, COLUMN20
, COLUMN21
, COLUMN22
, COLUMN23
, COLUMN24
, COLUMN25
, COLUMN26
, COLUMN27
, COLUMN28
, COLUMN29
, COLUMN30
, COLUMN31
, COLUMN32
, COLUMN33
, COLUMN34
, COLUMN35
, COLUMN36
, PLANNING_GROUP
, PROJECT_ID
, TASK_ID
, PROJECT_NUMBER
, TASK_NUMBER
FROM APPS.MRP_WEB_HORIZONTAL_PLAN_V;
APPS.MRP_WEB_HORIZONTAL_PLAN_V is not referenced by any database object
|
|
|