DBA Data[Home] [Help] [Dependency Information]

VIEW: FLM.FLM_EKB_HORIZONTAL_PLAN_TEMP#

Object Details
Object Name: FLM_EKB_HORIZONTAL_PLAN_TEMP#
Object Type: VIEW
Owner: FLM
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

FLM.FLM_EKB_HORIZONTAL_PLAN_TEMP# references the following:

SchemaFLM
TableFLM_EKB_HORIZONTAL_PLAN_TEMP
FLM.FLM_EKB_HORIZONTAL_PLAN_TEMP# is referenced by following:

SchemaAPPS
SynonymFLM_EKB_HORIZONTAL_PLAN_TEMP