APPS.CN_NOTIFY_ORDERS dependencies on ASO_I_OE_SALES_CREDITS_V

Line 396: FROM aso_i_oe_sales_credits_v assc

392: AND (asol.top_model_line_id IS NULL OR
393: asol.top_model_line_id = asol.line_id)
394: AND NOT EXISTS
395: (SELECT 1
396: FROM aso_i_oe_sales_credits_v assc
397: WHERE assc.line_id = asol.line_id))
398: LOOP
399: notify_affected_lines(p_header_id, rec.line_id, l_org_id);
400: END LOOP;

Line 442: FROM aso_i_oe_sales_credits_v assc

438: WHERE asol.service_reference_line_id = p_line_id
439: AND asol.org_id = p_org_id
440: AND NOT EXISTS
441: (SELECT 1
442: FROM aso_i_oe_sales_credits_v assc
443: WHERE assc.line_id = asol.line_id))
444: LOOP
445: notify_line(rec.header_id, rec.line_id,x_org_id => l_org_id);
446: END LOOP;

Line 464: FROM aso_i_oe_sales_credits_v assc

460: AND asol.org_id = p_org_id
461: AND asol.header_id = p_header_id -- makes use of index
462: AND NOT EXISTS
463: (SELECT 1
464: FROM aso_i_oe_sales_credits_v assc
465: WHERE assc.line_id = asol.line_id)
466: AND asol.line_id <> p_line_id) -- don't re-collect ourself
467: LOOP
468: notify_line(p_header_id, rec.line_id,x_org_id => l_org_id);