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_EXP_WF dependencies on MFG_LOOKUPS

Line 167: mfg_lookups ml,

163: msc_demands md,
164: msc_exception_details exp,
165: msc_system_items mi,
166: msc_trading_partners mtp,
167: mfg_lookups ml,
168: mfg_lookups sup_ml
169: WHERE exp.exception_type in
170: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
171: AND exp.plan_id = p_plan_id

Line 168: mfg_lookups sup_ml

164: msc_exception_details exp,
165: msc_system_items mi,
166: msc_trading_partners mtp,
167: mfg_lookups ml,
168: mfg_lookups sup_ml
169: WHERE exp.exception_type in
170: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
171: AND exp.plan_id = p_plan_id
172: AND exp.exception_detail_id = p_exception_id

Line 340: mfg_lookups ml,

336: msc_demands md,
337: msc_exception_details exp,
338: msc_system_items mi,
339: msc_trading_partners mtp,
340: mfg_lookups ml,
341: mfg_lookups sup_ml
342: WHERE exp.exception_type in
343: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
344: AND exp.plan_id = p_plan_id

Line 341: mfg_lookups sup_ml

337: msc_exception_details exp,
338: msc_system_items mi,
339: msc_trading_partners mtp,
340: mfg_lookups ml,
341: mfg_lookups sup_ml
342: WHERE exp.exception_type in
343: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
344: AND exp.plan_id = p_plan_id
345: AND exp.exception_detail_id in (SELECT number1

Line 515: mfg_lookups ml,

511: msc_demands md,
512: msc_exception_details exp,
513: msc_system_items mi,
514: msc_trading_partners mtp,
515: mfg_lookups ml,
516: mfg_lookups sup_ml
517: WHERE exp.exception_type in
518: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
519: AND exp.plan_id = p_plan_id

Line 516: mfg_lookups sup_ml

512: msc_exception_details exp,
513: msc_system_items mi,
514: msc_trading_partners mtp,
515: mfg_lookups ml,
516: mfg_lookups sup_ml
517: WHERE exp.exception_type in
518: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
519: AND exp.plan_id = p_plan_id
520: AND sup.plan_id (+) = exp.plan_id