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


TYPE: APPS.WSH_OTM_DLV_OBJ

Object Details
Object Name: WSH_OTM_DLV_OBJ
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
TRANSACTION_CODE VARCHAR2 (3)
DELIVERY_ID NUMBER

NAME VARCHAR2 (30)
FREIGHT_TERMS VARCHAR2 (30)
FOB_CODE VARCHAR2 (30)
CARRIER_ID VARCHAR2 (30)
SERVICE_LEVEL VARCHAR2 (30)
MODE_OF_TRANSPORT VARCHAR2 (30)
INITIAL_PICKUP_LOCATION_ID VARCHAR2 (30)
ULTIMATE_DROPOFF_LOCATION_ID VARCHAR2 (30)
EARLIEST_PICKUP_DATE DATE

LATEST_PICKUP_DATE DATE

EARLIEST_DROPOFF_DATE DATE

LATEST_DROPOFF_DATE DATE

GROSS_WEIGHT NUMBER

WEIGHT_UOM_CODE VARCHAR2 (150)
VOLUME NUMBER

VOLUME_UOM_CODE VARCHAR2 (150)
NET_WEIGHT NUMBER

REVISION NUMBER

REASON_OF_TRANSPORT VARCHAR2 (30)
DESCRIPTION VARCHAR2 (30)
ADDITIONAL_SHIPMENT_INFO VARCHAR2 (500)
ROUTING_INSTRUCTIONS VARCHAR2 (120)
TOTAL_ITEM_COUNT NUMBER

REVISION_QLFR VARCHAR2 (20)
REASON_OF_TRANSPORT_QLFR VARCHAR2 (20)
DESCRIPTION_QLFR VARCHAR2 (20)
ADDITIONAL_SHIPMENT_INFO_QLFR VARCHAR2 (20)
ROUTING_INSTRUCTIONS_QLFR VARCHAR2 (20)
RL_DETAILS TYPEWSH_OTM_DET_TAB

LPN TYPEWSH_OTM_LPN_TAB

Dependencies

[top of page]

APPS.WSH_OTM_DLV_OBJ references the following:

SchemaAPPS
TYPEWSH_OTM_DET_TAB
TYPEWSH_OTM_LPN_TAB
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.WSH_OTM_DLV_OBJ is referenced by following:

SchemaAPPS
TYPEWSH_OTM_DLV_TAB
Package BodyWSH_OTM_OUTBOUND - show dependent code