DBA Data[Home] [Help]

VIEW: APPS.OE_AK_TOL_CUST_ITEMS_V

Source

View Text - Preformatted

SELECT CUSTOMER_ID, INTERNAL_ITEM_ID, INVENTORY_ORG_ID, OVER_SHIPMENT_TOLERANCE, OVER_RETURN_TOLERANCE, UNDER_SHIPMENT_TOLERANCE, UNDER_RETURN_TOLERANCE FROM OE_CUST_ITEM_SETTINGS WHERE SITE_USE_ID IS NULL
View Text - HTML Formatted

SELECT CUSTOMER_ID
, INTERNAL_ITEM_ID
, INVENTORY_ORG_ID
, OVER_SHIPMENT_TOLERANCE
, OVER_RETURN_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE
, UNDER_RETURN_TOLERANCE
FROM OE_CUST_ITEM_SETTINGS
WHERE SITE_USE_ID IS NULL