eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DEFAULT_TOLERANCE dependencies on ONT_LINE_DEF_HDLR

Line 25: l_inventory_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;

21: l_inventory_item_id NUMBER;
22: l_under_shipment_tolerance NUMBER;
23: l_under_return_tolerance NUMBER;
24: BEGIN
25: l_inventory_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
26: select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
27: from oe_cust_item_settings
28: where internal_item_id = l_inventory_item_id
29: and customer_id is null

Line 70: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;

66: l_customer_id NUMBER;
67: l_under_shipment_tolerance NUMBER;
68: l_under_return_tolerance NUMBER;
69: BEGIN
70: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;
71: select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
72: from oe_cust_item_settings
73: where customer_id = l_customer_id
74: and internal_item_id is null

Line 116: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;

112: l_under_shipment_tolerance NUMBER;
113: l_under_return_tolerance NUMBER;
114: BEGIN
115: if p_attribute_code = 'BILL_TO' then
116: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
117: elsif p_attribute_code = 'SHIP_TO' then
118: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;
119: else
120: return null;

Line 118: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;

114: BEGIN
115: if p_attribute_code = 'BILL_TO' then
116: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
117: elsif p_attribute_code = 'SHIP_TO' then
118: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;
119: else
120: return null;
121: end if;
122:

Line 168: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;

164: l_internal_item_id NUMBER;
165: l_under_shipment_tolerance NUMBER;
166: l_under_return_tolerance NUMBER;
167: BEGIN
168: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
169: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;
170: select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
171: from oe_cust_item_settings
172: where internal_item_id = l_internal_item_id

Line 169: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;

165: l_under_shipment_tolerance NUMBER;
166: l_under_return_tolerance NUMBER;
167: BEGIN
168: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
169: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;
170: select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance
171: from oe_cust_item_settings
172: where internal_item_id = l_internal_item_id
173: and customer_id = l_customer_id

Line 215: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;

211: l_internal_item_id NUMBER;
212: l_under_shipment_tolerance NUMBER;
213: l_under_return_tolerance NUMBER;
214: BEGIN
215: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
216: if p_attribute_code = 'BILL_TO' then
217: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
218: elsif p_attribute_code = 'SHIP_TO' then
219: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;

Line 217: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;

213: l_under_return_tolerance NUMBER;
214: BEGIN
215: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
216: if p_attribute_code = 'BILL_TO' then
217: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
218: elsif p_attribute_code = 'SHIP_TO' then
219: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;
220: else
221: return null;

Line 219: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;

215: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
216: if p_attribute_code = 'BILL_TO' then
217: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
218: elsif p_attribute_code = 'SHIP_TO' then
219: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;
220: else
221: return null;
222: end if;
223: select under_shipment_tolerance, under_return_tolerance into l_under_shipment_tolerance, l_under_return_tolerance

Line 266: l_inventory_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;

262: l_inventory_item_id NUMBER;
263: l_Over_shipment_tolerance NUMBER;
264: l_Over_return_tolerance NUMBER;
265: BEGIN
266: l_inventory_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
267: select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
268: from oe_cust_item_settings
269: where internal_item_id = l_inventory_item_id
270: and customer_id is null

Line 311: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;

307: l_customer_id NUMBER;
308: l_Over_shipment_tolerance NUMBER;
309: l_Over_return_tolerance NUMBER;
310: BEGIN
311: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;
312: select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
313: from oe_cust_item_settings
314: where customer_id = l_customer_id
315: and internal_item_id is null

Line 357: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;

353: l_Over_shipment_tolerance NUMBER;
354: l_Over_return_tolerance NUMBER;
355: BEGIN
356: if p_attribute_code = 'BILL_TO' then
357: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
358: elsif p_attribute_code = 'SHIP_TO' then
359: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;
360: else
361: return null;

Line 359: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;

355: BEGIN
356: if p_attribute_code = 'BILL_TO' then
357: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
358: elsif p_attribute_code = 'SHIP_TO' then
359: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;
360: else
361: return null;
362: end if;
363:

Line 409: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;

405: l_internal_item_id NUMBER;
406: l_Over_shipment_tolerance NUMBER;
407: l_Over_return_tolerance NUMBER;
408: BEGIN
409: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
410: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;
411: select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
412: from oe_cust_item_settings
413: where internal_item_id = l_internal_item_id

Line 410: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;

406: l_Over_shipment_tolerance NUMBER;
407: l_Over_return_tolerance NUMBER;
408: BEGIN
409: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
410: l_customer_id := ONT_Line_Def_Hdlr.g_record.sold_to_org_id;
411: select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance
412: from oe_cust_item_settings
413: where internal_item_id = l_internal_item_id
414: and customer_id = l_customer_id

Line 456: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;

452: l_internal_item_id NUMBER;
453: l_Over_shipment_tolerance NUMBER;
454: l_Over_return_tolerance NUMBER;
455: BEGIN
456: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
457: if p_attribute_code = 'BILL_TO' then
458: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
459: elsif p_attribute_code = 'SHIP_TO' then
460: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;

Line 458: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;

454: l_Over_return_tolerance NUMBER;
455: BEGIN
456: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
457: if p_attribute_code = 'BILL_TO' then
458: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
459: elsif p_attribute_code = 'SHIP_TO' then
460: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;
461: else
462: return null;

Line 460: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;

456: l_internal_item_id := ONT_Line_Def_Hdlr.g_record.inventory_item_id;
457: if p_attribute_code = 'BILL_TO' then
458: l_site_use_id := ONT_Line_Def_Hdlr.g_record.invoice_to_org_id;
459: elsif p_attribute_code = 'SHIP_TO' then
460: l_site_use_id := ONT_Line_Def_Hdlr.g_record.ship_to_org_id;
461: else
462: return null;
463: end if;
464: select Over_shipment_tolerance, Over_return_tolerance into l_Over_shipment_tolerance, l_Over_return_tolerance