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

TABLE: INV.MTL_PULL_SEQ_SUPPLIERS

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


This table stores Pull sequence for the suppliers


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_PULL_SEQ_SUPPLIERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPULL_SEQUENCE_ID
ColumnSUPPLIER_ID
MTL_PULL_SEQ_SUPPLIERS_IDX NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPULL_SEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
PULL_SEQUENCE_ID NUMBER
Yes References to mtl_kanban_Pull_sequences.
ORGANIZATION_ID NUMBER
Yes Organization ID
SUPPLIER_ID NUMBER
Yes Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
SOURCING_PERCENTAGE NUMBER
Yes Percentage of material sourced for this supplier
NUMBER_OF_CARDS NUMBER

No. of Kanban cards for each supplier.
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
LAST_UPDATE_LOGIN NUMBER

Standard Who column
FUTURE_NO_OF_CARDS NUMBER

Future Number Of Cards
Query Text

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


SELECT PULL_SEQUENCE_ID
,      ORGANIZATION_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SOURCING_PERCENTAGE
,      NUMBER_OF_CARDS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FUTURE_NO_OF_CARDS
FROM INV.MTL_PULL_SEQ_SUPPLIERS;

Dependencies

[top of page]

INV.MTL_PULL_SEQ_SUPPLIERS does not reference any database object

INV.MTL_PULL_SEQ_SUPPLIERS is referenced by following:

SchemaINV
ViewMTL_PULL_SEQ_SUPPLIERS#