eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WMS_SHIP_TO_SITES_V

Object Details

Object Name:	WMS_SHIP_TO_SITES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WMS.WMS_SHIP_TO_SITES_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
SITE_USE_ID	NUMBER	(15)	Yes	Site Use Identifier
STATUS	VARCHAR2	(1)	Yes	Status
ADDRESS_ID	NUMBER	(15)	Yes	Address Identifier
BILL_TO_SITE_USE_ID	NUMBER	(15)		Bill to site use Identifier
PRICE_LIST_ID	NUMBER	(15)		Price list Identifier
PAYMENT_TERM_ID	NUMBER	(15)		Payment term Identifier
FOB_POINT_CODE	VARCHAR2	(30)		FOB point code
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight terms code
SHIP_PARTIAL_ALLOWED	VARCHAR2	(1)		Ship partial allowed
SHIPPING_METHOD_CODE	VARCHAR2	(30)		Shipping method code
DEMAND_CLASS_CODE	VARCHAR2	(30)		Demand class code
SALESREP_ID	NUMBER	(15)		Sale Rep Identifier
CONTACT_ID	NUMBER	(15)
SOLD_FROM_ORG_ID	NUMBER	(15)
SHIP_FROM_ORG_ID	NUMBER	(15)
PRIMARY_FLAG	VARCHAR2	(1)	Yes
LOCATION_CODE	VARCHAR2	(40)	Yes
CUSTOMER_ID	NUMBER	(15)	Yes
ADDRESS_LINE_1	VARCHAR2	(240)	Yes
ADDRESS_LINE_2	VARCHAR2	(240)
ADDRESS_LINE_3	VARCHAR2	(240)
ADDRESS_LINE_4	VARCHAR2	(240)
TOWN_OR_CITY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
POSTAL_CODE	VARCHAR2	(60)
COUNTRY	VARCHAR2	(60)	Yes
OVER_SHIPMENT_TOLERANCE	NUMBER
UNDER_SHIPMENT_TOLERANCE	NUMBER
DATES_NEGATIVE_TOLERANCE	NUMBER
DATES_POSITIVE_TOLERANCE	NUMBER
DATE_TYPE_PREFERENCE	VARCHAR2	(20)
OVER_RETURN_TOLERANCE	NUMBER
UNDER_RETURN_TOLERANCE	NUMBER
ITEM_IDENTIFIER_TYPE	VARCHAR2	(30)
ORDER_TYPE_ID	NUMBER	(15)
ADDRESS_STATUS	VARCHAR2	(1)	Yes
GSA_INDICATOR	VARCHAR2	(1)		GSA_INDICATOR
CUSTOMER_NAME	VARCHAR2	(0)		Customer name
CUSTOMER_NUMBER	VARCHAR2	(0)		Customer number
ADDRESS_LINE_5	VARCHAR2	(183)		Address line 5

Query Text

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


SELECT SITE_USE_ID
,      STATUS
,      ADDRESS_ID
,      BILL_TO_SITE_USE_ID
,      PRICE_LIST_ID
,      PAYMENT_TERM_ID
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      SHIP_PARTIAL_ALLOWED
,      SHIPPING_METHOD_CODE
,      DEMAND_CLASS_CODE
,      SALESREP_ID
,      CONTACT_ID
,      SOLD_FROM_ORG_ID
,      SHIP_FROM_ORG_ID
,      PRIMARY_FLAG
,      LOCATION_CODE
,      CUSTOMER_ID
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      ADDRESS_LINE_4
,      TOWN_OR_CITY
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      OVER_SHIPMENT_TOLERANCE
,      UNDER_SHIPMENT_TOLERANCE
,      DATES_NEGATIVE_TOLERANCE
,      DATES_POSITIVE_TOLERANCE
,      DATE_TYPE_PREFERENCE
,      OVER_RETURN_TOLERANCE
,      UNDER_RETURN_TOLERANCE
,      ITEM_IDENTIFIER_TYPE
,      ORDER_TYPE_ID
,      ADDRESS_STATUS
,      GSA_INDICATOR
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ADDRESS_LINE_5
FROM APPS.WMS_SHIP_TO_SITES_V;

Dependencies

[top of page]

APPS.WMS_SHIP_TO_SITES_V references the following:

APPS: HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTY_SITES

APPS.WMS_SHIP_TO_SITES_V is not referenced by any database object