Sql 2

select * from prdmstee where PRD_LVL_CHILD= 29905
select * from prdpluee
select * from prdupcee
select * from SDIPRDMSI
select * from SDIREJCD where rej_code=577
select * from prdmstee where prd_name_full= 'Mandarina'
select * from prdctlee --where prd_lvl_id=1

select * from prdmstee
select * from PRDCTLEE

select * from prdsteee where PRD_LVL_CHILD= 29905
select * fromrplchgee where PRD_LVL_CHILD= 29905
select * from prdplvee where PRD_LVL_CHILD= 29905

Sdiprdba
select * from SDIPRDMSI

-- Producto
select * from prdmstee where prd_lvl_child >= 15349

-- 2) Insertar en la tabla SDI el registro estilo para la Dimension "TABLA GENERAL COLORES"
select * from VPCMSTEE order by vendor_number desc
insert into SDIPRDMSI
(batch_num, prd_lvl_number,prd_lvl_id, tran_type, prd_lvl_parent, prd_name_full, prd_targetgm, prd_style_ind,
prd_status, prd_inh_val, prd_pdh_name_1, prd_pdd_code_1, prd_pdh_name_2, prd_pdd_code_2, prd_pdh_name_3, prd_pdd_code_3,
date_created, download_date_1, download_date_2, prd_uom_size, prd_sll_uom, prd_comp_uom, prd_conv_qty, error_code,
prd_cross_dock,imp_dss_flag, vendor_number, alt_sll_uom_1, alt_sll_uom_2, var_weight_item, var_weight_type, prd_sku_type,
prd_shrink_rate, prd_waste_code, sll_uom_1_rate, sll_uom_2_rate, prd_size_uom, mandatory_plu, mandatory_prd_gtin,
mandatory_cp_gtin, prc_link_id, unit_height, unit_width, unit_depth, fill_color, package_type, manufacturer,
package_size,unit_of_measure, tray_quantity, tray_height, tray_width, tray_depth, case_quantity, case_height,
case_width, case_depth, matching_key_value, cont_mult, cont_type)
values
(2, '99999', 2, 'A', 'L0266', 'Mandarina', 50, 'F',
0, 0, null, null, null, null, null, null,
to_date('20121005','yyyymmdd'), null, null, null, null, null, null, null,
'F', 'F','90070630', null, null, 'F', null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
null, null, null, null, null);

-- Hacer COMMIT

-- 3) Ejecutar proceso de carga

/*

begin
SDIPRDBA(2);
end;

*/

-- 4) Revisar la tabla SDI con el número de batch para ver si existieron errores-- select * from SDIPRDMSI where batch_num=1

SELECT /*+ INDEX(PRDMSTEE PRDMSTEEI2) */
prd_lvl_child, prd_inh_val

FROM prdmstee
WHERE prd_lvl_number = prd.prd_lvl_parent
AND prd_lvl_id = prd.prd_lvl_id + 1
AND prd_style_ind = 'T';SELECT * FROM vpcmstee WHERE VENDOR_NUMBER =99999998 and vpc_tech_key=30061 Sdimsirej
select * from CHLRDVEE where VPC_TECH_KEY=30061
select * from Sdivpcmsi order by tech_key asc

SELECT * FROM Sdimsirej WHERE VENDOR_NUMBER =99999998
SELECT * FROM Sdivpcmsi WHERE VENDOR_NUMBER =99999998delete from Sdivpcmsi where VENDOR_NUMBER=99999998
SELECT * FROM IFHCHLRDVi WHERE VENDOR_NUMBER=99999998
select * from SDIREJCD where rej_code=819

insert into Sdivpcmsi
(
TECH_KEY ,TRAN_TYPE , VENDOR_NUMBER ,VENDOR_NAME,
CNTRY_CODE , CNTRY_NAME , CURR_CODE ,VPC_APT_KEY ,
VPC_APT_DESC ,VPC_PO_HRD_CPY,VPC_PO_TRANS ,VPC_PRDVPC_FLAG ,VPC_DISTVPC_FLAG ,VPC_SVCVPC_FLAG ,COMPANY_REGNO ,VAT_REGNO,EDI_ADDRESS ,
PRIMARY_CONTACT ,PRIMARY_EMAIL ,DATE_CREATED , DOWNLOAD_DATE_1 ,
DOWNLOAD_DATE_2 ,DMT_CODE ,VPC_STATUS_KEY , AUTO_ASSIGN_LOCS,SUBS_ACCEPTED ,
SUBS_METHOD ,POE_COUNTRY_CODE , POE_COUNTRY_NAME ,POE_CITY,
TAX_AREA_CODE...