[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 |