Brands.sql

Source: DMF/PuC/AIF/Brands.sql

select * from brand_stg;
select count(1) from brand_ctrl;
 
select count(brand_id) from sap_slt_prod_pv1.wrf_brands;
select * from sap_slt_prod_pv1.wrf_brands;
 
select distinct kurst from sap_slt_prod_pv1.TCURF ;
 
select * from sap_slt_prod_pv1.WRF_BRANDS_T where language = 'E';
 
select brand_id from (
select to_number(brand_id) as brand_id from sap_slt_prod_pv1.wrf_brands order by brand_id ) having count(1) > 1;
 
SELECT * FROM sap_slt_prod_pv1.ZSTA_KTX where kennung = '03720' and status = 2 and langu = 'E'
 
select brand_type, count(1) from sap_slt_prod_pv1.wrf_brands group by brand_type 
 
 
select max(brand_id) from sap_slt_prod_pv1.wrf_brands where brand_type = 2 and brand_id <> 9999;
 
7000 --  soma 7000 ao IDs original dos OwnBrands
 
--3rd party brands keep the same id on merch hier
--own brands generate a new id on merch hier
 
 
select * from xref_zsta_stw2; -- export from SAP
 
 
 
TRUNCATE TABLE brand_ctrl;
insert into brand_ctrl select brand_id, brand_descr, sysdate, sysdate, 'DMF','DMF','I',NULL,NULL from sap_slt_prod_pv1.WRF_BRANDS_T