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


TYPE: APPS.WSH_OTM_TRIP_OBJ

Object Details
Object Name: WSH_OTM_TRIP_OBJ
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
SHIPMENT_XID VARCHAR2 (200)
SHIPMENT_NAME VARCHAR2 (2000)
SHIPMENT_REFNUM VARCHAR2 (200)
TRANSACTION_CODE VARCHAR2 (10)
SERVICE_PROVIDER_XID VARCHAR2 (200)
CONTACT_XID VARCHAR2 (200)
TRANSPORT_MODE_XID VARCHAR2 (200)
RATE_SERVICE_XID VARCHAR2 (200)
WEIGHT_UOM_XID VARCHAR2 (200)
VOLUME NUMBER

VOLUME_UOM_XID VARCHAR2 (200)
SHIPUNIT_COUNT NUMBER

PAYMENT_CODE_XID VARCHAR2 (200)
STOP_COUNT NUMBER

RELEASE_COUNT NUMBER

VOYAGE_XID VARCHAR2 (200)
VESSEL_XID VARCHAR2 (200)
EQUIPMENT_XID VARCHAR2 (200)
EQUIPMENT_INITIAL VARCHAR2 (200)
EQUIPMENT_NUMBER VARCHAR2 (200)
EQUIPMENT_TYPE_XID VARCHAR2 (200)
EQUIPMENT_GROUP_XID VARCHAR2 (200)
TP_PLAN_NAME VARCHAR2 (200)
EQUIPMENT_SEAL VARCHAR2 (30)
MASTER_BOL_NUMBER VARCHAR2 (50)
PLANNED_FLAG VARCHAR2 (1)
ROUTING_INSTRUCTIONS VARCHAR2 (2000)
GROSS_WEIGHT NUMBER

NET_WEIGHT NUMBER

BOOKING_NUMBER VARCHAR2 (30)
ESTIMATED_COST VARCHAR2 (200)
TRIP_ID NUMBER

IGNORE_FOR_PLANNING VARCHAR2 (1)
OPERATOR VARCHAR2 (150)
MANUAL_FREIGHT_COSTS NUMBER

CURRENCY_CODE VARCHAR2 (15)
PACKED_ITEM_COUNT NUMBER

TRIP_ID_QLFR VARCHAR2 (20)
MBOL_NUMBER_QLFR VARCHAR2 (30)
PLANNED_TRIP_QLFR VARCHAR2 (30)
MANUAL_FREIGHT_COSTS_QLFR VARCHAR2 (30)
MAN_FREIGHT_COST_CUR_QLFR VARCHAR2 (30)
OPERATOR_QLFR VARCHAR2 (30)
ROUTING_INSTR_QLFR VARCHAR2 (30)
SHIPMENT_STOPS TYPEWSH_OTM_STOP_TAB

SHIPMENT_SHIP_UNITS TYPEWSH_OTM_SHIP_UNIT_TAB

SHIPMENT_DELIVERIES TYPEWSH_OTM_DLV_TAB

SHIPMENT_RELEASES TYPEWSH_OTM_RELEASE_TAB

LPNS TYPEWSH_OTM_LPN_TAB

STOP_LOCATIONS TYPEWSH_OTM_STOPLOCTZ_TAB

Dependencies

[top of page]

APPS.WSH_OTM_TRIP_OBJ references the following:

SchemaAPPS
TYPEWSH_OTM_DLV_TAB
TYPEWSH_OTM_LPN_TAB
TYPEWSH_OTM_RELEASE_TAB
TYPEWSH_OTM_SHIP_UNIT_TAB
TYPEWSH_OTM_STOPLOCTZ_TAB
TYPEWSH_OTM_STOP_TAB
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.WSH_OTM_TRIP_OBJ is referenced by following:

SchemaAPPS
Package BodyWSH_OTM_INBOUND_GRP - show dependent code
Package BodyWSH_OTM_OUTBOUND - show dependent code
TYPEWSH_OTM_TRIP_TAB