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

TABLE: FLM.FLM_EKB_HORIZONTAL_PLAN_TEMP

Object Details
Object Name: FLM_EKB_HORIZONTAL_PLAN_TEMP
Object Type: TABLE
Owner: FLM
FND Design Data: TableFLM.FLM_EKB_HORIZONTAL_PLAN_TEMP
Subobject Name:
Status: VALID


This table stores snapshot information of the Horizontal Plan information for a kanban Pull Sequence.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FLM_EKB_HORIZONTAL_TEMP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLANNING_TEMP_ID
FLM_EKB_HORIZONTAL_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPULL_SEQUENCE_ID
FLM_EKB_HORIZONTAL_TEMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnKANBAN_PLAN_ID
Columns
Name Datatype Length Mandatory Comments
PLANNING_TEMP_ID NUMBER

Planning Record Identifier
KANBAN_PLAN_ID NUMBER

Kanban Plan Identifier
PULL_SEQUENCE_ID NUMBER

Pull Sequence Identifier
ORGANIZATION_ID NUMBER

organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory Code
LOCATOR_ID NUMBER

Locator Identifier
PLAN_DATE DATE

Planning Date
BEGINNING_ONHAND NUMBER

Beginning Onhand
EXPECTED_RECEIPTS NUMBER

Expected Receipt
DAILY_DEMAND NUMBER

Daily Demand
ADJUSTED_DAILY_DEMAND NUMBER

Adjusted Daily Demand
AVAILABLE_ONHAND NUMBER

Available Onhand
CARDS_ONHAND NUMBER

Cards Onhand
CARDS_REPLENISHED NUMBER

Cards Replenished
SAFETY_STOCK_DAYS NUMBER

Safety Stock Days
ADJUSTED_SAFETY_STOCK_DAYS NUMBER

Adjusted Safety Stock
SAFETY_STOCK_TARGET NUMBER

Safety Stock Target
ITEM_UNIT_COST NUMBER

Item Cost
INVENTORY_VALUE NUMBER

Inventory Value
LAST_UPDATE_DATE DATE

Standard WHO COlumn
LAST_UPDATED_BY NUMBER

Standard WHO COlumn
CREATION_DATE DATE

Standard WHO COlumn
CREATED_BY NUMBER

Standard WHO COlumn
LAST_UPDATED_LOGIN NUMBER

Standard WHO COlumn
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 does not reference any database object

FLM.FLM_EKB_HORIZONTAL_PLAN_TEMP is referenced by following:

SchemaFLM
ViewFLM_EKB_HORIZONTAL_PLAN_TEMP#