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

TABLE: GML.OP_SHIP_MTH

Object Details
Object Name: OP_SHIP_MTH
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.OP_SHIP_MTH
Subobject Name:
Status: VALID


Shipping method codes are established in this table and used in OPM Order Entry/Shipping and Receiving to indicate the method of shipment.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OP_SHIP_MTH_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSHIP_MTHD
Columns
Name Datatype Length Mandatory Comments
SHIP_MTHD VARCHAR2 (4) Yes Unique identifier of shipping method
MTHD_DESC1 VARCHAR2 (40) Yes Description one of shipping method
MTHD_DESC2 VARCHAR2 (40)
Description two of shipping method
SHIPPING_ROUTING VARCHAR2 (70)
Freeform text to describe the shipping route
PREFERRED_SHIPPER VARCHAR2 (4)
Preferred shipper for this method; fk to op_ship_mst
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT NUMBER (10)
Not currently used
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
Query Text

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


SELECT SHIP_MTHD
,      MTHD_DESC1
,      MTHD_DESC2
,      SHIPPING_ROUTING
,      PREFERRED_SHIPPER
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM GML.OP_SHIP_MTH;

Dependencies

[top of page]

GML.OP_SHIP_MTH does not reference any database object

GML.OP_SHIP_MTH is referenced by following:

SchemaAPPS
SynonymOP_SHIP_MTH