[Home] [Help]
[Dependency Information]
| Object Name: | WSH_OTM_TRIP_OBJ |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| 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 |
WSH_OTM_STOP_TAB
|
|
|
| SHIPMENT_SHIP_UNITS |
WSH_OTM_SHIP_UNIT_TAB
|
|
|
| SHIPMENT_DELIVERIES |
WSH_OTM_DLV_TAB
|
|
|
| SHIPMENT_RELEASES |
WSH_OTM_RELEASE_TAB
|
|
|
| LPNS |
WSH_OTM_LPN_TAB
|
|
|
| STOP_LOCATIONS |
WSH_OTM_STOPLOCTZ_TAB
|
|
APPS
WSH_OTM_DLV_TAB
WSH_OTM_LPN_TAB
WSH_OTM_RELEASE_TAB
WSH_OTM_SHIP_UNIT_TAB
WSH_OTM_STOPLOCTZ_TAB
WSH_OTM_STOP_TAB
SYS
STANDARD
- show dependent code
APPS
WSH_OTM_INBOUND_GRP
- show dependent code
WSH_OTM_OUTBOUND
- show dependent code
WSH_OTM_TRIP_TAB
|
|
|
|