[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_BOLS_DB_V

Object Details

Object Name:	WSH_BOLS_DB_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_BOLS_DB_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 ROW_ID
,      BILL_OF_LADING_NUMBER
,      DOCUMENT_INSTANCE_ID
,      BOOKING_NUMBER
,      SERVICE_CONTRACT
,      CARRIER_EXPORT_REF
,      SHIPPER_EXPORT_REF
,      NOTIFY_PARTY
,      PROBLEM_CONTACT_REF
,      PORT_OF_LOADING
,      PORT_OF_DISCHARGE
,      AETC_NUMBER
,      SHIPPER_SIGNED_BY
,      SHIPPER_SIGNED_DATE
,      CARRIER_SIGNED_BY
,      CARRIER_SIGNED_DATE
,      POD_SIGNED_BY
,      POD_SIGNED_DATE
,      BOOKING_OFFICE
,      ISSUING_OFFICE
,      ISSUING_PERSON
,      DATE_ISSUED
,      POD_COMMENTS
,      SHIPPER_SIGNED_HM_BY
,      SHIPPER_SIGNED_HM_DATE
,      CARRIER_SIGNED_HM_BY
,      CARRIER_SIGNED_HM_DATE
,      DELIVERY_ID
,      DELIVERY_NAME
,      PICK_UP_LOCATION_ID
,      DROP_OFF_LOCATION_ID
,      CARRIER_ID
,      CARRIER_NAME
,      SHIP_METHOD
,      TRIP_ID
,      TRIP_NAME
,      DOCUMENT_TYPE
,      STATUS
,      FINAL_PRINT_DATE
,      ENTITY_NAME
,      ENTITY_ID
,      DOC_SEQUENCE_CATEGORY_ID
,      POD_FLAG
,      REASON_OF_TRANSPORT
,      COD_AMOUNT
,      COD_CURRENCY_CODE
,      COD_REMIT_TO
,      COD_CHARGE_PAID_BY
,      BILL_FREIGHT_TO
,      CARRIED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELIVERY_LEG_ID
,      SEQUENCE_NUMBER
,      LOADING_ORDER_FLAG
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      LOAD_TENDER_STATUS
,      LOAD_TENDER_STATUS_NAME
,      SHIPPER_TITLE
,      SHIPPER_PHONE
,      PICK_UP_STOP_ID
,      DROP_OFF_STOP_ID
,      EXPECTED_POD_DATE
,      FTE_TRIP_ID
,      REPRICE_REQUIRED
,      ACTUAL_ARRIVAL_DATE
,      ACTUAL_DEPARTURE_DATE
,      ACTUAL_RECEIPT_DATE
,      TRACKING_DRILLDOWN_FLAG
,      STATUS_CODE
,      TRACKING_REMARKS
,      CARRIER_EST_DEPARTURE_DATE
,      CARRIER_EST_ARRIVAL_DATE
,      LOADING_START_DATETIME
,      LOADING_END_DATETIME
,      UNLOADING_START_DATETIME
,      UNLOADING_END_DATETIME
,      DELIVERED_QUANTITY
,      LOADED_QUANTITY
,      RECEIVED_QUANTITY
,      ORIGIN_STOP_ID
,      DESTINATION_STOP_ID
,      PARENT_DELIVERY_LEG_ID
FROM APPS.WSH_BOLS_DB_V;

Dependencies

[top of page]

APPS

PO_VENDORS

WSH_DELIVERY_LEGS

WSH_DOCUMENT_INSTANCES

WSH_LOOKUPS

WSH_NEW_DELIVERIES

WSH_TRIPS

WSH_TRIP_STOPS

APPS

WSH_DELIVERIES_GRP - show dependent code