[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_OPSM_ASN_DELIVERIES_V

Object Details

Object Name:	WSH_OPSM_ASN_DELIVERIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_OPSM_ASN_DELIVERIES_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Query Text

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

SELECT TRANSACTION_DATE
,      DOCUMENT_CODE
,      ORGANIZATION_ID
,      DELIVERY_ID
,      DELIVERY_NAME
,      ORGANIZATION_CODE
,      WAREHOUSE_LOCATION_ID
,      WAREHOUSE_CODE
,      WAREHOUSE_NAME
,      WAREHOUSE_ADDRESS1
,      WAREHOUSE_ADDRESS2
,      WAREHOUSE_ADDRESS3
,      WAREHOUSE_ADDRESS4
,      WAREHOUSE_CITY
,      WAREHOUSE_POSTAL_CODE
,      WAREHOUSE_COUNTRY
,      WAREHOUSE_COUNTY
,      WAREHOUSE_STATE
,      WAREHOUSE_CONTACT_NAME
,      WAREHOUSE_CONTACT_EMAILID
,      WAREHOUSE_CONTACT_PHONENUMBER
,      DESTINATION_CODE
,      DESTINATION_NAME
,      DESTINATION_ADDRESS1
,      DESTINATION_ADDRESS2
,      DESTINATION_ADDRESS3
,      DESTINATION_ADDRESS4
,      DESTINATION_CITY
,      DESTINATION_POSTAL_CODE
,      DESTINATION_COUNTRY
,      DESTINATION_STATE
,      DESTINATION_PROVINCE
,      DESTINATION_COUNTY
,      DESTINATION_CONT_ID
,      DESTINATION_CONT_AREA_CODE
,      DESTINATION_CONT_PHONE_NUMBER
,      DESTINATION_CONT_NAME
,      DESTINATION_CONT_EMAIL
,      DESTINATION_CONT_COUNTRY_CODE
,      DESTINATION_CONT_PHONE_EXTN
,      BILL_OF_LADING
,      FREIGHT_TERMS_CODE
,      FOB_POINT_CODE
,      INITIAL_PICKUP_DATE
,      PORT_OF_LOADING
,      CHANGE_OF_OWNERSHIP
,      DOCK_CODE
,      STATUS_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      INVOICE_TO_ORG_ID
,      INVOICE_TO_CONTACT_ID
,      INVOICE_NAME
,      INVOICE_ADDRESS1
,      INVOICE_ADDRESS2
,      INVOICE_ADDRESS3
,      INVOICE_ADDRESS4
,      INVOICE_CITY
,      INVOICE_POSTAL_CODE
,      INVOICE_COUNTRY_INT
,      INVOICE_STATE_INT
,      INVOICE_PROVINCE_INT
,      INVOICE_COUNTY
,      INVOICE_CONT_NAME
,      INVOICE_CONT_JOB_TITLE
,      INVOICE_CONT_EMAIL_ADDRESS
,      INVOICE_CONT_COUNTRY_CODE
,      INVOICE_CONT_AREA_CODE
,      INVOICE_CONT_PHONE_NUMBER
,      INVOICE_CONT_PHONE_EXTN
,      SOLDTO_CUSTOMER_ID
,      SOLDTO_CONTACT_ID
,      SOLDTO_ADDRESS_ID
,      SOLDTO_NAME
,      SOLDTO_ADDRESS1
,      SOLDTO_ADDRESS2
,      SOLDTO_ADDRESS3
,      SOLDTO_ADDRESS4
,      SOLDTO_CITY
,      SOLDTO_POSTAL_CODE
,      SOLDTO_COUNTRY
,      SOLDTO_STATE
,      SOLDTO_PROVINCE
,      SOLDTO_COUNTY
,      SOLDTO_CONT_NAME
,      SOLDTO_CONT_JOB_TITLE
,      SOLDTO_CONT_EMAIL
,      SOLDTO_CONT_COUNTRY_CODE
,      SOLDTO_CONT_AREA_CODE
,      SOLDTO_CONT_PHONE_NUMBER
,      SOLDTO_CONT_PHONE_EXTN
,      SOLDBY_LOCATION_CODE
,      SOLDBY_COUNTRY
,      SOLDBY_ADDRESS_LINE_1
,      SOLDBY_ADDRESS_LINE_2
,      SOLDBY_ADDRESS_LINE_3
,      SOLDBY_ADDRESS_LINE_4
,      SOLDBY_COUNTY
,      SOLDBY_STATE
,      SOLDBY_POSTAL_CODE
,      SOLDBY_CITY
,      SOLDBY_ORGANIZATION_ID
,      SOLDBY_NAME
,      SOLDBY_CONTACT_NAME
,      SOLDBY_CONTACT_EMAILID
,      SOLDBY_CONTACT_PHONENUMBER
,      DELIVERY_DETAIL_ID
FROM APPS.WSH_OPSM_ASN_DELIVERIES_V;

Dependencies

[top of page]

APPS

AR_CUSTOMERS_ACTIVE_V

HR_API - show dependent code

HR_GENERAL - show dependent code

HR_LOCATIONS_ALL

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

HZ_CONTACT_POINTS

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_ORG_CONTACTS

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

MTL_PARAMETERS

PER_ALL_PEOPLE_F

PER_PHONES

WSH_DELIVERY_ASSIGNMENTS

WSH_DELIVERY_DETAILS

WSH_DELIVERY_LEGS

WSH_DOCUMENT_INSTANCES

WSH_LOCATIONS

WSH_NEW_DELIVERIES

WSH_OPSM_ASN_ORDERS_COMM_V

WSH_OPSM_ASN_ORDERS_SPECIFIC_V

WSH_TRIPS

WSH_TRIP_STOPS

APPS

WSH_OPSM_ASN_BE_PKG - show dependent code