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

TABLE: INV.MTL_KANBAN_PULL_SEQUENCES

Object Details
Object Name: MTL_KANBAN_PULL_SEQUENCES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_KANBAN_PULL_SEQUENCES
Subobject Name:
Status: VALID


MTL_KANBAN_PULL_SEQUENCES is the definition table for pull sequences.
The associated attributes describe which item, subinventory, and
locator this pull sequence belongs to, the source type, number of
kanbans , kanban size, replenishment lead time, and other planning
attributes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_KANBAN_PULL_SEQUENCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPULL_SEQUENCE_ID
MTL_KANBAN_PULL_SEQUENCES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnKANBAN_PLAN_ID
ColumnSUBINVENTORY_NAME
ColumnLOCATOR_ID
MTL_KANBAN_PULL_SEQUENCES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnKANBAN_PLAN_ID
ColumnORGANIZATION_ID
MTL_KANBAN_PULL_SEQUENCES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_TYPE
ColumnORGANIZATION_ID
MTL_KANBAN_PULL_SEQUENCES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPDATED_FLAG
Columns
Name Datatype Length Mandatory Comments
PULL_SEQUENCE_ID NUMBER
Yes Pull sequence identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SUBINVENTORY_NAME VARCHAR2 (10) Yes Subinventory name
KANBAN_PLAN_ID NUMBER
Yes Kanban plan identifier
SOURCE_TYPE NUMBER
Yes Kanban source type
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LOCATOR_ID NUMBER

Locator identifier
SUPPLIER_ID NUMBER

Supplier identifier
SUPPLIER_SITE_ID NUMBER

Supplier site identifier
SOURCE_ORGANIZATION_ID NUMBER

Source organization identifier
SOURCE_SUBINVENTORY VARCHAR2 (10)
Source subinventory name
SOURCE_LOCATOR_ID NUMBER

Source locator identifier
WIP_LINE_ID NUMBER

WIP line identifier
REPLENISHMENT_LEAD_TIME NUMBER

Lead time to replenish kanban
CALCULATE_KANBAN_FLAG NUMBER

Flag indicating what to calculate
KANBAN_SIZE NUMBER

Kanban quantity
FIXED_LOT_MULTIPLIER NUMBER

Fixed lot multiplier
SAFETY_STOCK_DAYS NUMBER

Safety stock days
NUMBER_OF_CARDS NUMBER

Number of kanban cards
MINIMUM_ORDER_QUANTITY NUMBER

Minimum order quantity
AGGREGATION_TYPE NUMBER

Aggregation type
ALLOCATION_PERCENT NUMBER

Allocation percent
LAST_UPDATE_LOGIN NUMBER

Standard Who column
UPDATED_FLAG NUMBER

Standard Who column
RELEASE_KANBAN_FLAG NUMBER
Yes Flag to indicate that Kanban will execute (Yes) or not (No,for planning only).
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
POINT_OF_USE_X NUMBER

X co-ordinate of use
POINT_OF_USE_Y NUMBER

Y co-ordinate of use
POINT_OF_SUPPLY_X NUMBER

X co-ordinate of supply
POINT_OF_SUPPLY_Y NUMBER

Y co-ordinate of supply
PLANNING_UPDATE_STATUS NUMBER

Planning update status
AUTO_REQUEST VARCHAR2 (1)
Flag Indicating if the pull sequence is auto request eligible
AUTO_ALLOCATE_FLAG VARCHAR2 (1)
Flag indicating if the replenishment move order should be automatically allocated on creation
REPLENISHMENT_TYPE NUMBER

0-Physical, 1-Logical
FUTURE_CARD_SIZE NUMBER

Future kanban card size for planning
FUTURE_NO_OF_CARDS NUMBER

Future number of kanban cards for planning
PLANNING_EFFECTIVITY DATE

Planning effective date
CONSOLIDATION NUMBER

Consolidation option for cards of pull sequence.
CONSOLIDATION_GROUP VARCHAR2 (20)
Consolidation group name to consolidate kanban cards
AVG_DEPENDENT_DEMAND NUMBER

Average Dependent Daily Demand used for Planning Pull sequences
AVG_INDEPENDENT_DEMAND NUMBER

Average Independent Daily Demand used for Planning Pull sequences
INV_HEALTH_STATUS NUMBER

Inventory health status.
INV_HEALTH_LAST_UPDATE_DATE DATE

Last inventory health status update date
LAST_IMPLEMENTED_PLAN VARCHAR2 (10)
Last Implemented Kanban Plan
PLAN_START_DATE DATE

PLAN_START_DATE
PLAN_END_DATE DATE

Plan End Date
NO_OF_TEMP_CARDS NUMBER

No. of Temporary cards (used in planning)
NO_OF_TEMP_CYCLES NUMBER

No. of cycles for Temporary cards(used in planning)
TEMP_EXPIRY_DATE DATE

Expiration Date for Temporary cards (used in planning)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PULL_SEQUENCE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SUBINVENTORY_NAME
,      KANBAN_PLAN_ID
,      SOURCE_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LOCATOR_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      SOURCE_LOCATOR_ID
,      WIP_LINE_ID
,      REPLENISHMENT_LEAD_TIME
,      CALCULATE_KANBAN_FLAG
,      KANBAN_SIZE
,      FIXED_LOT_MULTIPLIER
,      SAFETY_STOCK_DAYS
,      NUMBER_OF_CARDS
,      MINIMUM_ORDER_QUANTITY
,      AGGREGATION_TYPE
,      ALLOCATION_PERCENT
,      LAST_UPDATE_LOGIN
,      UPDATED_FLAG
,      RELEASE_KANBAN_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      POINT_OF_USE_X
,      POINT_OF_USE_Y
,      POINT_OF_SUPPLY_X
,      POINT_OF_SUPPLY_Y
,      PLANNING_UPDATE_STATUS
,      AUTO_REQUEST
,      AUTO_ALLOCATE_FLAG
,      REPLENISHMENT_TYPE
,      FUTURE_CARD_SIZE
,      FUTURE_NO_OF_CARDS
,      PLANNING_EFFECTIVITY
,      CONSOLIDATION
,      CONSOLIDATION_GROUP
,      AVG_DEPENDENT_DEMAND
,      AVG_INDEPENDENT_DEMAND
,      INV_HEALTH_STATUS
,      INV_HEALTH_LAST_UPDATE_DATE
,      LAST_IMPLEMENTED_PLAN
,      PLAN_START_DATE
,      PLAN_END_DATE
,      NO_OF_TEMP_CARDS
,      NO_OF_TEMP_CYCLES
,      TEMP_EXPIRY_DATE
FROM INV.MTL_KANBAN_PULL_SEQUENCES;

Dependencies

[top of page]

INV.MTL_KANBAN_PULL_SEQUENCES does not reference any database object

INV.MTL_KANBAN_PULL_SEQUENCES is referenced by following:

SchemaINV
ViewMTL_KANBAN_PULL_SEQUENCES#