[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_DLVY_DELIVERABLES_V

Object Details

Object Name:	WSH_DLVY_DELIVERABLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_DLVY_DELIVERABLES_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
,      ROW_ID
,      TYPE
,      DELIVERY_DETAIL_ID
,      DELIVERY_LINE_ID
,      CONTAINER_INSTANCE_ID
,      CONTAINER_NAME
,      DELIVERY_ID
,      SOURCE_CODE
,      SOURCE_NAME
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SOURCE_HEADER_NUMBER
,      SOURCE_HEADER_TYPE_ID
,      SOURCE_HEADER_TYPE_NAME
,      SOURCE_LINE_NUMBER
,      SRC_REQUESTED_QUANTITY
,      SRC_REQUESTED_QUANTITY_UOM
,      CUSTOMER_ID
,      SOLD_TO_CONTACT_ID
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      COUNTRY_OF_ORIGIN
,      CLASSIFICATION
,      SHIP_FROM_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_CONTACT_ID
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_CONTACT_ID
,      INTMED_SHIP_TO_LOCATION_ID
,      INTMED_SHIP_TO_CONTACT_ID
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      REQUESTED_QUANTITY
,      SHIPPED_QUANTITY
,      DELIVERED_QUANTITY
,      CANCELLED_QUANTITY
,      REQUESTED_QUANTITY_UOM
,      SUBINVENTORY
,      REVISION
,      LOT_NUMBER
,      CUSTOMER_REQUESTED_LOT_FLAG
,      SERIAL_NUMBER
,      LOCATOR_ID
,      DATE_REQUESTED
,      DATE_SCHEDULED
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      LOAD_SEQ_NUMBER
,      SHIP_METHOD_CODE
,      CARRIER_ID
,      FREIGHT_TERMS_CODE
,      SHIPMENT_PRIORITY_CODE
,      FOB_CODE
,      CUSTOMER_ITEM_ID
,      DEP_PLAN_REQUIRED_FLAG
,      CUSTOMER_PROD_SEQ
,      CUSTOMER_DOCK_CODE
,      UNIT_WEIGHT
,      UNIT_VOLUME
,      WV_FROZEN_FLAG
,      GROSS_WEIGHT
,      TARE_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      FILLED_VOLUME
,      VOLUME
,      VOLUME_UOM_CODE
,      FILL_PERCENT
,      MAXIMUM_LOAD_WEIGHT
,      MAXIMUM_VOLUME
,      MINIMUM_FILL_PERCENT
,      MVT_STAT_STATUS
,      RELEASED_STATUS
,      RELEASED_STATUS_NAME
,      ORGANIZATION_ID
,      TRANSACTION_TEMP_ID
,      SHIP_SET_ID
,      ARRIVAL_SET_ID
,      SHIP_MODEL_COMPLETE_FLAG
,      TOP_MODEL_LINE_ID
,      HOLD_CODE
,      CUST_PO_NUMBER
,      ATO_LINE_ID
,      MOVE_ORDER_LINE_ID
,      HAZARD_CLASS_ID
,      QUALITY_CONTROL_QUANTITY
,      CYCLE_COUNT_QUANTITY
,      TRACKING_NUMBER
,      MOVEMENT_ID
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      PROJECT_ID
,      TASK_ID
,      ORG_ID
,      OE_INTERFACED_FLAG
,      SPLIT_FROM_DELIVERY_DETAIL_ID
,      INV_INTERFACED_FLAG
,      PARENT_CONTAINER_INSTANCE_ID
,      MASTER_SERIAL_NUMBER
,      CONTAINER_FLAG
,      CONTAINER_TYPE_CODE
,      SEAL_CODE
,      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
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PREFERRED_GRADE
,      SHIPPED_QUANTITY2
,      DELIVERED_QUANTITY2
,      CANCELLED_QUANTITY2
,      REQUESTED_QUANTITY2
,      REQUESTED_QUANTITY_UOM2
,      SRC_REQUESTED_QUANTITY2
,      SRC_REQUESTED_QUANTITY_UOM2
,      QUALITY_CONTROL_QUANTITY2
,      CYCLE_COUNT_QUANTITY2
,      UNIT_NUMBER
,      UNIT_PRICE
,      CURRENCY_CODE
,      FREIGHT_CLASS_CAT_ID
,      COMMODITY_CODE_CAT_ID
,      INSPECTION_FLAG
,      PICKABLE_FLAG
,      SHIP_TO_SITE_USE_ID
,      DELIVER_TO_SITE_USE_ID
,      TO_SERIAL_NUMBER
,      PICKED_QUANTITY
,      PICKED_QUANTITY2
,      CUSTOMER_PRODUCTION_LINE
,      CUSTOMER_JOB
,      CUST_MODEL_SERIAL_NUMBER
,      RECEIVED_QUANTITY
,      RECEIVED_QUANTITY2
,      SOURCE_LINE_SET_ID
,      BATCH_ID
,      SHIPMENT_BATCH_ID
,      LPN_ID
,      ORIGINAL_SUBINVENTORY
,      SERVICE_LEVEL
,      MODE_OF_TRANSPORT
,      IGNORE_FOR_PLANNING
,      LINE_DIRECTION
,      PARTY_ID
,      ROUTING_REQ_ID
,      SHIPPING_CONTROL
,      SOURCE_BLANKET_REFERENCE_ID
,      SOURCE_BLANKET_REFERENCE_NUM
,      PO_SHIPMENT_LINE_ID
,      PO_SHIPMENT_LINE_NUMBER
,      RETURNED_QUANTITY
,      RETURNED_QUANTITY2
,      SOURCE_LINE_TYPE_CODE
,      RCV_SHIPMENT_LINE_ID
,      SUPPLIER_ITEM_NUMBER
,      VENDOR_ID
,      SHIP_FROM_SITE_ID
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_DROPOFF_DATE
,      LATEST_DROPOFF_DATE
,      REQUEST_DATE_TYPE_CODE
,      TP_DELIVERY_DETAIL_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      PO_REVISION_NUMBER
,      RELEASE_REVISION_NUMBER
,      REPLENISHMENT_STATUS
,      REFERENCE_NUMBER
,      REFERENCE_LINE_NUMBER
,      REFERENCE_LINE_QUANTITY
,      REFERENCE_LINE_QUANTITY_UOM
,      ORIGINAL_LOCATOR_ID
,      ORIGINAL_REVISION
,      ORIGINAL_LOT_NUMBER
,      CLIENT_ID
,      CONSIGNEE_FLAG
FROM APPS.WSH_DLVY_DELIVERABLES_V;

Dependencies

[top of page]

APPS

WSH_DELIVERY_ASSIGNMENTS

WSH_DELIVERY_DETAILS

WSH_LOOKUPS

APPS

GR_REG_PRINT_DOC - show dependent code

QA_ERES_PKG - show dependent code

QA_ERES_WSH_DELIVERABLES_V

WSH_STOP_DELIVERABLES_V

WSH_TRIP_DELIVERABLES_V