[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_NEW_DELIVERIES_V

Object Details

Object Name:	WSH_NEW_DELIVERIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_NEW_DELIVERIES_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

Query Text

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

SELECT TRIP_ID
,      STOP_ID
,      DELIVERY_DETAIL_ID
,      ROW_ID
,      DELIVERY_ID
,      NAME
,      PLANNED_FLAG
,      STATUS_CODE
,      STATUS_NAME
,      INITIAL_PICKUP_DATE
,      INITIAL_PICKUP_LOCATION_ID
,      ULTIMATE_DROPOFF_LOCATION_ID
,      ULTIMATE_DROPOFF_DATE
,      CUSTOMER_ID
,      INTMED_SHIP_TO_LOCATION_ID
,      POOLED_SHIP_TO_LOCATION_ID
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      FOB_LOCATION_ID
,      WAYBILL
,      ACCEPTANCE_FLAG
,      ACCEPTED_BY
,      ACCEPTED_DATE
,      ACKNOWLEDGED_BY
,      CONFIRMED_BY
,      ASN_DATE_SENT
,      ASN_STATUS_CODE
,      ASN_SEQ_NUMBER
,      WV_FROZEN_FLAG
,      GROSS_WEIGHT
,      TARE_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      ADDITIONAL_SHIPMENT_INFO
,      CONFIRM_DATE
,      SHIP_METHOD_CODE
,      DOCK_CODE
,      DELIVERY_TYPE
,      CARRIER_ID
,      CURRENCY_CODE
,      ORGANIZATION_ID
,      LOADING_SEQUENCE
,      LOADING_ORDER_FLAG
,      CONSOLIDATION_FLAG
,      ACTIVITY_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TP_ATTRIBUTE_CATEGORY
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      NUMBER_OF_LPN
,      COD_AMOUNT
,      COD_CURRENCY_CODE
,      COD_REMIT_TO
,      COD_CHARGE_PAID_BY
,      PROBLEM_CONTACT_REFERENCE
,      PORT_OF_LOADING
,      PORT_OF_DISCHARGE
,      FTZ_NUMBER
,      ROUTED_EXPORT_TXN
,      ENTRY_NUMBER
,      ROUTING_INSTRUCTIONS
,      IN_BOND_CODE
,      SHIPPING_MARKS
,      SERVICE_LEVEL
,      MODE_OF_TRANSPORT
,      ASSIGNED_TO_FTE_TRIPS
,      BATCH_ID
,      AP_BATCH_ID
,      AUTO_SC_EXCLUDE_FLAG
,      AUTO_AP_EXCLUDE_FLAG
,      TP_DELIVERY_NUMBER
,      TP_PLAN_NAME
,      IGNORE_FOR_PLANNING
,      PARTY_ID
,      ROUTING_RESPONSE_ID
,      RCV_SHIPMENT_HEADER_ID
,      ASN_SHIPMENT_HEADER_ID
,      SHIPMENT_DIRECTION
,      SHIPPING_CONTROL
,      VENDOR_ID
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_DROPOFF_DATE
,      LATEST_DROPOFF_DATE
,      REASON_OF_TRANSPORT
,      DESCRIPTION
,      DELIVERED_DATE
,      DELIVERY_WF_PROCESS
,      DELIVERY_SCPOD_WF_PROCESS
,      TMS_VERSION_NUMBER
,      TMS_INTERFACE_FLAG
,      PENDING_ADVICE_FLAG
,      CLIENT_ID
,      CONSIGNEE_FLAG
FROM APPS.WSH_NEW_DELIVERIES_V;

Dependencies

[top of page]

APPS

WSH_LOOKUPS

WSH_NEW_DELIVERIES

APPS

QA_ERES_WSH_NEW_DELIVERIES_V

WSH_STOP_DELIVERIES_V

WSH_TRIP_DELIVERIES_V