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


TABLE: ONT.OE_SETS

Object Details
Object Name: OE_SETS
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_SETS
Subobject Name:
Status: VALID


OE_SETS stores information on line sets.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_SETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_ID
OE_SETS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnSET_NAME
ColumnSET_TYPE
OE_SETS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_NAME
Columns
Name Datatype Length Mandatory Comments
SET_ID NUMBER
Yes Primary Key Value for sets
SET_NAME VARCHAR2 (30) Yes User defined Name for the set
SET_TYPE VARCHAR2 (30) Yes Indicates the type(Ship/Line/Arrival/Fullfillment) of set.
HEADER_ID NUMBER
Yes Foreign Key value to point to Order Headers all table
SHIP_FROM_ORG_ID NUMBER

Stores Wearhouse
SHIP_TO_ORG_ID NUMBER

Ship to organization id
SCHEDULE_SHIP_DATE DATE

Stores Scheduled ship date of the set
SCHEDULE_ARRIVAL_DATE DATE

Stores Schedules arrival date
FREIGHT_CARRIER_CODE VARCHAR2 (30)
Freight Carrier code
SHIPPING_METHOD_CODE VARCHAR2 (30)
Stores Shipping method
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
Stores Shipment Priority
SET_STATUS VARCHAR2 (1)
Status to indicate the set is open or closed
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
UPDATED_BY NUMBER
Yes Standard Who column
UPDATE_DATE DATE
Yes Standard Who column
UPDATE_LOGIN NUMBER

Standard who column
INVENTORY_ITEM_ID NUMBER

Stores Inventory item for a line set
ORDERED_QUANTITY_UOM VARCHAR2 (3)
Stores Ordered quantity Unit of measure for line set
LINE_TYPE_ID NUMBER

Stores Line type for Line Set
SHIP_TOLERANCE_ABOVE NUMBER

Over shipment/return Tolerance
SHIP_TOLERANCE_BELOW NUMBER

Under Shipment/Return Tolerance
INST_ID NUMBER

used in RAC INSTANCE AFFINITY for context setting
Query Text

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


SELECT SET_ID
,      SET_NAME
,      SET_TYPE
,      HEADER_ID
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      SCHEDULE_SHIP_DATE
,      SCHEDULE_ARRIVAL_DATE
,      FREIGHT_CARRIER_CODE
,      SHIPPING_METHOD_CODE
,      SHIPMENT_PRIORITY_CODE
,      SET_STATUS
,      CREATED_BY
,      CREATION_DATE
,      UPDATED_BY
,      UPDATE_DATE
,      UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORDERED_QUANTITY_UOM
,      LINE_TYPE_ID
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      INST_ID
FROM ONT.OE_SETS;

Dependencies

[top of page]

ONT.OE_SETS does not reference any database object

ONT.OE_SETS is referenced by following:

SchemaONT
ViewOE_SETS#