[Home] [Help] [Dependency Information]
Object Name: | MRP_KANBAN_COMPARISON_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_KANBAN_COMPARISON_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 | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
KANBAN_PLAN_ID_TO | NUMBER | Yes | Kanban plan identifier for the plan that is compared to | |
PLAN_NAME_TO | VARCHAR2 | (80) | Kanban plan name for the plan that is compared to | |
PLAN_DESCRIPTION_TO | VARCHAR2 | (80) | Kanban plan description for the plan that is compared to | |
INPUT_TYPE_TO | NUMBER | Input type for the plan that is compared to | ||
INPUT_DESIGNATOR_TO | VARCHAR2 | (10) | Input designator for the plan that is compared to | |
KANBAN_PLAN_ID_FROM | NUMBER | Yes | Kanban plan identifier for the compared plan | |
PLAN_NAME_FROM | VARCHAR2 | (10) | Yes | Kanban plan name for the compared plan |
PLAN_DESCRIPTION_FROM | VARCHAR2 | (50) | Kanban plan description for the compared plan | |
INPUT_TYPE_FROM | NUMBER | Yes | Input type for the compared plan | |
INPUT_DESIGNATOR_FROM | VARCHAR2 | (10) | Input designator for the compared plan | |
PULL_SEQUENCE_ID | NUMBER | Yes | Pull sequence identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ITEM | VARCHAR2 | (40) | Item name | |
SUBINVENTORY | VARCHAR2 | (10) | Yes | Subinventory name |
LOCATOR_ID | NUMBER | Locator identifier | ||
LOCATOR | VARCHAR2 | (4000) | Locator name | |
SOURCE_TYPE | NUMBER | Yes | Source type | |
KANBAN_SIZE_TO | NUMBER | Kanban size for the plan that is compared to | ||
NUMBER_OF_CARDS_TO | NUMBER | Number of kanban cards for the plan that is compared to | ||
KANBAN_SIZE_FROM | NUMBER | Kanban size for the compared plan | ||
NUMBER_OF_CARDS_FROM | NUMBER | Number of kanban cards for the compared plan | ||
VARIANCE | NUMBER | Variance between the plans that are compared | ||
PLANNER_CODE | VARCHAR2 | (10) | Identifies the Planner | |
CATEGORY_ID | NUMBER | Category Id of Compared Item | ||
PLANNING_UPDATE_STATUS | NUMBER | Planning Update Status | ||
SOURCE_TYPE_FROM | NUMBER | Yes | Kanban source type for the compared plan | |
SOURCE_ORGANIZATION_ID_FROM | NUMBER | Source organization identifier for the compared plan | ||
SOURCE_SUBINVENTORY_FROM | VARCHAR2 | (10) | Source subinventory name for the compared plan | |
SOURCE_LOCATOR_ID_FROM | NUMBER | Source locator identifier for the compared plan | ||
LINE_ID_FROM | NUMBER | WIP line identifier for the compared plan | ||
SUPPLIER_ID_FROM | NUMBER | Supplier identifier for the compared plan | ||
SUPPLIER_SITE_ID_FROM | NUMBER | Supplier site identifier for the compared plan | ||
CALCULATE_KANBAN_FLAG_FROM | NUMBER | Flag indicating what to calculate for the compared plan | ||
REPLENISHMENT_LEAD_TIME_FROM | NUMBER | Lead time to replenish kanban for the compared plan | ||
RELEASE_KANBAN_FLAG_FROM | NUMBER | Yes | Flag to indicate that Kanban will execute or not for the compared plan | |
MINIMUM_ORDER_QUANTITY_FROM | NUMBER | Minimum order quantity for the compared plan | ||
FIXED_LOT_MULTIPLIER_FROM | NUMBER | Fixed lot multiplier for the compared plan | ||
SAFETY_STOCK_DAYS_FROM | NUMBER | Safety stock days for the compared plan |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORGANIZATION_ID
, KANBAN_PLAN_ID_TO
, PLAN_NAME_TO
, PLAN_DESCRIPTION_TO
, INPUT_TYPE_TO
, INPUT_DESIGNATOR_TO
, KANBAN_PLAN_ID_FROM
, PLAN_NAME_FROM
, PLAN_DESCRIPTION_FROM
, INPUT_TYPE_FROM
, INPUT_DESIGNATOR_FROM
, PULL_SEQUENCE_ID
, INVENTORY_ITEM_ID
, ITEM
, SUBINVENTORY
, LOCATOR_ID
, LOCATOR
, SOURCE_TYPE
, KANBAN_SIZE_TO
, NUMBER_OF_CARDS_TO
, KANBAN_SIZE_FROM
, NUMBER_OF_CARDS_FROM
, VARIANCE
, PLANNER_CODE
, CATEGORY_ID
, PLANNING_UPDATE_STATUS
, SOURCE_TYPE_FROM
, SOURCE_ORGANIZATION_ID_FROM
, SOURCE_SUBINVENTORY_FROM
, SOURCE_LOCATOR_ID_FROM
, LINE_ID_FROM
, SUPPLIER_ID_FROM
, SUPPLIER_SITE_ID_FROM
, CALCULATE_KANBAN_FLAG_FROM
, REPLENISHMENT_LEAD_TIME_FROM
, RELEASE_KANBAN_FLAG_FROM
, MINIMUM_ORDER_QUANTITY_FROM
, FIXED_LOT_MULTIPLIER_FROM
, SAFETY_STOCK_DAYS_FROM
FROM APPS.MRP_KANBAN_COMPARISON_V;
APPS.MRP_KANBAN_COMPARISON_V is not referenced by any database object
|
|
|