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

TABLE: INV.MTL_SALES_ORDERS

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


MTL_SALES_ORDERS stores Inventory's local definition of sales orders.
.
.
.
Unlike account numbers which are stored as flexfields in
GL_CODE_COMBINATIONS, or purchase orders which are stored in
PO_HEADERS, sales orders are not assumed to originate in any
particular application. MTL_SALES_ORDERS exists for the purpose of
mapping sales orders between other applications and Inventory.
MTL_SALES_ORDERS is a key flexfield table with no structure defining
column or set defining column. The flexfield code for this table is
MKTS. Only one structure for the flexfield may be defined for any
installation of Inventory. Inventory demand interface and demand
manager will validate sales orders on segment values, and will create
a new SALES_ORDER_ID when necessary.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_SALES_ORDERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSALES_ORDER_ID
MTL_SALES_ORDERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEGMENT1
Columns
Name Datatype Length Mandatory Comments
SALES_ORDER_ID NUMBER
Yes Sales order id
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
SEGMENT2 VARCHAR2 (40)
Key flexfield segment
SEGMENT3 VARCHAR2 (40)
Key flexfield segment
SEGMENT4 VARCHAR2 (40)
Key flexfield segment
SEGMENT5 VARCHAR2 (40)
Key flexfield segment
SEGMENT6 VARCHAR2 (40)
Key flexfield segment
SEGMENT7 VARCHAR2 (40)
Key flexfield segment
SEGMENT8 VARCHAR2 (40)
Key flexfield segment
SEGMENT9 VARCHAR2 (40)
Key flexfield segment
SEGMENT10 VARCHAR2 (40)
Key flexfield segment
SEGMENT11 VARCHAR2 (40)
Key flexfield segment
SEGMENT12 VARCHAR2 (40)
Key flexfield segment
SEGMENT13 VARCHAR2 (40)
Key flexfield segment
SEGMENT14 VARCHAR2 (40)
Key flexfield segment
SEGMENT15 VARCHAR2 (40)
Key flexfield segment
SEGMENT16 VARCHAR2 (40)
Key flexfield segment
SEGMENT17 VARCHAR2 (40)
Key flexfield segment
SEGMENT18 VARCHAR2 (40)
Key flexfield segment
SEGMENT19 VARCHAR2 (40)
Key flexfield segment
SEGMENT20 VARCHAR2 (40)
Key flexfield segment
SUMMARY_FLAG VARCHAR2 (1) Yes Flag indicating whether segment combination includes a summary segment
ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating whether segment combination is enabled
START_DATE_ACTIVE DATE

Date segment combination becomes active
END_DATE_ACTIVE DATE

Date segment combination becomes inactive
SOURCE_CODE VARCHAR2 (30)
(not currently used)
ORDER_TYPE VARCHAR2 (30)
(not currently used)
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
Query Text

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


SELECT SALES_ORDER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SOURCE_CODE
,      ORDER_TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM INV.MTL_SALES_ORDERS;

Dependencies

[top of page]

INV.MTL_SALES_ORDERS does not reference any database object

INV.MTL_SALES_ORDERS is referenced by following:

SchemaAPPS
SynonymMTL_SALES_ORDERS