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

TABLE: FLM.FLM_EKB_PULL_SEQ_INTERFACE

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


This table is used for importing Pull Sequences from other kanban systems.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FLM_EKB_PULL_SEQ_INTERFACE_IDX NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ID
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ID NUMBER
Yes Interface Identifier
PULL_SEQUENCE_ID NUMBER

Pull Sequence Identifier
TRANSACTION_TYPE NUMBER
Yes 1-Insert, 2-Update, 3-Delete
GENERATE_CARDS VARCHAR2 (1)
Generate cards flag. Default 'N'
GROUP_ID NUMBER

Processing group Identifier
PROCESS_STATUS NUMBER

Process Status
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_UPDATE_LOGIN NUMBER

Standard Who column
INVENTORY_ITEM_ID NUMBER

Inventory item Identifier for pull sequence creation
CONCATENATED_SEGMENTS VARCHAR2 (40)
Inventory Item Name
ORGANIZATION_CODE VARCHAR2 (3)
Short code that uniquely identifies the organization
ORGANIZATION_ID NUMBER

Organization Identifier
SUBINVENTORY_NAME VARCHAR2 (10)
Subinventory name
SOURCE_TYPE NUMBER

Kanban source type identifier
LOCATOR_ID NUMBER

Locator Identifier
SUPPLIER_ID NUMBER

Supplier ID
SUPPLIER_NAME VARCHAR2 (240)
Supplier Name
SUPPLIER_SITE_ID NUMBER

Supplier Site Id
SUPPLIER_SITE_CODE VARCHAR2 (15)
Supplier Site code
SOURCE_ORGANIZATION_ID NUMBER

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

Source locator identifier
WIP_LINE_CODE VARCHAR2 (10)
Wip line name
WIP_LINE_ID NUMBER

Wip line identifier
REPLENISHMENT_LEAD_TIME NUMBER

Lead time to replenish kanban
CALCULATE_KANBAN_FLAG NUMBER

Lead time to replenish kanban
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
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
RELEASE_KANBAN_FLAG NUMBER

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
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
ERROR_TEXT VARCHAR2 (4000)
Error Text incase if interface record errors out
REPLENISHMENT_TYPE NUMBER

0-Physical 1-Logical
CONSOLIDATION NUMBER

Consolidation for pull sequence
CONSOLIDATION_GROUP VARCHAR2 (20)
Consolidation group name to consoidate kanban cards
AVG_DEPENDENT_DEMAND NUMBER

Average Dependent Demand
AVG_INDEPENDENT_DEMAND NUMBER

Average Independent Demand
Query Text

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


SELECT INTERFACE_ID
,      PULL_SEQUENCE_ID
,      TRANSACTION_TYPE
,      GENERATE_CARDS
,      GROUP_ID
,      PROCESS_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      CONCATENATED_SEGMENTS
,      ORGANIZATION_CODE
,      ORGANIZATION_ID
,      SUBINVENTORY_NAME
,      SOURCE_TYPE
,      LOCATOR_ID
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_CODE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      SOURCE_LOCATOR_ID
,      WIP_LINE_CODE
,      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
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      RELEASE_KANBAN_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AUTO_REQUEST
,      AUTO_ALLOCATE_FLAG
,      ERROR_TEXT
,      REPLENISHMENT_TYPE
,      CONSOLIDATION
,      CONSOLIDATION_GROUP
,      AVG_DEPENDENT_DEMAND
,      AVG_INDEPENDENT_DEMAND
FROM FLM.FLM_EKB_PULL_SEQ_INTERFACE;

Dependencies

[top of page]

FLM.FLM_EKB_PULL_SEQ_INTERFACE does not reference any database object

FLM.FLM_EKB_PULL_SEQ_INTERFACE is referenced by following:

SchemaFLM
ViewFLM_EKB_PULL_SEQ_INTERFACE#