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

TABLE: MTH.MTH_WO_SALES_ORDERS_I_STG

Object Details
Object Name: MTH_WO_SALES_ORDERS_I_STG
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_WO_SALES_ORDERS_I_STG
Subobject Name:
Status: VALID


Interface table for MTH_WO_SALES_ORDERS_F


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RESERVATION_ID NUMBER

Internal column for EBS integration only
SUPPLY_SOURCE_HEADER_ID NUMBER

Internal column for EBS integration only
ORDER_NUMBER NUMBER

Internal column for EBS integration only
LINE_NUMBER NUMBER

Internal column for EBS integration only
REQUEST_DATE DATE

Internal column for EBS integration only
PROMISE_DATE DATE

Internal column for EBS integration only
SCHEDULE_SHIP_DATE DATE

Internal column for EBS integration only
ORDERED_QUANTITY NUMBER

Internal column for EBS integration only
ORDER_QUANTITY_UOM VARCHAR2 (3)
Internal column for EBS integration only
ORDERED_ITEM_ID NUMBER

Internal column for EBS integration only
CUSTOMER_NAME VARCHAR2 (100)
Internal column for EBS integration only
DB_GLOBAL_NAME VARCHAR2 (120)
Internal column for EBS integration only
HUB_ORGANIZATION_CODE VARCHAR2 (120)
Internal column for EBS integration only
SOURCE_TYPE NUMBER

Internal column for EBS integration only
Query Text

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


SELECT RESERVATION_ID
,      SUPPLY_SOURCE_HEADER_ID
,      ORDER_NUMBER
,      LINE_NUMBER
,      REQUEST_DATE
,      PROMISE_DATE
,      SCHEDULE_SHIP_DATE
,      ORDERED_QUANTITY
,      ORDER_QUANTITY_UOM
,      ORDERED_ITEM_ID
,      CUSTOMER_NAME
,      DB_GLOBAL_NAME
,      HUB_ORGANIZATION_CODE
,      SOURCE_TYPE
FROM MTH.MTH_WO_SALES_ORDERS_I_STG;

Dependencies

[top of page]

MTH.MTH_WO_SALES_ORDERS_I_STG does not reference any database object

MTH.MTH_WO_SALES_ORDERS_I_STG is referenced by following:

SchemaMTH
ViewMTH_WO_SALES_ORDERS_I_STG#