807: v_FUNC_MSG VARCHAR2(1) := 'N';
808:
809: CURSOR c1 IS
810: SELECT *
811: FROM ddr_s_rtl_inv_item
812: WHERE (day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,inv_loc_id)
813: IN (SELECT day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,inv_loc_id
814: FROM ddr_s_rtl_inv_item
815: GROUP BY day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,inv_loc_id
810: SELECT *
811: FROM ddr_s_rtl_inv_item
812: WHERE (day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,inv_loc_id)
813: IN (SELECT day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,inv_loc_id
814: FROM ddr_s_rtl_inv_item
815: GROUP BY day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,inv_loc_id
816: HAVING count(*) > 1)
817: FOR UPDATE;
818: BEGIN
966: ,'Duplicate record - Staging'
967: );
968:
969: -- delete duplicate records from staging table --
970: DELETE ddr_s_rtl_inv_item
971: WHERE CURRENT OF c1;
972:
973: END LOOP; --}
974: