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.EDW_ITEMS_M_SIZE dependencies on MTL_CATEGORIES_KFV

Line 211: mtl_categories_kfv cat,

207: avg(nvl(vsize(NULL), 0)) +
208: avg(nvl(vsize(NULL), 0)) +
209: 47
210: From
211: mtl_categories_kfv cat,
212: po_lines_all l,
213: edw_local_instance inst
214: WHERE cat.category_id = l.category_id
215: and l.item_id is null

Line 248: mtl_categories_kfv cat,

244: avg(nvl(vsize(NULL), 0)) +
245: avg(nvl(vsize(NULL), 0)) +
246: 17
247: From edw_local_instance inst,
248: mtl_categories_kfv cat,
249: po_lines_all l
250: WHERE cat.category_id = l.category_id
251: and l.item_id is null
252: and l.last_update_date between

Line 345: mtl_categories_kfv mtc,

341: avg(nvl(vsize(greatest(mtc.last_update_date, mts.last_update_date)), 0)) +
342: avg(nvl(vsize(NULL), 0)) +
343: 11
344: from
345: mtl_categories_kfv mtc,
346: mtl_category_sets mts,
347: edw_local_instance inst
348: WHERE mtc.structure_id = mts.structure_id
349: and mts.control_level = 1

Line 370: from mtl_categories_kfv mtc,

366: avg(nvl(vsize(mtc.creation_date), 0)) +
367: avg(nvl(vsize(greatest(mtc.last_update_date, mts.last_update_date)), 0)) +
368: avg(nvl(vsize(NULL), 0)) +
369: 11
370: from mtl_categories_kfv mtc,
371: mtl_category_sets mts,
372: edw_local_instance inst
373: WHERE mtc.structure_id = mts.structure_id
374: and mtc.last_update_date between

Line 400: mtl_categories_kfv cats,

396: avg(nvl(vsize(NULL), 0)) +
397: avg(nvl(vsize(NULL), 0)) +
398: 15
399: FROM
400: mtl_categories_kfv cats,
401: mtl_category_sets sets,
402: edw_local_instance inst
403: WHERE
404: cats.structure_id = sets.structure_id