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_CL_POST_PUBLISH dependencies on MSC_X_EXCEPTION_DETAILS

Line 15: from msc_x_exception_details

11: company_site_id,
12: exception_group,
13: exception_type,
14: count(*)
15: from msc_x_exception_details
16: where plan_id = -1
17: and exception_group IN (1,2,4,6,7,8)
18: group by plan_id,
19: inventory_item_id,

Line 137: ' delete msc_x_exception_details '

133:
134: BEGIN
135:
136: v_sql_stmt :=
137: ' delete msc_x_exception_details '
138: ||' where exception_type '|| G_EXCEP_TYPES
139: ||' and exception_group '|| G_EXCEP_GROUPS
140: ||' and company_id = 1 '
141: ||' and company_site_id '|| l_site_string

Line 165: ' delete msc_x_exception_details '

161:
162: BEGIN
163:
164: v_sql_stmt :=
165: ' delete msc_x_exception_details '
166: ||' where exception_type '|| G_EXCEP_TYPES
167: ||' and exception_group '|| G_EXCEP_GROUPS
168: ||' and customer_id = 1 '
169: ||' and customer_site_id '||l_site_string

Line 196: ' delete msc_x_exception_details '

192:
193: BEGIN
194:
195: v_sql_stmt :=
196: ' delete msc_x_exception_details '
197: ||' where exception_type '|| G_EXCEP_TYPES
198: ||' and exception_group '|| G_EXCEP_GROUPS
199: ||' and supplier_id = 1 '
200: ||' and supplier_site_id '|| l_site_string

Line 228: from msc_x_exception_details med

224: where
225: plan_id = -1
226: and exception_group in (1,2,4,6,7,8)
227: and not exists( select 1
228: from msc_x_exception_details med
229: where med.company_id = mie.company_id
230: and med.company_site_id = mie.company_site_id
231: and med.plan_id = mie.plan_id
232: and med.plan_id = -1

Line 319: ' delete msc_x_exception_details med '

315:
316: BEGIN
317:
318: v_sql_stmt :=
319: ' delete msc_x_exception_details med '
320: ||' where transaction_id1 is not null'
321: ||' and exception_type '||G_DUPLICATE_EXCEP_TYPES
322: ||' and exception_group '||G_EXCEP_GROUPS
323: ||' and not exists ( select 1 '

Line 347: ' delete msc_x_exception_details med '

343:
344: BEGIN
345:
346: v_sql_stmt :=
347: ' delete msc_x_exception_details med '
348: ||' where transaction_id2 is not null '
349: ||' and exception_type '||G_DUPLICATE_EXCEP_TYPES
350: ||' and exception_group '||G_EXCEP_GROUPS
351: ||' and not exists ( select 1 '