DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_BOLS_RD_V

Object Details
Object Name: WSH_BOLS_RD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_BOLS_RD_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
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
BILL_OF_LADING_NUMBER VARCHAR2 (50) Yes
DOCUMENT_INSTANCE_ID NUMBER
Yes
BOOKING_NUMBER VARCHAR2 (30)
SERVICE_CONTRACT VARCHAR2 (30)
CARRIER_EXPORT_REF VARCHAR2 (30)
SHIPPER_EXPORT_REF VARCHAR2 (30)
NOTIFY_PARTY VARCHAR2 (30)
PROBLEM_CONTACT_REF VARCHAR2 (500)
PORT_OF_LOADING VARCHAR2 (150)
PORT_OF_DISCHARGE VARCHAR2 (150)
AETC_NUMBER VARCHAR2 (30)
SHIPPER_SIGNED_BY VARCHAR2 (150)
SHIPPER_SIGNED_DATE DATE

CARRIER_SIGNED_BY VARCHAR2 (150)
CARRIER_SIGNED_DATE DATE

POD_SIGNED_BY VARCHAR2 (150)
POD_SIGNED_DATE DATE

BOOKING_OFFICE VARCHAR2 (50)
ISSUING_OFFICE VARCHAR2 (150)
ISSUING_PERSON VARCHAR2 (150)
DATE_ISSUED DATE

POD_COMMENTS VARCHAR2 (30)
SHIPPER_SIGNED_HM_BY VARCHAR2 (150)
SHIPPER_SIGNED_HM_DATE DATE

CARRIER_SIGNED_HM_BY VARCHAR2 (150)
CARRIER_SIGNED_HM_DATE DATE

CARRIER_TRACKING_NUMBER VARCHAR2 (30)
ADDITIONAL_SHIPMENT_INFO VARCHAR2 (500)
INCOTERMS VARCHAR2 (30)
DOCK_CODE VARCHAR2 (30)
EXPORT_CARRIER VARCHAR2 (30)
TRAILER_NUMBER VARCHAR2 (35)
DELIVERY_ID NUMBER
Yes
DELIVERY_NAME VARCHAR2 (30) Yes
PICK_UP_LOCATION_ID NUMBER
Yes
PICK_UP_LOCATION_CODE VARCHAR2 (181)
DROP_OFF_LOCATION_ID NUMBER
Yes
DROP_OFF_LOCATION_CODE VARCHAR2 (181)
CARRIER_ID NUMBER

SHIP_METHOD VARCHAR2 (30)
TRIP_ID NUMBER
Yes
TRIP_NAME VARCHAR2 (30) Yes
DOCUMENT_TYPE VARCHAR2 (30) Yes
STATUS VARCHAR2 (30)
FINAL_PRINT_DATE DATE

ENTITY_NAME VARCHAR2 (50) Yes
ENTITY_ID NUMBER
Yes
DOC_SEQUENCE_CATEGORY_ID NUMBER

POD_FLAG VARCHAR2 (1)
REASON_OF_TRANSPORT VARCHAR2 (30)
COD_AMOUNT NUMBER

COD_CURRENCY_CODE VARCHAR2 (15)
COD_REMIT_TO VARCHAR2 (150)
COD_CHARGE_PAID_BY VARCHAR2 (150)
BILL_FREIGHT_TO VARCHAR2 (1000)
CARRIED_BY VARCHAR2 (150)
DELIVERY_LEG_ID NUMBER
Yes
SEQUENCE_NUMBER NUMBER
Yes
LOADING_ORDER_FLAG VARCHAR2 (2)
GROSS_WEIGHT NUMBER

NET_WEIGHT NUMBER

WEIGHT_UOM_CODE VARCHAR2 (3)
VOLUME NUMBER

