[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select sum(cnt)
from (
select count(*) cnt
from
mtl_system_items m
where m.last_update_date between
p_from_date and p_to_date ) ;
SELECT
avg(nvl(vsize(mti.inventory_item_id ||'-'||mti.organization_id ||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(inst.instance_code), 0)) +
avg(nvl(vsize(mti.inventory_item_id ||'-'||edw_items_pkg.get_master_parent(mti.organization_id) ||'-'||inst.instance_code), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize(substr(mti.concatenated_segments ||'('||mtp.organization_code||')',1,240)), 0)) +
avg(nvl(vsize(substr(mti.concatenated_segments ||'('||mtp.organization_code||')',1,80)), 0)) +
avg(nvl(vsize(decode(mti.buyer_id, NULL, 'NA_EDW', to_char(mti.buyer_id)||'?')), 0)) +
avg(nvl(vsize(decode(mti.planner_code, NULL, 'NA_EDW', mti.planner_code||'?')), 0)) +
avg(nvl(vsize(substr(mti.concatenated_segments ||'('||mtp.organization_code||')',1,240)), 0)) +
avg(nvl(vsize(mti.description), 0)) +
avg(nvl(vsize(mti.inventory_item_id), 0)) +
avg(nvl(vsize(mti.organization_id), 0)) +
avg(nvl(vsize(mti.planning_make_buy_code), 0)) +
avg(nvl(vsize(mti.list_price_per_unit), 0)) +
avg(nvl(vsize(mti.market_price), 0)) +
avg(nvl(vsize(mti.taxable_flag), 0)) +
avg(nvl(vsize(mti.stock_enabled_flag), 0)) +
avg(nvl(vsize(mti.internal_order_enabled_flag), 0)) +
avg(nvl(vsize(mti.inventory_planning_code), 0)) +
avg(nvl(vsize(mti.lot_control_code), 0)) +
avg(nvl(vsize(mti.outside_operation_flag), 0)) +
avg(nvl(vsize(mti.price_tolerance_percent), 0)) +
avg(nvl(vsize(mti.purchasing_enabled_flag), 0)) +
avg(nvl(vsize(mti.shelf_life_code), 0)) +
avg(nvl(vsize(mti.shelf_life_days), 0)) +
avg(nvl(vsize(mti.tax_code), 0)) +
avg(nvl(vsize(mti.revision_qty_control_code), 0)) +
avg(nvl(vsize(mti.inspection_required_flag), 0)) +
avg(nvl(vsize(mti.receipt_required_flag), 0)) +
avg(nvl(vsize(mti.location_control_code), 0)) +
avg(nvl(vsize(mti.effectivity_control), 0)) +
avg(nvl(vsize(mti.serial_number_control_code), 0)) +
avg(nvl(vsize(mti.mrp_planning_code), 0)) +
avg(nvl(vsize(mti.must_use_approved_vendor_flag), 0)) +
avg(nvl(vsize(mti.allow_substitute_receipts_flag), 0)) +
avg(nvl(vsize(mti.allow_unordered_receipts_flag), 0)) +
avg(nvl(vsize(mti.allow_express_delivery_flag), 0)) +
avg(nvl(vsize(mti.hazard_class_id), 0)) +
avg(nvl(vsize(mti.un_number_id), 0)) +
avg(nvl(vsize(mti.rfq_required_flag), 0)) +
avg(nvl(vsize(mti.creation_date), 0)) +
avg(nvl(vsize(mti.last_update_date), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(mti.segment1), 0)) +
45
from mtl_system_items_b_kfv mti,
mtl_parameters mtp,
mtl_parameters mtm,
edw_local_instance inst
WHERE
mti.product_family_item_id is NULL
and mti.organization_id=mtp.organization_id
and mtp.master_organization_id=mtm.organization_id
and mti.last_update_date between
p_from_date and p_to_date;
SELECT
avg(nvl(vsize(mtr.revision||'-'|| mtr.inventory_item_id ||'-'|| mtr.organization_id ||'-'|| inst.instance_code), 0)) +
avg(nvl(vsize(inst.instance_code), 0)) +
avg(nvl(vsize(mtr.inventory_item_id||'-'||mtr.organization_id||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(substr(mtr.revision || '(' || mti.concatenated_segments || ',' ||mp.organization_code || ')',1,240)), 0)) +
avg(nvl(vsize(substr(mtr.revision || '(' || mti.concatenated_segments || ',' || mp.organization_code || ')',1,80)), 0)) +
avg(nvl(vsize(substr(mtr.revision || '(' || mti.concatenated_segments || ',' || mp.organization_code || ')',1,240)), 0)) +
avg(nvl(vsize(mtr.effectivity_date), 0)) +
avg(nvl(vsize(mtr.creation_date), 0)) +
avg(nvl(vsize(mtr.last_update_date), 0)) +
avg(nvl(vsize(NULL), 0)) +
10
FROM
mtl_system_items_kfv mti,
mtl_item_revisions mtr,
mtl_parameters mp,
edw_local_instance inst
WHERE
mti.inventory_item_id = mtr.inventory_item_id
and mti.organization_id = mtr.organization_id
and mtr.organization_id = mp.organization_id
and mtr.last_update_date between
p_from_date and p_to_date;
SELECT
avg(nvl(vsize(mti.inventory_item_id||'-'||mti.organization_id||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(inst.instance_code), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize(substr(mti.CONCATENATED_SEGMENTS||'('||mtp.organization_code||')',1,240)), 0)) +
avg(nvl(vsize(substr(mti.CONCATENATED_SEGMENTS||'('||mtp.organization_code||')',1,80)), 0)) +
avg(nvl(vsize(substr(mti.CONCATENATED_SEGMENTS||'('||mtp.organization_code||')',1,240)), 0)) +
avg(nvl(vsize(mti.description), 0)) +
avg(nvl(vsize(mti.ORGANIZATION_ID), 0)) +
avg(nvl(vsize(mti.inventory_item_id), 0)) +
avg(nvl(vsize(mti.last_update_date), 0)) +
avg(nvl(vsize(mti.creation_date), 0)) +
avg(nvl(vsize(NULL), 0)) +
15
from mtl_system_items_kfv mti,
mtl_parameters mtp,
edw_local_instance inst
WHERE mtp.organization_id = mtp.master_organization_id
and mti.organization_id = mtp.organization_id
and mti.last_update_date between
p_from_date and p_to_date;
SELECT DISTINCT
avg(nvl(vsize(l.ITEM_DESCRIPTION || '-' || cat.category_id || '-' || l.org_id || '-' || inst.instance_code || '-ONETIME'), 0)) +
avg(nvl(vsize(inst.instance_code), 0)) +
avg(nvl(vsize(l.ITEM_DESCRIPTION || '-' || cat.category_id || '-' || l.org_id || '-' || inst.instance_code || '-ONETIME'), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize(cat.category_id||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(substr(l.ITEM_DESCRIPTION || '('|| cat.CONCATENATED_SEGMENTS || ',' || l.org_id|| ')',1,240)), 0)) +
avg(nvl(vsize(substr(l.ITEM_DESCRIPTION || '(' || cat.CONCATENATED_SEGMENTS || ',' || l.org_id|| ')',1,80)), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize('Y'), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(l.item_description), 0)) +
avg(nvl(vsize(l.org_id), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(null), 0)) +
avg(nvl(vsize(min(l.creation_date)), 0)) +
avg(nvl(vsize(max(l.last_update_date)), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
47
From
mtl_categories_kfv cat,
po_lines_all l,
edw_local_instance inst
WHERE cat.category_id = l.category_id
and l.item_id is null
and l.last_update_date between
p_from_date and p_to_date
Group by
l.ITEM_DESCRIPTION,
l.org_id,
cat.category_id,
cat.CONCATENATED_SEGMENTS,
inst.instance_code ;
SELECT distinct
avg(nvl(vsize(l.ITEM_DESCRIPTION || '-' || cat.category_id || '-' || l.org_id|| '-' || inst.instance_code ||'-ONETIME'), 0)) +
avg(nvl(vsize(inst.instance_code), 0)) +
avg(nvl(vsize(cat.category_id || '-' || inst.instance_code), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize(substr(l.ITEM_DESCRIPTION || '(' || cat.CONCATENATED_SEGMENTS|| ')',1,240)), 0)) +
avg(nvl(vsize(substr(l.ITEM_DESCRIPTION || '(' || cat.CONCATENATED_SEGMENTS|| ')',1,80)), 0)) +
avg(nvl(vsize('Y'), 0)) +
avg(nvl(vsize(l.item_description), 0)) +
avg(nvl(vsize(NVL(l.item_description,'NA_EDW')), 0)) +
avg(nvl(vsize(min(l.creation_date)), 0)) +
avg(nvl(vsize(max(l.last_update_date)), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
17
From edw_local_instance inst,
mtl_categories_kfv cat,
po_lines_all l
WHERE cat.category_id = l.category_id
and l.item_id is null
and l.last_update_date between
p_from_date and p_to_date
Group by l.ITEM_DESCRIPTION,
l.org_id,
cat.category_id,
cat.concatenated_segments,
inst.instance_code;
SELECT
avg(nvl(vsize(mti.inventory_item_id||'-'||mtp.organization_id||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(mti.inventory_item_id||'-'||edw_items_pkg.get_master_parent(mtp.organization_id) ||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(mic.category_id ||'-'||inst.instance_code), 0)) +
avg(nvl(vsize('NA_EDW'), 0)) +
avg(nvl(vsize(substr(mti.concatenated_segments||'('||mtp.organization_code||')',1,240)), 0)) +
avg(nvl(vsize(substr(mti.concatenated_segments||'('||mtp.organization_code||')',1,80)), 0)) +
avg(nvl(vsize(decode(mti.buyer_id, NULL,'NA_EDW',to_char(mti.buyer_id)||'?')), 0)) +
avg(nvl(vsize(decode(mti.planner_code, NULL, 'NA_EDW', mti.planner_code||'?')), 0)) +
avg(nvl(vsize(substr(mti.concatenated_segments||'('||mtp.organization_code||')',1,240)), 0)) +
avg(nvl(vsize(mti.description), 0)) +
avg(nvl(vsize(mti.inventory_item_id), 0)) +
avg(nvl(vsize(mti.organization_id), 0)) +
avg(nvl(vsize(mti.planning_make_buy_code), 0)) +
avg(nvl(vsize(mti.list_price_per_unit), 0)) +
avg(nvl(vsize(mti.market_price), 0)) +
avg(nvl(vsize(mti.taxable_flag), 0)) +
avg(nvl(vsize(mti.stock_enabled_flag), 0)) +
avg(nvl(vsize(mti.internal_order_enabled_flag), 0)) +
avg(nvl(vsize(mti.inventory_planning_code), 0)) +
avg(nvl(vsize(mti.lot_control_code), 0)) +
avg(nvl(vsize(mti.outside_operation_flag), 0)) +
avg(nvl(vsize(mti.price_tolerance_percent), 0)) +
avg(nvl(vsize(mti.purchasing_enabled_flag), 0)) +
avg(nvl(vsize(mti.shelf_life_code), 0)) +
avg(nvl(vsize(mti.shelf_life_days), 0)) +
avg(nvl(vsize(mti.tax_code), 0)) +
avg(nvl(vsize(mti.revision_qty_control_code), 0)) +
avg(nvl(vsize(mti.inspection_required_flag), 0)) +
avg(nvl(vsize(mti.receipt_required_flag), 0)) +
avg(nvl(vsize(mti.location_control_code), 0)) +
avg(nvl(vsize(mti.effectivity_control), 0)) +
avg(nvl(vsize(mti.serial_number_control_code), 0)) +
avg(nvl(vsize(mti.mrp_planning_code), 0)) +
avg(nvl(vsize(mti.must_use_approved_vendor_flag), 0)) +
avg(nvl(vsize(mti.allow_substitute_receipts_flag), 0)) +
avg(nvl(vsize(mti.allow_unordered_receipts_flag), 0)) +
avg(nvl(vsize(mti.allow_express_delivery_flag), 0)) +
avg(nvl(vsize(mti.hazard_class_id), 0)) +
avg(nvl(vsize(mti.un_number_id), 0)) +
avg(nvl(vsize(mti.rfq_required_flag), 0)) +
avg(nvl(vsize(mti.creation_date), 0)) +
avg(nvl(vsize(mti.last_update_date), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(mti.segment1), 0)) +
45
FROM
mtl_system_items_kfv mti,
mtl_item_categories mic,
mtl_category_sets sets,
mtl_parameters mtp,
mtl_parameters mtm,
edw_local_instance inst
WHERE
mti.product_family_item_id is not null
and mti.organization_id = mtp.organization_id
and mic.inventory_item_id = mti.product_family_item_id
and mic.organization_id = mti.organization_id
and mic.category_set_id = sets.category_set_id
and sets.category_set_name = 'Product Family'
and mtp.master_organization_id = mtm.organization_id
and mti.last_update_date between
p_from_date and p_to_date;
SELECT
avg(nvl(vsize(mtc.category_id||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(inst.instance_code), 0)) +
avg(nvl(vsize('ALL'), 0)) +
avg(nvl(vsize(substr(mtc.concatenated_segments,1,240)), 0)) +
avg(nvl(vsize(substr(mtc.concatenated_segments,1,80)), 0)) +
avg(nvl(vsize(mtc.description), 0)) +
avg(nvl(vsize(mts.category_set_name), 0)) +
avg(nvl(vsize(mtc.category_id), 0)) +
avg(nvl(vsize(mtc.creation_date), 0)) +
avg(nvl(vsize(greatest(mtc.last_update_date, mts.last_update_date)), 0)) +
avg(nvl(vsize(NULL), 0)) +
11
from
mtl_categories_kfv mtc,
mtl_category_sets mts,
edw_local_instance inst
WHERE mtc.structure_id = mts.structure_id
and mts.control_level = 1
and mtc.last_update_date between
p_from_date and p_to_date;
SELECT
avg(nvl(vsize(mtc.category_id ||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(inst.instance_code), 0)) +
avg(nvl(vsize('ALL'), 0)) +
avg(nvl(vsize(substr(mtc.concatenated_segments,1,240)), 0)) +
avg(nvl(vsize(substr(mtc.concatenated_segments,1,80)), 0)) +
avg(nvl(vsize(mtc.description), 0)) +
avg(nvl(vsize(mts.category_set_name), 0)) +
avg(nvl(vsize(mtc.category_id), 0)) +
avg(nvl(vsize(mtc.creation_date), 0)) +
avg(nvl(vsize(greatest(mtc.last_update_date, mts.last_update_date)), 0)) +
avg(nvl(vsize(NULL), 0)) +
11
from mtl_categories_kfv mtc,
mtl_category_sets mts,
edw_local_instance inst
WHERE mtc.structure_id = mts.structure_id
and mtc.last_update_date between
p_from_date and p_to_date;
SELECT
avg(nvl(vsize(cats.category_id ||'-'||inst.instance_code), 0)) +
avg(nvl(vsize(inst.instance_code), 0)) +
avg(nvl(vsize('ALL'), 0)) +
avg(nvl(vsize(substr(CATS.CONCATENATED_SEGMENTS,1,240)), 0)) +
avg(nvl(vsize(substr(CATS.CONCATENATED_SEGMENTS,1,80)), 0)) +
avg(nvl(vsize(substr(cats.concatenated_segments,1,240)), 0)) +
avg(nvl(vsize(cats.description), 0)) +
avg(nvl(vsize(cats.creation_date), 0)) +
avg(nvl(vsize(cats.last_update_date), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
15
FROM
mtl_categories_kfv cats,
mtl_category_sets sets,
edw_local_instance inst
WHERE
cats.structure_id = sets.structure_id
and sets.category_set_name = 'Product Family'
and cats.last_update_date between
p_from_date and p_to_date;
SELECT
avg(nvl(vsize(CD.INTEREST_CODE_ID || '-' || INST.INSTANCE_CODE || '-PRIM_CODE'), 0)) +
avg(nvl(vsize(INTYP.INTEREST_TYPE_ID || '-' || INST.INSTANCE_CODE || '-INTR_TYPE'), 0)) +
avg(nvl(vsize(CD.CODE ||'(' || INTYP.INTEREST_TYPE || ')'), 0)) +
avg(nvl(vsize(CD.CODE), 0)) +
avg(nvl(vsize(CD.DESCRIPTION), 0)) +
avg(nvl(vsize(CD.INTEREST_CODE_ID), 0)) +
avg(nvl(vsize(CD.MASTER_ENABLED_FLAG), 0)) +
avg(nvl(vsize(INST.INSTANCE_CODE), 0)) +
avg(nvl(vsize(CD.CREATION_DATE), 0)) +
avg(nvl(vsize(GREATEST(CD.LAST_UPDATE_DATE, INTYP.LAST_UPDATE_DATE)), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(TO_DATE(NULL)), 0)) +
16
FROM
AS_INTEREST_CODES_V CD ,
AS_INTEREST_TYPES_V INTYP ,
EDW_LOCAL_INSTANCE INST
WHERE
CD.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID
AND CD.PARENT_INTEREST_CODE_ID IS NULL
AND INTYP.EXPECTED_PURCHASE_FLAG = 'Y'
AND ( ( CD.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') )
OR (INTYP.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') ) )
and cd.last_update_date between
p_from_date and p_to_date;
SELECT
avg(nvl(vsize(SCD.INTEREST_CODE_ID || '-' || INST.INSTANCE_CODE || '-SECN_CODE'), 0)) +
avg(nvl(vsize(PCD.INTEREST_CODE_ID || '-' || INST.INSTANCE_CODE || '-PRIM_CODE'), 0)) +
avg(nvl(vsize(SCD.CODE ||'(' || PCD.CODE || ')' || '(' || INTYP.INTEREST_TYPE || ')'), 0)) +
avg(nvl(vsize(SCD.CODE), 0)) +
avg(nvl(vsize(SCD.DESCRIPTION), 0)) +
avg(nvl(vsize(SCD.INTEREST_CODE_ID), 0)) +
avg(nvl(vsize(SCD.MASTER_ENABLED_FLAG), 0)) +
avg(nvl(vsize(INST.INSTANCE_CODE), 0)) +
avg(nvl(vsize(SCD.CREATION_DATE), 0)) +
avg(nvl(vsize(GREATEST(SCD.LAST_UPDATE_DATE, PCD.LAST_UPDATE_DATE, INTYP.LAST_UPDATE_DATE)), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(TO_DATE(NULL)), 0)) +
16
FROM
AS_INTEREST_CODES_V SCD ,
AS_INTEREST_CODES_V PCD ,
AS_INTEREST_TYPES_V INTYP ,
EDW_LOCAL_INSTANCE INST
WHERE
SCD.PARENT_INTEREST_CODE_ID = PCD.INTEREST_CODE_ID
AND PCD.PARENT_INTEREST_CODE_ID IS NULL
AND SCD.INTEREST_TYPE_ID = PCD.INTEREST_TYPE_ID
AND PCD.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID
AND INTYP.EXPECTED_PURCHASE_FLAG = 'Y'
AND ( ( SCD.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') )
OR ( PCD.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') )
OR (INTYP.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') ) )
and scd.last_update_date between
p_from_date and p_to_date;
SELECT
avg(nvl(vsize(INTYP.INTEREST_TYPE_ID || '-' || INST.INSTANCE_CODE || '-INTR_TYPE'), 0)) +
avg(nvl(vsize('ALL'), 0)) +
avg(nvl(vsize(INTYP.INTEREST_TYPE), 0)) +
avg(nvl(vsize(INTYP.INTEREST_TYPE), 0)) +
avg(nvl(vsize(INTYP.DESCRIPTION), 0)) +
avg(nvl(vsize(INTYP.INTEREST_TYPE_ID), 0)) +
avg(nvl(vsize(INTYP.MASTER_ENABLED_FLAG), 0)) +
avg(nvl(vsize(INST.INSTANCE_CODE), 0)) +
avg(nvl(vsize(INTYP.CREATION_DATE), 0)) +
avg(nvl(vsize(INTYP.LAST_UPDATE_DATE), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(NULL), 0)) +
avg(nvl(vsize(TO_DATE(NULL)), 0)) +
16
FROM
AS_INTEREST_TYPES_V INTYP ,
EDW_LOCAL_INSTANCE INST
WHERE
INTYP.EXPECTED_PURCHASE_FLAG = 'Y'
and intyp.last_update_date between
p_from_date and p_to_date;