[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.WMS_SHIP_TO_SITES_V is not referenced by any database object
|
|
|