VOLUME_UOM_CODE VARCHAR2 (3)
LOAD_TENDER_STATUS VARCHAR2 (1)
POOLED_LOCATION VARCHAR2 (181)
SHIPPER_NAME VARCHAR2 (240) Yes
FROM_LOCATION VARCHAR2 (181)
FROM_ADDRESS_1 VARCHAR2 (240)
FROM_ADDRESS_2 VARCHAR2 (240)
FROM_ADDRESS_3 VARCHAR2 (240)
FROM_CITY VARCHAR2 (120)
FROM_REGION VARCHAR2 (120)
FROM_POSTAL_CODE VARCHAR2 (60)
FROM_COUNTRY VARCHAR2 (120)
CARRIER_NAME VARCHAR2 (0)
CARRIER_LOCATION VARCHAR2 (0)
CARRIER_ADDRESS_1 VARCHAR2 (0)
CARRIER_ADDRESS_2 VARCHAR2 (0)
CARRIER_ADDRESS_3 VARCHAR2 (0)
CARRIER_CITY VARCHAR2 (0)
CARRIER_REGION VARCHAR2 (0)
CARRIER_POSTAL_CODE VARCHAR2 (0)
CARRIER_COUNTRY VARCHAR2 (0)
CUSTOMER_NAME VARCHAR2 (50)
TO_LOCATION VARCHAR2 (181)
TO_ADDRESS_1 VARCHAR2 (240)
TO_ADDRESS_2 VARCHAR2 (240)
TO_ADDRESS_3 VARCHAR2 (240)
TO_CITY VARCHAR2 (120)
TO_REGION VARCHAR2 (120)
TO_POSTAL_CODE VARCHAR2 (60)
TO_COUNTRY VARCHAR2 (120)
ORGANIZATION_ID NUMBER

CARRIER_REFERENCE_NUMBER VARCHAR2 (30)
TRIP_SEAL_CODE VARCHAR2 (30)
DEPARTURE_SEAL_CODE VARCHAR2 (30)
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
,      CARRIER_TRACKING_NUMBER
,      ADDITIONAL_SHIPMENT_INFO
,      INCOTERMS
,      DOCK_CODE
,      EXPORT_CARRIER
,      TRAILER_NUMBER
,      DELIVERY_ID
,      DELIVERY_NAME
,      PICK_UP_LOCATION_ID
,      PICK_UP_LOCATION_CODE
,      DROP_OFF_LOCATION_ID
,      DROP_OFF_LOCATION_CODE
,      CARRIER_ID
,      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
,      DELIVERY_LEG_ID
,      SEQUENCE_NUMBER
,      LOADING_ORDER_FLAG
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      LOAD_TENDER_STATUS
,      POOLED_LOCATION
,      SHIPPER_NAME
,      FROM_LOCATION
,      FROM_ADDRESS_1
,      FROM_ADDRESS_2
,      FROM_ADDRESS_3
,      FROM_CITY
,      FROM_REGION
,      FROM_POSTAL_CODE
,      FROM_COUNTRY
,      CARRIER_NAME
,      CARRIER_LOCATION
,      CARRIER_ADDRESS_1
,      CARRIER_ADDRESS_2
,      CARRIER_ADDRESS_3
,      CARRIER_CITY
,      CARRIER_REGION
,      CARRIER_POSTAL_CODE
,      CARRIER_COUNTRY
,      CUSTOMER_NAME
,      TO_LOCATION
,      TO_ADDRESS_1
,      TO_ADDRESS_2
,      TO_ADDRESS_3
,      TO_CITY
,      TO_REGION
,      TO_POSTAL_CODE
,      TO_COUNTRY
,      ORGANIZATION_ID
,      CARRIER_REFERENCE_NUMBER
,      TRIP_SEAL_CODE
,      DEPARTURE_SEAL_CODE
FROM APPS.WSH_BOLS_RD_V;

Dependencies

[top of page]

APPS.WSH_BOLS_RD_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymWSH_DELIVERY_LEGS
SynonymWSH_DOCUMENT_INSTANCES
SynonymWSH_LOCATIONS
SynonymWSH_NEW_DELIVERIES
SynonymWSH_TRIPS
SynonymWSH_TRIP_STOPS
APPS.WSH_BOLS_RD_V is referenced by following:

SchemaAPPS
Package BodyFTE_TRACKING_WRAPPER - show dependent code