[Home] [Help] [Dependency Information]
Object Name: | CLN_XML_DELIVERIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CLN.CLN_XML_DELIVERIES_V |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View for SHIPMENT deliveries section in OAG SHOW_SHIPMENT_005 XML payload
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 |
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;
APPS.CLN_XML_DELIVERIES_V is not referenced by any database object
|
|
|