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.MSC_ATP_EXCEPTIONS dependencies on MSC_ITEM_EXCEPTIONS

Line 193: from msc_item_exceptions

189: -- Next try an dupdate the exception count
190: BEGIN
191: select 1
192: into l_tmp_var
193: from msc_item_exceptions
194: where plan_id = p_exception_rec.plan_id
195: and organization_id = p_exception_rec.organization_id
196: and sr_instance_id = p_exception_rec.sr_instance_id
197: and inventory_item_id = p_exception_rec.inventory_item_id

Line 223: -- insert into msc_item_exceptions

219: END;
220:
221: if (l_insert_item_exception = 1 ) THEN
222: BEGIN
223: -- insert into msc_item_exceptions
224: insert into msc_item_exceptions (
225: plan_id,
226: organization_id,
227: sr_instance_id,

Line 224: insert into msc_item_exceptions (

220:
221: if (l_insert_item_exception = 1 ) THEN
222: BEGIN
223: -- insert into msc_item_exceptions
224: insert into msc_item_exceptions (
225: plan_id,
226: organization_id,
227: sr_instance_id,
228: inventory_item_id,