APPS.OE_DEFAULT_TOLERANCE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

	select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
	from oe_cust_item_settings
	where internal_item_id = l_inventory_item_id
		and customer_id is null
		and site_use_id is null;

Line: 71

	select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
	from oe_cust_item_settings
	where customer_id = l_customer_id
		and internal_item_id is null
		and site_use_id is null;

Line: 123

	select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
	from oe_cust_item_settings
	where site_use_id = l_site_use_id
		and customer_id is null
		and internal_item_id is null;

Line: 170

	select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
	from oe_cust_item_settings
	where internal_item_id = l_internal_item_id
		and customer_id = l_customer_id
		and site_use_id is null;

Line: 223

	select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
	from oe_cust_item_settings
	where internal_item_id = l_internal_item_id
		and site_use_id = l_site_use_id;

Line: 267

	select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
	from oe_cust_item_settings
	where internal_item_id = l_inventory_item_id
		and customer_id is null
		and site_use_id is null;

Line: 312

	select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
	from oe_cust_item_settings
	where customer_id = l_customer_id
		and internal_item_id is null
		and site_use_id is null;

Line: 364

	select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
	from oe_cust_item_settings
	where site_use_id = l_site_use_id
		and customer_id is null
		and internal_item_id is null;

Line: 411

	select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
	from oe_cust_item_settings
	where internal_item_id = l_internal_item_id
		and customer_id = l_customer_id
		and site_use_id is null;

Line: 464

	select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
	from oe_cust_item_settings
	where internal_item_id = l_internal_item_id
		and site_use_id = l_site_use_id;