[Home] [Help] [Dependency Information]
Object Name: | FLM_EKB_HORIZONTAL_PLAN_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | FLM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANNING_TEMP_ID | NUMBER | |||
KANBAN_PLAN_ID | NUMBER | |||
PULL_SEQUENCE_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
LOCATOR_ID | NUMBER | |||
PLAN_DATE | DATE | |||
BEGINNING_ONHAND | NUMBER | |||
EXPECTED_RECEIPTS | NUMBER | |||
DAILY_DEMAND | NUMBER | |||
ADJUSTED_DAILY_DEMAND | NUMBER | |||
AVAILABLE_ONHAND | NUMBER | |||
CARDS_ONHAND | NUMBER | |||
CARDS_REPLENISHED | NUMBER | |||
SAFETY_STOCK_DAYS | NUMBER | |||
ADJUSTED_SAFETY_STOCK_DAYS | NUMBER | |||
SAFETY_STOCK_TARGET | NUMBER | |||
ITEM_UNIT_COST | NUMBER | |||
INVENTORY_VALUE | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATED_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PLANNING_TEMP_ID
, KANBAN_PLAN_ID
, PULL_SEQUENCE_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, PLAN_DATE
, BEGINNING_ONHAND
, EXPECTED_RECEIPTS
, DAILY_DEMAND
, ADJUSTED_DAILY_DEMAND
, AVAILABLE_ONHAND
, CARDS_ONHAND
, CARDS_REPLENISHED
, SAFETY_STOCK_DAYS
, ADJUSTED_SAFETY_STOCK_DAYS
, SAFETY_STOCK_TARGET
, ITEM_UNIT_COST
, INVENTORY_VALUE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_LOGIN
FROM FLM.FLM_EKB_HORIZONTAL_PLAN_TEMP#;
|
|
|