[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_DSNO_DELIVERIES_V

Object Details

Object Name:	WSH_DSNO_DELIVERIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_DSNO_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 TRANSACTION_TYPE
,      COMMUNICATION_METHOD
,      TRANSACTION_DATE
,      TP_HEADER_ID
,      TP_DETAIL_ID
,      DOCUMENT_CODE
,      TP_TEST_FLAG
,      TP_DOCUMENT_TYPE
,      TP_CODE
,      TP_LOCATION_CODE_EXT
,      TP_DESCRIPTION
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      TP_TRANSLATOR_CODE
,      TP_EDI_FLAG
,      TP_PRINT_FLAG
,      TP_CONTACT_NAME
,      TP_CONTACT_JOB_TITLE
,      TP_ADDRESS1
,      TP_ADDRESS2
,      TP_ADDRESS3
,      TP_ADDRESS4
,      TP_CITY
,      TP_STATE
,      TP_PROVINCE
,      TP_COUNTRY
,      TP_POSTAL_CODE
,      TP_PHONE
,      TP_FAX
,      TP_EMAIL
,      TP_HEADER_CATEGORY
,      TP_HEADER_ATTRIBUTE1
,      TP_HEADER_ATTRIBUTE2
,      TP_HEADER_ATTRIBUTE3
,      TP_HEADER_ATTRIBUTE4
,      TP_HEADER_ATTRIBUTE5
,      TP_HEADER_ATTRIBUTE6
,      TP_HEADER_ATTRIBUTE7
,      TP_HEADER_ATTRIBUTE8
,      TP_HEADER_ATTRIBUTE9
,      TP_HEADER_ATTRIBUTE10
,      TP_HEADER_ATTRIBUTE11
,      TP_HEADER_ATTRIBUTE12
,      TP_HEADER_ATTRIBUTE13
,      TP_HEADER_ATTRIBUTE14
,      TP_HEADER_ATTRIBUTE15
,      DOCUMENT_STANDARD
,      TP_DETAIL_CATEGORY
,      TP_DETAIL_ATTRIBUTE1
,      TP_DETAIL_ATTRIBUTE2
,      TP_DETAIL_ATTRIBUTE3
,      TP_DETAIL_ATTRIBUTE4
,      TP_DETAIL_ATTRIBUTE5
,      ORGANIZATION_ID
,      TRIP_ID
,      TRIP_NAME
,      DEPARTURE_DATE
,      DELIVERY_ID
,      DELIVERY_NAME
,      TIME_STAMP_SEQUENCE_NUMBER
,      TIME_STAMP_DATE
,      EQUIPMENT_PREFIX
,      EQUIPMENT_NUMBER
,      EQUIPMENT_SEAL
,      CARRIER_NAME_INT
,      PICK_UP_LOCAION_ID
,      PICK_UP_STOP_ID
,      DROP_OFF_LOCATION_ID
,      DROP_OFF_STOP_ID
,      DEPARTURE_GROSS_WEIGHT
,      DEPARTURE_GROSS_WEIGHT_UOM_INT
,      DEPARTURE_NET_WEIGHT
,      DEPARTURE_NET_WEIGHT_UOM_INT
,      DEPARTURE_TARE_WEIGHT
,      DEPARTURE_TARE_WEIGHT_UOM_INT
,      DEPARTURE_VOLUME
,      DEPARTURE_VOLUME_UOM_INT
,      ROUTING_INSTRUCTIONS1
,      ROUTING_INSTRUCTIONS2
,      ROUTING_INSTRUCTIONS3
,      ROUTING_INSTRUCTIONS4
,      ROUTING_INSTRUCTIONS5
,      WAREHOUSE_LOCATION_ID
,      WAREHOUSE_CODE_INT
,      WAREHOUSE_EDI_LOC_CODE
,      WAREHOUSE_TP_REF_1
,      WAREHOUSE_TP_REF_2
,      WAREHOUSE_NAME
,      WAREHOUSE_ADDRESS1
,      WAREHOUSE_ADDRESS2
,      WAREHOUSE_ADDRESS3
,      WAREHOUSE_CITY
,      WAREHOUSE_POSTAL_CODE
,      WAREHOUSE_COUNTRY_INT
,      WAREHOUSE_REGION1_INT
,      WAREHOUSE_REGION2_INT
,      WAREHOUSE_REGION3_INT
,      WAREHOUSE_TELEPHONE_1
,      WAREHOUSE_TELEPHONE_2
,      WAREHOUSE_TELEPHONE_3
,      DELIVERY_ADDRESS_ID
,      DELIVERY_CODE_INT
,      DELIVERY_EDI_LOC_CODE
,      DELIVERY_TP_REF_1
,      DELIVERY_TP_REF_2
,      DELIVERY_CUST_NAME
,      DELIVERY_ADDRESS1
,      DELIVERY_ADDRESS2
,      DELIVERY_ADDRESS3
,      DELIVERY_ADDRESS4
,      DELIVERY_CITY
,      DELIVERY_POSTAL_CODE
,      DELIVERY_COUNTRY_INT
,      DELIVERY_STATE_INT
,      DELIVERY_PROVINCE_INT
,      DELIVERY_COUNTY
,      DELIVERY_AREA_CODE
,      DELIVERY_TELEPHONE
,      DESTINATION_ADDRESS_ID
,      DESTINATION_CUSTOMER_ID
,      DESTINATION_SITE_USE_ID
,      DESTINATION_CODE_INT
,      DESTINATION_EDI_LOC_CODE
,      DESTINATION_TP_REF_1
,      DESTINATION_TP_REF_2
,      DESTINATION_NAME
,      DESTINATION_ADDRESS1
,      DESTINATION_ADDRESS2
,      DESTINATION_ADDRESS3
,      DESTINATION_ADDRESS4
,      DESTINATION_CITY
,      DESTINATION_POSTAL_CODE
,      DESTINATION_COUNTRY_INT
,      DESTINATION_STATE_INT
,      DESTINATION_PROVINCE_INT
,      DESTINATION_COUNTY
,      DESTINATION_AREA_CODE
,      DESTINATION_TELEPHONE
,      SHIPPER_NUMBER
,      WAYBILL_NUMBER
,      BILL_OF_LADING
,      PACKING_SLIP_NUMBER
,      ACTUAL_SHIP_DATE
,      DELIVERY_GROSS_WEIGHT
,      DELIVERY_GROSS_WEIGHT_UOM_INT
,      DELIVERY_VOLUME
,      DELIVERY_VOLUME_UOM_INT
,      DELIVERY_NET_WEIGHT
,      DELIVERY_NET_WEIGHT_UOM_INT
,      DELIVERY_TARE_WEIGHT
,      DELIVERY_TARE_WEIGHT_UOM_INT
,      EXPECTED_ARRIVAL_DATE
,      FREIGHT_TERMS_CODE_INT
,      NUMBER_OF_LPN
,      SHIP_METHOD_CODE_INT
,      FOB_POINT_CODE_INT
,      FOB_LOCATION_ID
,      POOLED_SHIP_TO_LOCATION_ID
,      INTMED_SHIP_TO_LOCATION_ID
,      VEHICLE_ORGANIZATION_ID
,      VEHICLE_ITEM_ID
,      CONTACT_ID
,      SHIP_METHOD_NAME_INT
FROM APPS.WSH_DSNO_DELIVERIES_V;

Dependencies

[top of page]

APPS

ECE_TP_DETAILS

ECE_TP_HEADERS

HR_GENERAL - show dependent code

HR_LOCATIONS_ALL

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

HZ_CUST_ACCOUNTS

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_PARTIES

HZ_PARTY_SITES

MTL_PARAMETERS

WSH_CARRIER_SERVICES

WSH_DELIVERY_ASSIGNMENTS_V

WSH_DELIVERY_DETAILS

WSH_DELIVERY_LEGS

WSH_DOCUMENT_INSTANCES

WSH_ECE_VIEWS_DEF - show dependent code

WSH_LOCATIONS

WSH_NEW_DELIVERIES

WSH_TRIPS

WSH_TRIP_STOPS

APPS.WSH_DSNO_DELIVERIES_V is not referenced by any database object