[Home] [Help]
View: OE_AK_SOLD_TO_SITE_USES_V
Product: | ONT - Order Management |
Description: | Selects defaultable attributes from customer location; |
Implementation/DBA Data: |
APPS.OE_AK_SOLD_TO_SITE_USES_V
|
View Text
SELECT SITE_USE_ID
, PRICE_LIST_ID
, FOB_POINT
, FREIGHT_TERM
, SHIP_VIA
, CONTACT_ID
, PAYMENT_TERM_ID
, PRIMARY_SALESREP_ID
, ORDER_TYPE_ID
, OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE
FROM HZ_CUST_SITE_USES
WHERE SITE_USE_CODE = 'SOLD_TO'
Columns
Name |
SOLD_TO_SITE_USE_ID |
PRICE_LIST_ID |
FOB_POINT_CODE |
FREIGHT_TERMS_CODE |
SHIPPING_METHOD_CODE |
CONTACT_ID |
PAYMENT_TERM_ID |
SALESREP_ID |
ORDER_TYPE_ID |
OVER_SHIPMENT_TOLERANCE |
UNDER_SHIPMENT_TOLERANCE |