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

TABLE: FLM.FLM_EKB_SUPPLIER_INTERFACE

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


This table is used for importing multiple suppliers for 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_SUPPLIER_INTERFACE_IDX NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_INTERFACE_ID
Columns
Name Datatype Length Mandatory Comments
PARENT_INTERFACE_ID NUMBER
Yes Identifies this row's parent in FLM_EKB_PULL_SEQ_INTERFACE
TRANSACTION_TYPE NUMBER
Yes 1- Insert, 2-Update 3-Delete
SUPPLIER_ID NUMBER

Supplier Identifier
SUPPLIER_NAME VARCHAR2 (240)
Supplier Name
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
SUPPLIER_SITE_CODE VARCHAR2 (15)
Supplier Site Code
SOURCING_PERCENTAGE NUMBER

Percentage of material sourced for this supplier.
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
Query Text

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


SELECT PARENT_INTERFACE_ID
,      TRANSACTION_TYPE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_CODE
,      SOURCING_PERCENTAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM FLM.FLM_EKB_SUPPLIER_INTERFACE;

Dependencies

[top of page]

FLM.FLM_EKB_SUPPLIER_INTERFACE does not reference any database object

FLM.FLM_EKB_SUPPLIER_INTERFACE is referenced by following:

SchemaFLM
ViewFLM_EKB_SUPPLIER_INTERFACE#