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.CLN_XML_DELIVERIES_V

Object Details

Object Name:	CLN_XML_DELIVERIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CLN.CLN_XML_DELIVERIES_V
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View for SHIPMENT deliveries section in OAG SHOW_SHIPMENT_005 XML payload

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_CODE	VARCHAR2	(30)	Yes	Unique Delivery Name
DELIVERY_ID	NUMBER		Yes	Primary Key to identify delivery
DESTINATION_CODE_INT	VARCHAR2	(40)	Yes	Destination Internal Partner ID
DESTINATION_EDI_LOC_CODE	VARCHAR2	(40)		Destination EDI Location Code
DESTINATION_NAME	VARCHAR2	(50)		Destination Name
DESTINATION_ADDRESS1	VARCHAR2	(240)	Yes	First Line of Destination Address
DESTINATION_ADDRESS2	VARCHAR2	(240)		Second Line of Destination Address
DESTINATION_ADDRESS3	VARCHAR2	(240)		Third Line of Destination Address
DESTINATION_CITY	VARCHAR2	(60)		Destination City
DESTINATION_STATE	VARCHAR2	(60)
DESTINATION_POSTAL_CODE	VARCHAR2	(60)		Destination Postal Code
DESTINATION_COUNTRY_INT	VARCHAR2	(60)	Yes	Destination Country
DESTINATION_CONTACT_LAST_NAME	VARCHAR2	(50)		Last Name of the Destination Contact Person
DESTINATION_CONTACT_FIRST_NAME	VARCHAR2	(40)		First Name of the Destination Contact Person
DESTINATION_AREA_CODE	VARCHAR2	(4000)		Destination Area Code
DESTINATION_TELEPHONE	VARCHAR2	(4000)		Destination Telephone Number
SHIPPER_NUMBER	NUMBER		Yes	Shipper Number
WAYBILL_NUMBER	VARCHAR2	(30)		Waybill Number
BILL_OF_LADING	VARCHAR2	(50)		Bill of Lading
PACKING_SLIP_NUMBER	VARCHAR2	(50)		Packing Slip Number
FREIGHT_TERMS_CODE_INT	VARCHAR2	(30)		Freight Terms Code
NUMBER_OF_LPN	NUMBER			License Plate Number
SHIP_METHOD_CODE_INT	VARCHAR2	(30)		Ship Method Code
ULTIMATE_DROPOFF_DATE	DATE			Scheduled Delivery Date
INITIAL_PICKUP_DATE	DATE
PLANNED_DEPARTURE_DATE	DATE			Scheduled Ship Date
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield Category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
TP_DESCRIPTION	VARCHAR2	(500)		Supplier Name
TP_LOCATION_CODE_EXT	VARCHAR2	(35)		Supplier EDI Location Code
TP_ADDRESS1	VARCHAR2	(240)		First line of Supplier Address
TP_ADDRESS2	VARCHAR2	(240)		Second line of Supplier Address
TP_ADDRESS3	VARCHAR2	(240)		Third line of Supplier Address
TP_CITY	VARCHAR2	(120)		Supplier City
TP_STATE	VARCHAR2	(120)
TP_COUNTRY	VARCHAR2	(120)		Supplier Country
TP_POSTAL_CODE	VARCHAR2	(60)		Supplier Postal Code
TP_PHONE	VARCHAR2	(60)		Supplier Phone Number
TP_FAX	VARCHAR2	(60)		Fax Number of the Supplier Contact
TP_CODE	NUMBER		Yes	Supplier Internal Partner ID
CARRIER_NAME_INT	VARCHAR2	(360)		Carrier Name

Query Text

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


SELECT DOCUMENT_CODE
,      DELIVERY_ID
,      DESTINATION_CODE_INT
,      DESTINATION_EDI_LOC_CODE
,      DESTINATION_NAME
,      DESTINATION_ADDRESS1
,      DESTINATION_ADDRESS2
,      DESTINATION_ADDRESS3
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_POSTAL_CODE
,      DESTINATION_COUNTRY_INT
,      DESTINATION_CONTACT_LAST_NAME
,      DESTINATION_CONTACT_FIRST_NAME
,      DESTINATION_AREA_CODE
,      DESTINATION_TELEPHONE
,      SHIPPER_NUMBER
,      WAYBILL_NUMBER
,      BILL_OF_LADING
,      PACKING_SLIP_NUMBER
,      FREIGHT_TERMS_CODE_INT
,      NUMBER_OF_LPN
,      SHIP_METHOD_CODE_INT
,      ULTIMATE_DROPOFF_DATE
,      INITIAL_PICKUP_DATE
,      PLANNED_DEPARTURE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TP_DESCRIPTION
,      TP_LOCATION_CODE_EXT
,      TP_ADDRESS1
,      TP_ADDRESS2
,      TP_ADDRESS3
,      TP_CITY
,      TP_STATE
,      TP_COUNTRY
,      TP_POSTAL_CODE
,      TP_PHONE
,      TP_FAX
,      TP_CODE
,      CARRIER_NAME_INT
FROM APPS.CLN_XML_DELIVERIES_V;

Dependencies

[top of page]

APPS.CLN_XML_DELIVERIES_V references the following:

APPS: HR_LOCATIONS_ALL; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; HZ_RELATIONSHIPS; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_LEGS; WSH_DOCUMENT_INSTANCES; WSH_ECE_VIEWS_DEF - show dependent code; WSH_LOCATIONS; WSH_NEW_DELIVERIES; WSH_TRIPS; WSH_TRIP_STOPS; WSH_UTIL_CORE - show dependent code

APPS.CLN_XML_DELIVERIES_V is not referenced by any database object