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]

VIEW: APPS.IBE_SHIP_DLVY_V

Object Details

Object Name:	IBE_SHIP_DLVY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBE.IBE_SHIP_DLVY_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_ID	NUMBER		Yes	Primary Key to identify delivery
DELIVERY_NAME	VARCHAR2	(30)	Yes	Unique Delivery Name
ORGANIZATION_ID	NUMBER			Operating Unit which performed this transaction
DLVY_STATUS_CODE	VARCHAR2	(2)	Yes	Delivery shipping status ,e.g., OP for Open delivery
DLVY_STATUS_MEANING	VARCHAR2	(80)	Yes	Delivery shipping status to display on UI
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight Terms Code
FREIGHT_TERMS_MEANING	VARCHAR2	(80)		Freight Terms to display on the UI
WAYBILL	VARCHAR2	(30)		May be the tracking number
GROSS_WEIGHT	NUMBER			Gross Weight
NET_WEIGHT	NUMBER			Net Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)		Unit of Measure for weight
WEIGHT_UOM_MEANING	VARCHAR2	(25)	Yes	Unit of Measure to display on UI for weight
VOLUME	NUMBER			Volume
VOLUME_UOM_CODE	VARCHAR2	(3)		Unit of Measure for volume
SHIP_METHOD_CODE	VARCHAR2	(30)		Ship method code
SHIP_METHOD_MEANING	VARCHAR2	(80)		Ship method to display on the UI
CARRIER_ID	NUMBER			Freight Carrier
INITIAL_PICKUP_DATE	DATE			Date on which the delivery is first picked up
INITIAL_PICKUP_LOCATION_ID	NUMBER		Yes	Initial Pick-up location of delivery
ULTIMATE_DROPOFF_DATE	DATE			Date on which the delivery is finally dropped off
ULTIMATE_DROPOFF_LOCATION_ID	NUMBER		Yes	Final Drop-off location of delivery
DROPOFF_ADDRESS_LINE_1	VARCHAR2	(240)	Yes	First line for address
DROPOFF_ADDRESS_LINE_2	VARCHAR2	(240)		Second line for address
DROPOFF_ADDRESS_LINE_3	VARCHAR2	(240)		Third line for address
DROPOFF_TOWN_OR_CITY	VARCHAR2	(60)		Town or City
DROPOFF_COUNTRY	VARCHAR2	(60)	Yes	Country
DROPOFF_POSTAL_CODE	VARCHAR2	(60)		Postal Code
DROPOFF_ADDRESS_LINES_PHONETIC	VARCHAR2	(560)		Phonetic or Kana representation of the Kanji address lines (used in Japan)
DROPOFF_STATE	VARCHAR2	(60)		State
DROPOFF_COUNTY	VARCHAR2	(60)		County
DROPOFF_PROVINCE	VARCHAR2	(60)		Province
FOB_CODE	VARCHAR2	(30)
FOB_MEANING	VARCHAR2	(80)

Query Text

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


SELECT DELIVERY_ID
,      DELIVERY_NAME
,      ORGANIZATION_ID
,      DLVY_STATUS_CODE
,      DLVY_STATUS_MEANING
,      FREIGHT_TERMS_CODE
,      FREIGHT_TERMS_MEANING
,      WAYBILL
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      WEIGHT_UOM_MEANING
,      VOLUME
,      VOLUME_UOM_CODE
,      SHIP_METHOD_CODE
,      SHIP_METHOD_MEANING
,      CARRIER_ID
,      INITIAL_PICKUP_DATE
,      INITIAL_PICKUP_LOCATION_ID
,      ULTIMATE_DROPOFF_DATE
,      ULTIMATE_DROPOFF_LOCATION_ID
,      DROPOFF_ADDRESS_LINE_1
,      DROPOFF_ADDRESS_LINE_2
,      DROPOFF_ADDRESS_LINE_3
,      DROPOFF_TOWN_OR_CITY
,      DROPOFF_COUNTRY
,      DROPOFF_POSTAL_CODE
,      DROPOFF_ADDRESS_LINES_PHONETIC
,      DROPOFF_STATE
,      DROPOFF_COUNTY
,      DROPOFF_PROVINCE
,      FOB_CODE
,      FOB_MEANING
FROM APPS.IBE_SHIP_DLVY_V;

Dependencies

[top of page]

APPS.IBE_SHIP_DLVY_V references the following:

APPS: AR_LOOKUPS; HZ_LOCATIONS; MTL_UNITS_OF_MEASURE_TL; OE_LOOKUPS; OE_SHIP_METHODS_V; WSH_LOOKUPS; WSH_NEW_DELIVERIES

APPS.IBE_SHIP_DLVY_V is not referenced by any database object