View: WMS_SHIP_TO_SITES_V

Product:	WMS - Warehouse Management
Description:	Customer Ship to Site
Implementation/DBA Data:	APPS.WMS_SHIP_TO_SITES_V

View Text

SELECT SITE.SITE_USE_ID
, SITE.STATUS
, SITE.CUST_ACCT_SITE_ID
, SITE.BILL_TO_SITE_USE_ID
, SITE.PRICE_LIST_ID
, SITE.PAYMENT_TERM_ID
, SITE.FOB_POINT FOB_POINT_CODE
, SITE.FREIGHT_TERM FREIGHT_TERMS_CODE
, SITE.SHIP_PARTIAL SHIP_PARTIAL_ALLOWED
, SITE.SHIP_VIA SHIPPING_METHOD_CODE
, SITE.DEMAND_CLASS_CODE
, SITE.PRIMARY_SALESREP_ID
, SITE.CONTACT_ID
, SITE.WAREHOUSE_ID SOLD_FROM_ORG_ID
, SITE.WAREHOUSE_ID SHIP_FROM_ORG_ID
, SITE.PRIMARY_FLAG
, SITE.LOCATION LOCATION_CODE
, ACCT_SITE.CUST_ACCOUNT_ID
, LOC.ADDRESS1 ADDRESS_LINE_1
, LOC.ADDRESS2 ADDRESS_LINE_2
, LOC.ADDRESS3 ADDRESS_LINE_3
, LOC.ADDRESS4 ADDRESS_LINE_4
, LOC.CITY TOWN_OR_CITY
, LOC.STATE
, LOC.POSTAL_CODE
, LOC.COUNTRY
, SITE.OVER_SHIPMENT_TOLERANCE
, SITE.UNDER_SHIPMENT_TOLERANCE
, SITE.DATES_NEGATIVE_TOLERANCE
, SITE.DATES_POSITIVE_TOLERANCE
, SITE.DATE_TYPE_PREFERENCE
, SITE.OVER_RETURN_TOLERANCE
, SITE.UNDER_RETURN_TOLERANCE
, SITE.ITEM_CROSS_REF_PREF
, SITE.ORDER_TYPE_ID
, ACCT_SITE.STATUS
, SITE.GSA_INDICATOR
, NULL CUSTOMER_NAME
, NULL CUSTOMER_NUMBER
, LOC.CITY||'
, '||LOC.STATE||' '||LOC.POSTAL_CODE ADDRESS_LINE_5
FROM HZ_CUST_SITE_USES_ALL SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE SITE.SITE_USE_CODE = 'SHIP_TO'
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
AND NVL(SITE.ORG_ID
, -99) = NVL(ACCT_SITE.ORG_ID
, -99)

Columns