nakolkin

 IF debug THEN PERFORM summary_v2.debug_loger(run_id, function_name, 'CREATE INDEX on TEMPORARY TABLE'); END IF;
       CREATE INDEX tracking_campaign_details_raw_report_idx on tracking_campaign_details_raw_report_table (report_date, site_id, placement_id, creative_group_id, creative_id) ;

       IF debug THEN PERFORM summary_v2.debug_loger(run_id, function_name, 'Join AK data with _3pas data'); END IF;

       INSERT INTO tracking_campaign_details_raw_report_table_rez
          SELECT
              campaign_ids_in[j]::bigint,
              COALESCE(ak.report_date, _3pas.report_date) AS report_date,
              COALESCE(ak.site_id, _3pas.site_id::bigint) AS site_id,

nakolkin

SELECT audit.start_migration_log('$Id: //src/trunk/sql/migration/2014/Henri/NG-8837/proc/36_summary_v2_get_audience_delivery_details_report.sql#1 $');
--
-- Audience Delivery Details Report
-- ============================================================================

/*
CREATE TYPE summary_v2.audience_delivery_details_report_trackingv2_v5 AS (

        -- key and rbatch will pull the label base on taxonomy_attribute_id
        taxonomy_attribute_id   bigint,