eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GML.OP_CUST_SHP

Object Details

Object Name:	OP_CUST_SHP
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_CUST_SHP
Subobject Name:
Status:	VALID

This table contains data on preferred shippers (carriers) and ship methods for customers. A default record is created in this table when the customer data is transferred from Oracle Receivables. Users may enter additional records to add preferred carriers and transit times. Information from this table is used to default carriers and ship methods on an order, as well as compute Scheduled Ship Dates.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_CUST_SHP_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTSHIP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTSHIP_ID	NUMBER	(10)	Yes	Surrogate id to uniquely identify record
FRT_ZONE	VARCHAR2	(8)		Freight zone; field not currently used or supported.
PREFERENCE	NUMBER	(5)		Preference determines the order in which shipping method and shipper code are selected for the customer, if multiple ship methods are defined. 1 is the preferred method and shipper; higher numbers take a lower preference.
TRANSIT_TIME	NUMBER			Default transit time from warehouse to customer location using this shipping method and shipper. Transit time is in days. Will be used to calculate scheduled ship date on an order and order line.
CUST_ID	NUMBER	(15)	Yes	Customer for whom these shipping preferences were established. Fk to op_cust_mst.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
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
WHSE_CODE	VARCHAR2	(4)		Warehouse code; fk to ic_whse_mst.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
ICSHIP_CLASS	VARCHAR2	(8)		Shipping class for the item; fk to ic_ship_cls.
SHIP_MTHD	VARCHAR2	(4)		Shipping method; fk to op_ship_mth
SHIPPER_CODE	VARCHAR2	(4)	Yes	Shipper code; fk to op_ship_mst.
SHIP_CATEGORY_ID	NUMBER			Category Id for SHIP_CLASS
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.

Query Text

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


SELECT CUSTSHIP_ID
,      FRT_ZONE
,      PREFERENCE
,      TRANSIT_TIME
,      CUST_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      WHSE_CODE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ICSHIP_CLASS
,      SHIP_MTHD
,      SHIPPER_CODE
,      SHIP_CATEGORY_ID
,      OPM_CUST_ID
FROM GML.OP_CUST_SHP;

Dependencies

[top of page]

GML.OP_CUST_SHP does not reference any database object

GML.OP_CUST_SHP is referenced by following:

APPS: OP_CUST_SHP