[Home] [Help] [Dependency Information]
Object Name: | MRP_KANBAN_DEMAND_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_KANBAN_DEMAND_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 | |
DEMAND_ID | NUMBER | Yes | Demand Identifier | |
KANBAN_PLAN_ID | NUMBER | Yes | Kanban plan identifier | |
KANBAN_DESIGNATOR | VARCHAR2 | (10) | Yes | Kanban plan designator |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
ORGANIZATION | VARCHAR2 | (3) | Organization code | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ITEM | VARCHAR2 | (40) | Item name | |
SUBINVENTORY | VARCHAR2 | (10) | Subinventory name | |
LOCATOR_ID | NUMBER | Locator identifier | ||
LOCATOR | VARCHAR2 | (4000) | Locator name | |
ASSEMBLY_ITEM_ID | NUMBER | Assembly item identifier | ||
ASSEMBLY_ITEM | VARCHAR2 | (40) | Assembly item name | |
ASSEMBLY_ORG_ID | NUMBER | Assembly organization identifier | ||
ASSEMBLY_ORG | VARCHAR2 | (3) | Assembly organization | |
ASSEMBLY_SUBINVENTORY | VARCHAR2 | (10) | Assembly subinventory name | |
ASSEMBLY_LOCATOR_ID | NUMBER | Assembly locator identifier | ||
ASSEMBLY_LOCATOR | VARCHAR2 | (4000) | Assembly locator name | |
DEMAND_DATE | DATE | Demand date | ||
DEMAND_QUANTITY | NUMBER | Demand quantity | ||
ORDER_TYPE | NUMBER | Demand type | ||
ORDER_TYPE_TEXT | VARCHAR2 | (80) | Yes | Demand type text |
PLANNER_CODE | VARCHAR2 | (10) | Identifies the Planner | |
CATEGORY_ID | NUMBER | Category Id of Demanded Item |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, DEMAND_ID
, KANBAN_PLAN_ID
, KANBAN_DESIGNATOR
, ORGANIZATION_ID
, ORGANIZATION
, INVENTORY_ITEM_ID
, ITEM
, SUBINVENTORY
, LOCATOR_ID
, LOCATOR
, ASSEMBLY_ITEM_ID
, ASSEMBLY_ITEM
, ASSEMBLY_ORG_ID
, ASSEMBLY_ORG
, ASSEMBLY_SUBINVENTORY
, ASSEMBLY_LOCATOR_ID
, ASSEMBLY_LOCATOR
, DEMAND_DATE
, DEMAND_QUANTITY
, ORDER_TYPE
, ORDER_TYPE_TEXT
, PLANNER_CODE
, CATEGORY_ID
FROM APPS.MRP_KANBAN_DEMAND_V;
APPS.MRP_KANBAN_DEMAND_V is not referenced by any database object
|
|
|