309: 45
310: FROM
311: mtl_system_items_kfv mti,
312: mtl_item_categories mic,
313: mtl_category_sets sets,
314: mtl_parameters mtp,
315: mtl_parameters mtm,
316: edw_local_instance inst
317: WHERE
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
350: and mtc.last_update_date between
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
375: p_from_date and p_to_date;
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
405: and sets.category_set_name = 'Product Family'